This cube dimension represents sales contract and is based on the IFS Applications dimension DIM_SALES_CONTRACT. All cubes that refers to this dimension will have the attributes and hierarchies as described below.
| Attribute | Hierarchy | Description |
| Sales Contract | NO | Key. Built as the CODE + ' - ' + CONTRACT_NAME |
| Sales Contract Bid Status | NO | Contract bid status (client value) (BID_STATUS) |
| Sales Contract Category 1 Desc | NO | Category 1 name (CATEGORY1_NAME) |
| Sales Contract Category 1 Name | NO | Description of category 1 name (CATEGORY1_DESC) |
| Sales Contract Category 2 Desc | NO | Category 2 name (CATEGORY2_NAME) |
| Sales Contract Category 2 Name | NO | Description of category 2 name (CATEGORY2_DESC) |
| Sales Contract Code | NO | The dimension CODE, i.e. the contract number |
| Sales Contract District Code | NO | The district code (DISTRICT_CODE) |
| Sales Contract District Desc | NO | The district description (DISTRICT_DESC) |
| Sales Contract Manager | NO | The contract manager identity (CONTRACT_MANAGER) |
| Sales Contract Manager Name | NO | The name of the contract manager ( CONTRACT_MANAGER_NAME) |
| Sales Contract Market Code | NO | The market code (MARKET_CODE) |
| Sales Contract Market Desc | NO | The market description (MARKET_DESC) |
| Sales Contract Multiple Prospects | NO | Are there multiple prospects for the contract? (MULTIPLE_PROSPECTS) |
| Sales Contract Name | NO | The sales contract name (CONTRACT_NAME) |
| Sales Contract Prime Contract No | NO | Primary contract number (ORIME_CONTRACT_NO) |
| Sales Contract Prospect Name | NO | Name of prospect (PROSPECT_NAME) |
| Sales Contract Ref | NO | Contract reference (CONTRACT_REF) |
| Sales Contract Region Code | NO | The sales region code (REGION_CODE) |
| Sales Contract Region Desc | NO | The sales region description (REGION_DESC) |
| Sales Contract Salesman | NO | Identity of salesman (SALESMAN) |
| Sales Contract Salesman Name | NO | The name of the salesman (SALESMAN_NAME) |
| Sales Contract State | NO | Status of sales contract (CONTRACT_STATE) |
| Sales Contract Sub State | NO | Sub status of the sales contract (SUB_STATE) |
| Sales Contract Sub State Desc | NO | Description of sub status (SUB_STATE_DESC) |
| Sales Contract Supply Country | NO | Client name of supply country (SUPPLY_COUNTRY) |
| Sales Contract Type | NO | Sales contract type (CONTRACT_TYPE) |
| Sales Contract Type Desc | NO | Description of sales contract type (CONTRACT_TYPE_DESC) |
| Sales Contract Win Probability | NO | Probability to win (WIN_PROBABILITY) |
| Cube Name |
| SALES CONTRACT |
| BI Access View | BI Component | Recommended Source Type |
| DIM_SALES_CONTRACT_BI | CONMDI | On Line |
| ETL Step | File Name of SSIS Package | Table Name |
| E - Stage | 1.1.089 Load IFSAppl_DIM_SALES_CONTRACT_BI.dtsx | IFSAppl_DIM_SALES_CONTRACT_BI |
| T - DW | 2.1.089 Load Dw_DIM_SALES_CONTRACT.dtsx | Dw_DIM_SALES_CONTRACT |
| L - DM | 3.1.089 Load Dm_DIM_SALES_CONTRACT.dtsx | Dm_DIM_SALES_CONTRACT |