Model: Cash Planning - Specifications for Dimension Table: SALES CONTRACT

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.

Attributes

AttributeDescription (where applicable)
Bid StatusBid Status
Category 1 DescCategory 1 Description
Category 1 NameCategory 1 Name
Category 2 DescCategory 2 Description
Category 2 NameCategory 2 Name
Contract ManagerContract Manager
Contract Manager NameContract Manager Name
Contract NameContract Name
Contract RefContract Reference
Contract StateContract State
Contract TypeContract Type
Contract Type DescContract Type Description
Customer NoteCustomer Note
District CodeDistrict Code
District DescDistrict Description
IDSales contract ID
Market CodeMarket Code
Market DescMarket Description
Multiple ProspectsMultiple Prospects
Prime Contract NoPrime Contract Number
Region CodeRegion Code
Region DescRegion Description
Sales Contract CodeSales Contract Code
Salesman CodeSalesman Code
Salesman NameSalesman Name
Sub StateSub State
Sub State DescSub State Description
Supply CountrySupply Country
Win ProbabilityWin Probability

USED BY MODEL(S)

Model Name
Cash Planning

Data source Information

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 TableDW Source view (SQL Server)BI Access ViewReferenced Information SourceRecommended Access Type
SALES CONTRACTDIM_SALES_CONTRACT_TMDIM_SALES_CONTRACT_BIDIM_SALES_CONTRACTOn Line