Cube Dimension - Customer Invoice

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.

ATTRIBUTES

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)

USED BY CUBE

Cube Name
SALES

ETL Information

BI Access View BI Component Recommended
Source Type
FACT_CUSTOMER_INVOICE_BI INVOFT On Line

Please refer to FACT_CUSTOMER_INVOICE