Access to add and change pages is restricted. See: https://cwiki.apache.org/confluence/display/OFBIZ/Wiki+access

  • Created by Unknown User (pierresmits) on Mar 19, 2020 1 minute read

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »

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

Dimension/FactDescription
SalesInvoiceItemFactFact 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
  • No labels