| Bank Check Amount |
PayablesInvoicePayment.BankCheckAmount |
| Base Withholding Amount |
PayablesInvoicePayment.BaseWithholdingAmount |
| Days To Pay Invoice |
Days between InvoiceDate and CheckDate |
| Discount Amount Applied |
IF PaymentStatus = Historical AND VoidSequence = 0 AND DiscountAmountCurrencyAmount <> 0 AND DiscountLost = false THEN DiscountAmountCurrencyAmount
|
| Discount Amount Lost |
IF PaymentStatus = Historical AND VoidSequence = 0 AND DiscountLost = true THEN DiscountAmountCurrencyAmount
|
| Discount Elig Payments Count |
Count IF PaymentStatus = Historical AND VoidSequence = 0 AND DiscountAmountCurrencyAmount <> 0
|
| Discount Lost Count |
Count IF PaymentStatus = Historical AND VoidSequence = 0 AND DiscountLost = true
|
| Discounted Payments Count |
Count IF PaymentStatus = Historical AND VoidSequence = 0 AND DiscountAmountCurrencyAmount <> 0 AND DiscountLost = false
|
| Income Withholding Percent |
PayablesInvoicePayment.IncomeWithholdingPercent |
| Invoiced Electronically Count |
Count IF InvoiceSource = EDI
|
| Net Payment Currency Amount |
PayablesInvoicePayment.NetPaymentAmountCurrencyAmount |
| Net Payment Functional Amount |
PayablesInvoicePayment.NetPaymentAmountFunctionalAmountEnteredCurrencyAmount |
| Paid Amount |
IF PaymentStatus = Historical AND VoidSequence = 0 THEN PayablesInvoicePayment.PaymentAmountCurrencyAmount
|
| Paid Electronically Count |
Count IF PaymentOutputOption = Electronic File
|
| Paid In Full Count |
Count IF PaymentStatus = Historical AND PaidInvoice = true
|
| Paid Invoice Count |
COUNT IF IsInvoicePaid = true
|
| Paid Late Count |
Count IF PaymentStatus = Historical AND VoidSequence = 0 AND CheckDate > DueDate AND DueDate <> NULL
|
| Paid On Time Count |
Count IF PaymentStatus = Historical AND VoidSequence = 0 AND CheckDate <= DueDate AND DueDate <> NULL
|
| Paid Partial Count |
Count IF IsSplitPayment = true AND PaymentStatus = Historical OR SeparatePayment = true
|
| Paid Within Terms |
Count IF PaymentStatus = Historical AND VoidSequence = 0 AND CheckDate <= DiscountDate AND DiscountDate <> NULL
|
| Payables Invoice Amount |
PayablesInvoicePayment.PayablesInvoiceInvoiceAmountCurrencyAmount |
| Payables Invoice Payment Count |
Count of each payment record |
| Payment Amount Currency Amount |
PayableInvoicePayment.PaymentAmountCurrencyAmount |
| Payment Amount Functional Amount |
PayablesInvoicePayment.PaymentAmountFunctionalAmountEnteredCurrencyAmount |
| Payment Count |
Count IF PaymentStatus = Historical AND VoidSequence = 0
|
| Received Discount Count |
Count IF PaymentStatus = Historical AND VoidSequence = 0 AND DiscountLost = false AND PayablesInvoiceDiscountAmount1 <> 0
|
| Released for Payment Count |
Count IF PaymentStatus = Released
|
| Rush Payment Amount |
IF PayImmediately = true THEN PayablesInvoicePayment.PaymentAmountCurrencyAmount
|
| Rush Payment Count |
Count IF PayImmediately = true
|
| Secondary Withholding Transaction Amount 1 |
PayablesInvoicePayment.SecondaryWithholdingBaseAmount1 |
| Secondary Withholding Transaction Amount 2 |
PayablesInvoicePayment.SecondaryWithholdingBaseAmount2 |
| Secondary Withholding Transaction Amount 3 |
PayablesInvoicePayment.SecondaryWithholdingBaseAmount3 |
| System Generated Payment Count |
Count IF PaymentStatus = SystemGeneratedPayment
|
| Unreleased Payment Count |
Count IF PaymentStatus = Unreleased
|
| Vendor Payment Amount |
PayablesInvoicePayment.VendorPaymentAmount |
| Void Payment Amount |
IF IsVoidCash = true THEN PayablesInvoicePayment.PaymentAmountCurrencyAmount
|
| Void Payment Count |
Count IF IsVoidCash = true
|
| Withholding Amount |
PayablesInvoicePayment.WithholdingAmount |