Project Contract Line
This table shows the LN tables from which fields are retrieved for the dimension:
| Table | Description |
|---|---|
| Contract Line | tpctm110 |
This table shows the attribute mapping to LN table fields for the dimension:
| Attribute | Mapping |
|---|---|
| Acquiring Method | tpctm110.ccam |
| Acquiring Method Desc | tppdm063.desc |
| Advance Payment Type | tpctm110.adtp |
| Advance Payment Type Filter | tpctm110.adtp |
| Advance Payment Type Sort | tpctm110.adtp |
| Advance Payments | tpctm110.advn |
| Advance Payments Filter | tpctm110.advn |
| Advance Payments Sort | tpctm110.advn |
| Approved for Invoicing | tpctm110.ivam |
| Base for Performance Obligation | tpctm110.pfob |
| Base for Performance Obligation Filter | tpctm110.pfob |
| Base for Performance Obligation Sort | tpctm110.pfob |
| Billable Cost Report | tpctm110.bcrp |
| Billable Cost Report Filter | tpctm110.bcrp |
| Billable Cost Report Sort | tpctm110.bcrp |
| Billing Cycle | tpctm110.blcl |
| Business Sector | tpctm110.csec |
| Business Sector Desc | tppdm055.desc |
| CLIN Project | tpctm110.ccat |
| Category | tpctm110.cprj |
| Category Desc | tppdm075.desc |
| Company | tpctm110.compnr |
| Contract Award Date | tpctm110.codt |
| Contract Delivery Date | tpctm110.rddt |
| Contract Execution | tpctm110.coty |
| Contract Execution Filter | tpctm110.coty |
| Contract Execution Sort | tpctm110.coty |
| Contract Manager | tpctm110.cmng |
| Contract Manager Name | tccom001.nama |
| Contract Type | tpctm110.ctyp |
| Contract Type Filter | tpctm110.ctyp |
| Contract Type Sort | tpctm110.ctyp |
| Currency | tpctm110.ccur |
| Effective Date | tpctm110.efdt |
| Expiry Date | tpctm110.exdt |
| External Sales Representative | tpctm110.osrp |
| External Sales Representative Name | tccom001.nama |
| Financial Company | tpctm110.cnln_fmcp |
| Financing Method | tpctm110.cfac |
| Geographical Area | tpctm110.creg |
| Geographical Area Desc | tcmcs045.dsca |
| Group | tpctm110.ccot |
| Group Desc | tppdm065.desc |
| Hold Reason | tpctm110.hrsn |
| Hold Reason Desc | tcmcs005.dsca |
| Holdback Percentage | tpctm110.hbpc |
| Installment Type | tpctm110.tins |
| Installment Type Filter | tpctm110.tins |
| Installment Type Sort | tpctm110.tins |
| Internal Sales Representative | tpctm110.crep |
| Internal Sales Representative Name | tccom001.nama |
| Invoice Type | tpctm110.invm |
| Invoice Type Filter | tpctm110.invm |
| Invoice Type Sort | tpctm110.invm |
| Invoice-to Address | tpctm110.itad |
| Invoiced to Date | tpctm110.itod |
| Invoicing Method | tpctm110.cinm |
| Labor B-Account | tpctm110.pcba |
| Labor Part of Contract Amount | tpctm110.pcwa |
| Line of Business | tpctm110.lpad |
| Liquidation Advances | tpctm110.lpad |
| Markup Equipment | tpctm110.pceq |
| Markup Labor | tpctm110.pcts |
| Markup Material | tpctm110.pcit |
| Markup Subcontracting | tpctm110.pcsb |
| Markup Sundry Cost | tpctm110.pcic |
| Pay-by Address | tpctm110.pfad |
| Phase | tpctm110.cstg |
| Phase Desc | tppdm085.desc |
| Program Desc | tpctm010.dsca |
| Progress Payment Invoicing Method | tpctm110.ppim |
| Progress Threshold | tpctm110.ptsh |
| Project Contract | tpctm110.cono |
| Project Contract Desc | tpptc100.desc |
| Project Contract Line | tpctm110.cnln |
| Project Contract Line Desc | tpctm110.desc |
| Project Contract Line Company Desc | tcemm170.desc |
| Project Contract Line Financial Company Desc | tcemm170.desc |
| Project Contract Line ID Desc | tpctm110.cnln + tcemm170.desc |
| Project Desc | tppdm600.dsca |
| Service Office | tpctm110.srvo |
| Ship from Address | tpctm100.sadr |
| Status | tpctm110.csts |
| Status Filter | tpctm110.csts |
| Status Sort | tpctm110.csts |
| Unknown | 1 for null records, else 0 |
| deleted | 1 if deleted in LN, else 0 |
| Customer Defined Fields | Standard list of fields |