The Fenwick Gold Purchasing semantic model is organized in a star schema data model.
The Fact tables contain information about individual transactions from sources such as purchase orders, posted purchase invoices, and posted credit memos. Dimension tables provide additional context and attributes to the transactional data, such as vendor and product information.
Fact Tables
Fact tables store transactional data and support summarizations such as SUM, AVG, COUNT and more.
Purchases
The Purchases table is a composite table made up of records from three sub tables:
- Purchase Value Entries
- Purchase Lines from received not invoiced purchase orders
- Purchase Lines where the outstanding quantity is greater than zero
| Field | Description |
|---|---|
| Date | The date on which the transaction was made. For records related to Purchase 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 Purchase Order or Invoice. |
| Entry No | For value entries this is the entry no. For all other records this is the purchase line number. |
| Entry Type | For value entries this is the type of entry. For all other records the value is “Purchase Line” |
| Purchase Order No. | The associated Purchase Order No. on the transaction. |
| Source Type | A delineating field used to define the source table of the record. |
Purchase Budget
Vendor, Location and Item can filter purchase budgets.
| 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.