On this page you will find the specifications regarding the Model: Cash Planning and Dimension Table: SALES CONTRACT.
This dimension contains the information on Sales Contract.
| Attribute | Description (where applicable) |
| Bid Status | Bid Status |
| Category 1 Desc | Category 1 Description |
| Category 1 Name | Category 1 Name |
| Category 2 Desc | Category 2 Description |
| Category 2 Name | Category 2 Name |
| Contract Manager | Contract Manager |
| Contract Manager Name | Contract Manager Name |
| Contract Name | Contract Name |
| Contract Ref | Contract Reference |
| Contract State | Contract State |
| Contract Type | Contract Type |
| Contract Type Desc | Contract Type Description |
| Customer Note | Customer Note |
| District Code | District Code |
| District Desc | District Description |
| ID | Sales contract ID |
| Market Code | Market Code |
| Market Desc | Market Description |
| Multiple Prospects | Multiple Prospects |
| Prime Contract No | Prime Contract Number |
| Region Code | Region Code |
| Region Desc | Region Description |
| Sales Contract Code | Sales Contract Code |
| Salesman Code | Salesman Code |
| Salesman Name | Salesman Name |
| Sub State | Sub State |
| Sub State Desc | Sub State Description |
| Supply Country | Supply Country |
| Win Probability | Win Probability |
| Model Name |
| Cash Planning |
The data source for this object is defined using IFS Developer Tool. The data source contains a number of transformations where the model reads data from the last step, i.e. the Data source view name (DW Source View Name).
| Model Table | DW Source view (SQL Server) | BI Access View | Referenced Information Source | Recommended Access Type |
| SALES CONTRACT | DIM_SALES_CONTRACT_TM | DIM_SALES_CONTRACT_BI | DIM_SALES_CONTRACT | On Line |