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.


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
DateThe 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 TypeThe type of document or record associated with the transaction, such as Purchase Order or Invoice.
Entry NoFor value entries this is the entry no. For all other records this is the purchase line number.
Entry TypeFor 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 TypeA delineating field used to define the source table of the record.

Purchase Budget

Vendor, Location and Item can filter purchase budgets.

Budget NameSpecifies the name of the item budget associated with budget entry.
DateBudget 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.