Project Contract

This table shows the LN table from which fields are retrieved for the dimension:

Table Description
tpctm100 Contract

This table shows the attribute mapping to LN table fields for the dimension:

Attribute Mapping
Acquiring Method tpctm100.ccam
Acquiring Method Desc tppdm063.desc
Bid number tpptctm100.bnum
Bid Version tpctm100.bver
Business Sector tpctm100.csec
Business Sector Desc tppdm055.desc
Category tpctm100.ccat
Category Desc tppdm075.desc
Company tpctm100.compnr
Contract Amount tpctm100.copr
Contract Award Date tpctm100.codt
Contract Execution tpctm100.coty
Contract Execution Filter tpctm100.coty
Contract Execution Sort tpctm100.coty
Contract Linked Project tpctm100.cprj
Contract Manager tpctm100.cmng
Contract Manager Name tccom001.nama
Contract Type tpctm100.ctyp
Contract Type Filter tpctm100.ctyp
Contract Type Sort tpctm100.ctyp
Currency tpctm100.ccur
Currency Desc tcmcs002.dsca
Drillback to LN Column used for drillback to LN
Effective Date tpctm100.efdt
Expiry Date tpctm100.exdt
External Sales Representative tpctm100.osrp
External Sales Representative Name tccom001.nama
Financial Company tpctm100.cono_fcmp
Financing Method tpctm100.cfac
Geographical Area tpctm100.creg
Geographical Area Desc tcmcs045.dsca
Group tpctm100.ccot
Group Desc tppdm065.desc
Hold Reason tpctm100.hrsn
Hold Reason Desc tcmcs005.dsca
Internal Sales Representative tpctm100.crep
Internal Sales Representative Name tccom001.nama
Invoice Delivery Method tpctm100.cidm
Invoice Discount tpctm100.disc
Invoice Type tpctm100.invm
Invoice Type Filter tpctm100.invm
Invoice Type Sort tpctm100.invm
Invoice to Address tpctm100.itad
Invoiced to Date tpctm100.itod
Invoicing Method tpctm100.cinm
Line of Business tpctm100.cbrn
Pay by Address tpctm100.pfad
Phase tpctm100.cstg
Phase Desc tppdm085.desc
Program tpctm100.prgm
Program Desc tpctm010.dsca
Program Manager tpctm100.prmg
Program Manager Name tccom001.nama
Progress Payment Invoicing Method tpctm100.ppim
Project Contract tpctm100.cono
Project Contract Company Desc tcemm170.desc
Project Contract Desc tpctm100.desc
Project Contract ID Desc tpctm100.cono + tpctm100.desc
Project Contract Financial Company Desc tcemm170.desc
Project Desc tppdm600.dsca
Sales Type tpctm100.csts
Status tpctm100.csts
Status Filter tpctm100.csts
Status Sort tpctm100.csts
Unknown 1 for null records, else 0
deleted 1 if deleted in LN, else 0
Custom Defined Fields Standard list of fields