Amount Paid |
PayablesInvoice.AmountPaid |
API Total Accrued Taxable Amount |
PayablesInvoiceTax.TotalAccruedTaxableAmount |
API Total Accrued Tax Amount |
PayablesInvoiceTax.TotalAccruedTaxAmount |
API Total Invoiced Taxable Amount |
PayablesInvoiceTax.TotalInvoicedTaxableAmount |
API Total Invoiced Tax Amount |
PayablesInvoiceTax.TotalInvoicedTaxAmount |
Customs Total |
PayablesInvoice.CustomsTotal |
Discount Amount 1 |
PayablesInvoice.DiscountAmount1 – 3 |
Discount Currency Amount |
PayablesInvoice.DiscountCurrencyAmount |
Discount Functional Amount |
PayablesInvoice.DiscountFunctionalAmount |
Distribution Amount Functional Amount |
PayablesInvoice.DistributionAmountFunctionalAmount |
Distribution Amount Project Total |
PayablesInvoice.DistributionAmountProjectTotal |
Distribution Amount Transaction Total |
PayablesInvoice.DistributionAmountTransactionTotal |
Invoice Count |
PayablesInvoice record count |
Invoice Currency Amount |
PayablesInvoice.InvoiceCurrencyAmount |
Invoice Currency Amount LY |
Sum (PayablesInvoice.CurrencyAmount Sum Last Year) (same
period) |
Invoiced Electronically Count |
Count IF InvoiceSource = EDI |
Invoice Functional Amount |
PayablesInvoice.InvoiceFunctionalAmount |
Match Amount |
PayablesInvoice.MatchAmount |
Matched Add On Charge Amount |
PayablesInvoice.MatchAOCAmount |
Open Invoice Amount |
PayablesInvoice.Open Invoice Amount |
Open Invoice Count |
Count IF Status <> Cancelled, Paid or Historical |
Other AOC Total |
SUM PayablesInvoice.OtherAOC |
Payables Invoice Approval Cycle Duration Days |
Duration of days between Submitted Time Stamp and Approved Time Stamp |
Payables Invoice Approval Cycle Duration Hours |
Duration of hours between Submitted Time Stamp and Approved Time Stamp |
Payables Invoice Full Approval Cycle Duration Days |
Duration of days between Original Submitted Date and Approved Time Stamp |
Payables Invoice Full Approval Cycle Duration Hours |
Duration of hours between Original Submitted Date and Approved Time Stamp |
Payment Amount Functional Total |
PayablesInvoice.PaymentAmountFunctionalTotal |
Payment Amount Project Total |
PayablesInvoice.PaymentAmountProjectTotal |
Payment Amount Transaction Total |
PayablesInvoice.PaymentAmountTransactionTotal |
PO Tax Amount |
PayablesInvoice.POTaxAmount |
Retainage Amount |
PayablesInvoice.RetainageAmount |
Retainage Payment Amount |
PayablesInvoice.RetainagePaymentAmount |
Service Amount |
PayablesInvoice.ServiceAmount |
Taxable Amount |
PayablesInvoice.TaxableAmount |
Tax Amount |
PayablesInvoice.TaxAmount |
Total Taxable Amount |
PayablesInvoice.TotalTaxableAmount |
Total Tax Amount |
PayablesInvoice.TotalTaxAmount |