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 |