The Sales Invoice Item Star Schema combines following dimension and fact tables:
Dimension/Fact | Description |
---|---|
PurchaseInvoiceItemFact | Fact table having transaction records regarding Invoice items |
DateDimension | Dimension table having attributes regarding the date dimension id in the fact table |
SupplierDimension | Dimension table having attributes regarding the supplier dimension id in the fact table |
OrganisationDimension | Dimension table having attributes regarding the organisation dimension id in the fact table |
ProductDimension | Dimension table having attributes regarding the product dimension id in the fact table |
CurrencyDimension | Dimension table having attributes regarding the currency dimension id in the fact table |