This cube dimension represents sales contract item and is based on the IFS Applications dimension DIM_SALES_CONTRACT_ITEM. All cubes that refers to this dimension will have the attributes and hierarchies as described below.
Attribute | Hierarchy | Description |
Contract Item Code | NO | The CODE of the dimension, i.e. the sales contract item no (parent keys are CONTRACT_NO, REV_SEQ, LINE_NO) |
Contract Item Description | NO | The DESCRIPTION of the sales contract item |
Contract Item Id | NO | Key. Built as CONTRACT_NO + '^' + REV_SEQ + '^' + LINE_NO + '^' + ITEM_NO |
Contract Item Line No | NO | The LINE_NO for the sales contract item |
Contract Item Name | NO | The name of the sales contract item (ITEM_NAME) |
Contract Item Rev Seq | NO | Revision number of the sales contract item (REV_SEQ) |
Contract Item Rev State | NO | The (obj) state of the sales contract item revision |
Contract Item State | NO | The (obj) state of the sales contract item (ITEM_STATE) |
Contract No | NO | The contract number (CONTRACT_NO) the sales contract item belongs to |
Cube Name |
SALES CONTRACT |
BI Access View | BI Component | Recommended Source Type |
DIM_SALES_CONTRACT_ITEM_BI | CONMDI | On Line |
ETL Step | File Name of SSIS Package | Table Name |
E - Stage | 1.1.086 Load IFSAppl_DIM_SALES_CONTRACT_ITEM_BI.dtsx | IFSAppl_DIM_SALES_CONTRACT_ITEM_BI |
T - DW | 2.1.086 Load Dw_DIM_SALES_CONTRACT_ITEM.dtsx | Dw_DIM_SALES_CONTRACT_ITEM |
L - DM | 3.1.086 Load Dm_DIM_SALES_CONTRACT_ITEM.dtsx | Dm_DIM_SALES_CONTRACT_ITEM |