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 |