Measures
Measure | Mapping | Note |
---|---|---|
Actual Hours | tpppc200.quan for labor cost type | |
Actual Quantity | tpppc200.quan | |
Amount to be Invoiced | tppin040.htai | |
Anticipated Amount | tppin010.amnt tppin020.insa - (tppin020.insa * tppin020.disc) - Overdue Amount tppin020.inaa - (tppin020.inaa * tppin020.disc) - tppin020.tiaa tppin040.hbai tppin050.amos tpppc200.amos tpptc050.copr\ tpptc311.amoc\ tpppc200.amoc based extension type tppin080.iamt tppin060.samt |
Planned invoice date or next billing date is before the current date and is not yet invoiced (includes advances) |
Anticipated Amount Excluding Advances | tppin010.amnt tppin020.insa - (tppin020.insa * tppin020.disc) - Overdue Amount tppin020.inaa - (tppin020.inaa * tppin020.disc) - tppin020.tiaa tppin040.hbai tppin050.amos tpppc200.amos tpptc050.copr\ tpptc311.amoc\ tpppc200.amoc based extension type tppin080.iamt tppin060.samt |
Planned invoice date or next billing date is before the current date and is not yet invoiced (excluding advances) |
Billable Amount | tppin080.iamt | |
Billed Amount | tpppc305.amor | When invoiced document is updated (includes advances) |
Billed Amount Excluding advances | tpppc305.amor | When invoiced document is updated (excludes advances) |
Billed Unit Rate Quantity | tppin050.quan and tppin050.idoc is not empty | |
Canceled Hold back Amount | tppin040.amoc when holdback is canceled | |
Contract Amount | tpptc050.copr | |
Cost Amount | tppdm700.camt | |
Holdback Amount | tppin040.hbai | |
Installment Amount to be billed | tppin020.amoc which is approved and not yet invoiced | |
Installment Amount to be Billed after Discount | tppin020.amoc which is approved and not yet invoiced and minus the discount | |
Installment Billed Amount | tppin020.amoc which is approved and invoiced | |
Overdue Amount | tppin010.amnt tppin020.inia - (tppin020.inia * tppin020.disc) tppin020.iiaa - (tppin020.iiaa * tppin020.disc) tppin040.hbai tpin050.amos tpppc200.amos tpptc050.copr\ tpptc311.amoc\ tpppc200.amoc based extension type tppin080.iamt tppin060.samt |
When planned invoice date or next billing date is after the current date and is not yet invoiced (includes advances) |
Overdue Amount Excluding Advances | tppin010.amnt tppin020.iiaa - (tppin020.iiaa * tppin020.disc) tppin020.iiaa - (tppin020.iiaa * tppin020.disc) tppin040.hbai tppin050.amos tpppc200.amos tpptc050.copr\ tpptc311.amoc\ tpppc200.amoc based extension type tppin080.iamt tppin060.samt |
When planned invoice date or next billing date is after the current date and is not yet invoiced (excludes advances) |
Project Contract Revenue Count | Fact count sourced from tppin010\ tppn011\ tppin020\ tppin040\ tppin050\ tpppc200\ tpppc301\ tpppc305 | |
Sales Amount | tppin060.samt | |
Settled Amount | tppin011.amnt | |
Settlement Amount | tppdm700.amts | |
Total Bill Amount | tppin010.amnt tppin020.insa tppin020.inaa tppin040.hbai tppin050.amos tpppc301.amor tpppc200.amos tpptc050.copr\ tpptc311.amoc\ tpppc200.amoc based extension type tppin080.iamt tppin060.samt tppdm700.samt |
|
Total Installment Amount after Discount | tppin020.amoc minus discount |