This cube only dimension represents customer invoices and it is based on the fact FACT_CUSTOMER_INVOICE in IFS applications. There is no associated dimension in IFS Applications. All cubes that refers to this dimension will have the attributes and hierarchies as described below.
Natural parent is company, i.e. each company has its own set of customer invoices.
Attribute | Hierarchy | Description |
Customer Invoice | NO | Key. Defined as COMPANY_KEY + ' - ' + INVOICE_ID_KEY represented by the ETL column CUSTOMER_INVOICE. |
Customer Invoice Company | NO | The natural parent, company (COMPANY_KEY) |
Customer Invoice Id | NO | The invoice identity (INVOICE_ID_KEY) |
Customer Invoice No | NO | The invoice number (INVOICE_NO) |
Customer Invoice Series No | NO | The invoice series id (SERIES_ID) |
Customer Invoice State | NO | The invoice state (client value) |
Cube Name |
SALES |
BI Access View | BI Component | Recommended Source Type |
FACT_CUSTOMER_INVOICE_BI | INVOFT | On Line |
Please refer to FACT_CUSTOMER_INVOICE