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) |
| ID | Sales contract ID |
| Sales Contract Code | Sales Contract Code |
| Salesman Code | Salesman Code |
| Sub State | Sub State |
| Bid Status | Bid Status |
| Market Code | Market Code |
| Market Desc | Market Description |
| Region Code | Region Code |
| Region Desc | Region Description |
| Contract Ref | Contract Reference |
| Contract Name | Contract Name |
| Contract Type | Contract Type |
| Customer Note | Customer Note |
| District Code | District Code |
| District Desc | District Description |
| Salesman Name | Salesman Name |
| 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 State | Contract State |
| Sub State Desc | Sub State Description |
| Supply Country | Supply Country |
| Win Probability | Win Probability |
| Contract Manager | Contract Manager |
| Prime Contract No | Prime Contract Number |
| Contract Type Desc | Contract Type Description |
| Multiple Prospects | Multiple Prospects |
| Contract Manager Name | Contract Manager Name |
| Model Name |
The data source for this object is defined using IFS Developer Tool. Further Transformations are done using Power BI.
Additional information can be found in the online documentation of Information Sources.
| Model Table | BI Access View | Referenced Information Source | Recommended Access Type |
| SALES CONTRACT | DIM_SALES_CONTRACT_BI | DIM_SALES_CONTRACT | On Line |