This cube dimension represents customer invoice type and is based on the IFS Applications dimension DIM_CUSTOMER_INVOICE_TYPE. 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 invoice types.
Attribute | Hierarchy | Description |
Customer Invoice Type | NO | Key. Defined as COMPANY + ' - ' + CODE + ' - ' + DESCRIPTION represented by the ETL column COMPANY_CODE_DESCRIPTION. |
Customer Invoice Type Code | NO | The dimension CODE, i.e. customer invoice type |
Customer Invoice Type Company | NO | The natural parent company (COMPANY) |
Customer Invoice Type Descr | NO | The description of the customer invoice type |
Cube Name |
SALES |
BI Access View | BI Component | Recommended Source Type |
DIM_CUSTOMER_INVOICE_TYPE_BI | INVODI | On Line |
ETL Step | File Name of SSIS Package | Table Name |
E - Stage | 1.1.100 Load IFSAppl_DIM_CUSTOMER_INVOICE_TYPE_BI.dtsx | IFSAppl_DIM_CUSTOMER_INVOICE_TYPE_BI |
T - DW | 2.1.100 Load Dw_DIM_CUSTOMER_INVOICE_TYPE.dtsx | Dw_DIM_CUSTOMER_INVOICE_TYPE |
L - DM | 3.1.100 Load Dm_DIM_CUSTOMER_INVOICE_TYPE.dtsx | Dm_DIM_CUSTOMER_INVOICE_TYPE |