The Fenwick Gold Sales semantic model is organized in a star schema data model.
The Fact tables contain information about individual transactions from sources such as sales orders, posted sales invoices and posted credit memos. Dimension tables provide additional context and attributes to the transactional data, such as customer and product information.
Fact Tables
Fact tables store transactional data and support summarizations such as SUM, AVG, COUNT and more.
Sales
The sales table is a composite table made up of records from three sub tables:
- Sales Value Entries
- Sales Lines from shipped not invoiced sales orders
- Sales Lines where the outstanding quantity is greater than zero
| Field | Description |
|---|---|
| Date | The date on which the transaction was made. For records related to Sale Value Entries this is the Posting Date. For all other records this is Order Date. |
| Document No. | The unique identifier assigned to the document or record associated with the transaction. |
| Document Type | The type of document or record associated with the transaction, such as Sales Order or Invoice. |
| Entry No | For value entries this is the entry no. For all other records this is the sales line number. |
| Entry Type | For value entries this is the type of entry. For all other records the value is “Sales Line” |
| Source Type | A delineating field used to define the source table of the record. |
Sales Budget
Sales budgets can be filtered by Customer, Location and Item.
| Field | Description |
|---|---|
| Budget Name | Specifies the name of the item budget associated with budget entry. |
| Date | Budget date on the budget entry. |
| Entry No. | Budget entry number. |
Dimension Tables
Dimension tables in the context of a star schema data model support filtering and grouping.
Sales Budget Name Table
| Field | Description |
|---|---|
| Budget Name | Specifies the name of the item budget. |
| Budget Description | Specifies a description of the item budget. |