Project Contract Revenue Detail
This table shows the LN tables from which fields are retrieved for the dimension:
| Table | Description |
|---|---|
| tppin010 | Advances |
| tppin011 | Settled Advances |
| tppin020 | Installments |
| tppin040 | Holdback |
| tppin050 | Transferred Unit Rate Invoice Lines |
| tpppc301 | Revenues |
| tpppc305 | Revenue Transactions |
| tpppc200 | Cost Transactions |
This table shows the attribute mapping to LN table fields for the dimension:
| Attribute | Mapping |
|---|---|
| Actual Cost Type | tpppc200.comm.acts |
| Actual Delivery Time | tppn060.addt |
| Advance Payment | tppin010.sern tppin011.sern tpppc305.nadv |
| Advance Settled | tppin010.adsu |
| Advance Settled Filter | tppin010.adsu |
| Advance Settled Sort | tppin010.adsu |
| Approved for Invoicing | tppin010.invo tppin020.invo tppin040.invo tppin080.invo |
| Approved for Invoicing Filter | tppin010.invo tppin020.invo tppin040.invo |
| Approved for Invoicing Sort | tppin010.invo tppin020.invo tppin040.invo |
| Approved for Posting | tpppc301.cfpo |
| Approved for Posting Filter | tpppc301.cfpo |
| Approved for Posting Sort | tpppc301.cfpo |
| Billable | tpppc200.blbl |
| Billable Filter | tpppc200.blbl |
| Billable Sort | tpppc200.blbl |
| Budget Status | tpptc311.stat |
| Budget Status Filter | tpptc311.stat |
| Budget Status Sort | tpptc311.stat |
| Canceled | tppin040.cncl |
| Canceled Filter | tppin040.cncl |
| Canceled Sort | tppin040.cncl |
| Ceiling | tpptc050.ceil |
| Ceiling Filter | tpptc050.ceil |
| Ceiling Sort | tpptc050.ceil |
| Closed | tppin040.clos |
| Closed Filter | tppin040.clos |
| Closed Sort | tppin040.clos |
| Composed Invoice | tppin011.iseq |
| Contract Date | tpptc050.codt |
| Credit Advance | tppin011.adva |
| Cost Currency | tppdm700.cocu |
| Deliverable | tppin011.dlvr\ tppdm700.dlvr\ tppin040.dlvr\ tppin060.dlvr |
| Delivery Type Filter | tppdm700.delt |
| Delivery Type Sort | tppdm700.delt |
| Do Not Settle Advance | tppin010.dnse |
| Do Not Settle Advance Filter | tppin010.dnse |
| Do Not Settle Advance Sort | tppin010.dnse |
| Document | tppin302.cdoc |
| Employee | tppin040.emno tpppc301.emno tpppc305.emno |
| Equipment | tppin040.cequ |
| Extension Status | tpptc050.stls |
| Extension Status Filter | tpptc050.stls |
| Extension Status Sort | tpptc050.stls |
| Fee | tppin080.cfln |
| Fee Type | tppin080.ftyp |
| Fee Type Filter | tppin080.ftyp |
| Fee Type Sort | tppin080.ftyp |
| Finish Performance Period | tppin080.fprd |
| Finish time | tpptc050.fidt |
| General Sequence Number | tppin040.gseq |
| Holdback Sequence Number | tppin040.hbnr |
| Installment | tppin010.nins tppin011.nins tppin020.nins tppin040.nins tpppc305.nins |
| Invoice Calculation Method | tpptc050.stlm |
| Invoice Calculation Method Filter | tpptc050.stlm |
| Invoice Calculation Method Sort | tpptc050.stlm |
| Invoice Discount | tppin020.disc |
| Invoice Document | tppin010.idoc tppin011.idoc tppin040.idoc tppin050.idoc tppin060.idoc tppin080.idoc tpppc200.idoc tpppc305.idoc |
| Invoice Document Line | tppin011.idln tpppc305.iseq |
| Labor | tppin040.task |
| Material | tppin040.item |
| Original Advance | tppin010.oadv |
| Original Sequence Number | tppin040.osrn |
| Overhead | tppin040ovhd |
| Planned Invoice Date | tppin010.sidt tppin020.sidt tppin040.sidt tppin080.sidt |
| Post to LN Financials | tpppc301.potf |
| Post to LN Financials Filter | tpppc301.potf |
| Post to LN Financials Sort | tpppc301.potf |
| Posting Type | tpppc301.tetm tpppc305.tetl |
| Posting Type Filter | tpppc301.tetm tpppc305.tetl |
| Posting Type Sort | tpppc301.tetm tpppc305.tetl |
| Progress Date | tpppc305.prdt |
| Project Contract Revenue Detail Desc | Description from the respective table as mentioned in Project Contract Revenue Source |
| Project Contract Revenue Source | For:
|
| Registration Date | tppin050.pgdt tpppc200.rgdt tpppc301.rgdt |
| Return Deliverable | tppin060.rtor |
| Return Deliverable Filter | tppin060.rtor |
| Return Deliverable Sort | tppin060.rtor |
| Schedule | tppin011.schd\ tppdm700.schd\ tppin040.schd\ tpppc305.schd |
| Sequence Number | tpppc301.sern tpppc305.sern tppdm700.sern tppin060.sern |
| Settlement | tppin011.serl |
| Ship-to Address | tppdm700.stad |
| Shipment Line | tppin060.pono |
| Start Performance Period | tppin080.sprd |
| Status | tppdm700.stat |
| Status Filter | tppdm700.stat |
| Status Sort | tppdm700.stat |
| Subcontracting | tppin040.csub |
| Sundry | tppin040.cico |
| Suppressed for Next Billing Cycle | tpppc200.ntbl |
| Suppressed for Next Billing Filter | tpppc200.ntbl |
| Suppressed for Next Billing Sort | tpppc200.ntbl |
| Transaction Time | tpppc301.ltdt |
| Transaction Type | tppin011.ityp tppin040.ityp tpppc305.ityp |
| Type of Deliverable | tppdm700.tdel |
| Type of Deliverable Filter | tppdm700.tdel |
| Type of Deliverable Sort | tppdm700.tdel |
| Unit Rate Date | tppin040.urdt |
| Unit Rate Invoice Serial Number | tppin050.sern |
| User | tpppc301.loco |