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 |