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 |