Versions Compared

Old Version 1

changes.mady.by.user Unknown User (pierresmits)

Saved on

compared with

New Version Current

changes.mady.by.user Unknown User (pierresmits)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The Sales Invoice Item Star Schema combines following dimension and fact tables:

Dimension/FactDescription
SalesInvoiceItemFact
SalesInvoiceItem FactFact table having transaction records regarding Invoice items
DateDimensionDimension table having attributes regarding the date dimension id in the fact table
CustomerDimensionDimension table having attributes regarding the customer dimension id in the fact table
OrganisationDimensionDimension table having attributes regarding the organisation dimension id in the fact table
ProductDimensionDimension table having attributes regarding the product dimension id in the fact table
CurrencyDimensionDimension table having attributes regarding the currency dimension id in the fact table