Payables Payment measures

Measure name Table name Source field
AP Discount Amount APPAYMENT BASE_DISC_AMT
AP Discount Amount Applied APPAYMENT CASE WHEN APP.REC_STATUS = 9 AND APP.[DISC_LOST_FLG] <> 'Y' AND APP.[DISCOUNT_CODE] <> 'Y' THEN APP.[BASE_DISC_AMT] ELSE 0 EN
AP Discount Amount Lost APPAYMENT CASE WHEN APP.REC_STATUS = 9 AND APP.[DISC_LOST_FLG] = 'Y' THEN APP.[BASE_DISC_AMT] ELSE 0
AP Discount Lost Count APPAYMENT CASE WHEN APP.REC_STATUS = 9 AND APP.[DISC_LOST_FLG] = 'Y' AND APP.[BASE_DISC_AMT] <> 0 THEN 1 ELSE 0
Payment Count APPAYMENT PAYABLESINVOICEPAYMENCOUNT
AP Invoiced Electronically Count APINVOICE CASE WHEN API.INVOICE_SOURCE = 'E' THEN 1 ELSE 0 END
AP Invoices Paid APPAYMENT CASE WHEN APP.REC_STATUS = 9 THEN CASE WHEN APP.[BASE_CHK_AMT] <> 0 THEN 1 ELSE 0 END ELSE 0
AP Paid Amount APPAYMENT CASE WHEN APP.REC_STATUS = 9 THEN CASE WHEN APP.[BASE_CHK_AMT] <> 0 THEN APP.[BASE_CHK_AMT] ELSE 0 END ELSE 0 END
AP Paid Electronically Count APPAYMENT CASE WHEN APP.REC_STATUS = 9 AND CBBANKINST.OUTPUT_OPTION = 'T' THEN 1 ELSE 0 END
AP Paid In Full Count APPAYMENT CASE WHEN APP.REC_STATUS = 9 AND PURCHORDER.TOT_ORDER_AMT <= APP.TRAN_PMT_AMT THEN 1 ELSE 0 END
AP Paid On Time Count APPAYMENT CASE WHEN APP.REC_STATUS = 9 AND APP.CHECK_DATE <= APP.DUE_DATE THEN 1 ELSE 0 END
AP Paid Within Terms APPAYMENT CASE WHEN APP.REC_STATUS = 9 AND APP.CHECK_DATE <= APP.DISC_DATE THEN 1 ELSE 0 END
AP Payments Processed Count APPAYMENT CASE WHEN APP.REC_STATUS = 9 THEN 1 ELSE 0 END
AP Received Discount Count APPAYMENT CASE WHEN APP.[DISC_LOST_FLG] = 'Y' THEN 1 ELSE 0
Average Invoices per Operator APINVOICE, APPAYMENT INVOICE COUNT / API.OPERATOR[DISTINCT]
Days to Pay AP Invoice APPAYMENT, APINVOICE CASE WHEN APP.REC_STATUS = 9 THEN DATEDIFF(DAY, ISNULL( API.RCPT_INV_DATE, APINVOICE .[INVOICE_DTE]), APPAYMENT.[CHECK_DATE]) ELSE 0 END
Discount Elig Payments Count APPAYMENT CASE WHEN APP.REC_STATUS = 9 AND APP.[BASE_DISC_AMT] <> 0 THEN 1 ELSE 0 END
Discounted AP Payments Count APPAYMENT CASE WHEN APP.REC_STATUS = 9 AND APP.[DISC_LOST_FLG] <> 'Y' AND APP.[BASE_DISC_AMT] <> 0 THEN 1 ELSE 0
Eligible Discount Amount APPAYMENT CASE WHEN APP.REC_STATUS = 9 AND APP.[BASE_DISC_AMT] <> 0 THEN APP.[BASE_DISC_AMT] ELSE 0 END
Paid Amount PO APPAYMENT, APINVOICE CASE WHEN APP.REC_STATUS = 9 THEN CASE WHEN API.PO_NUMBER <> ' ' THEN APP.[BASE_CHK_AMT] ELSE 0 END ELSE 0 END
Paid Amount Exp APPAYMENT, APINVOICE CASE WHEN APP.REC_STATUS = 9 THEN CASE WHEN API.PO_NUMBER = ' ' THEN APP.[BASE_CHK_AMT] ELSE 0 END ELSE 0 END
Paid Late APPAYMENT INVOICE COUNT - CASE WHEN APP.REC_STATUS = 9 AND APP.CHECK_DATE <= APP.DUE_DATE THEN 1 ELSE 0 END
Payments Processed Count Exp APPAYMENT, APINVOICE CASE WHEN APP.REC_STATUS = 9 THEN CASE WHEN API.PO_NUMBER = ' ' THEN 1 ELSE 0 END ELSE 0
Payments Processed Count PO APPAYMENT, APINVOICE CASE WHEN APP.REC_STATUS = 9 THEN CASE WHEN API.PO_NUMBER <> ' ' THEN 1 ELSE 0 END ELSE 0
Percent Discount Amount Lost APPAYMENT CASE WHEN APP.REC_STATUS = 9 AND APP.[DISC_LOST_FLG] = 'Y' THEN APP.[BASE_DISC_AMT] ELSE 0 / CASE WHEN APP.REC_STATUS = 9 AND APP.[BASE_DISC_AMT] <> 0 THEN APP.[BASE_DISC_AMT] ELSE 0 END
Percent Discount Amount Taken APPAYMENT CASE WHEN APP.REC_STATUS = 9 AND APP.[DISC_LOST_FLG] <> 'Y' AND APP.[DISCOUNT_CODE] <> 'Y' THEN APP.[BASE_DISC_AMT] ELSE 0 END / CASE WHEN APP.REC_STATUS = 9 AND APP.[BASE_DISC_AMT] <> 0 THEN APP.[BASE_DISC_AMT] ELSE 0 END
Percent Discount Lost APPAYMENT CASE WHEN APP.REC_STATUS = 9 AND APP.[DISC_LOST_FLG] = 'Y' AND APP.[BASE_DISC_AMT] <> 0 THEN 1 ELSE 0 / CASE WHEN APP.REC_STATUS = 9 AND APP.[BASE_DISC_AMT] <> 0 THEN 1 ELSE 0 END
Percent Discounts Taken APPAYMENT CASE WHEN APP.REC_STATUS = 9 AND APP.[DISC_LOST_FLG] <> 'Y' AND APP.[BASE_DISC_AMT] <> 0 THEN 1 ELSE 0/ CASE WHEN APP.REC_STATUS = 9 AND APP.[BASE_DISC_AMT] <> 0 THEN 1 ELSE 0 END
Percent Invoiced Electronically APINVOICE CASE WHEN API.INVOICE_SOURCE = 'E' THEN 1 ELSE 0 / INVOICE COUNT
Percent Paid Electronically APPAYMENT CASE WHEN APP.REC_STATUS = 9 AND CBBANKINST.OUTPUT_OPTION = 'T' THEN 1 ELSE 0 / INVOICE COUNT
Percent Paid in Full APPAYMENT CASE WHEN APP.REC_STATUS = 9 AND PURCHORDER.TOT_ORDER_AMT <= APP.TRAN_PMT_AMT THEN 1 ELSE 0 END / INVOICE COUNT
Percent Paid on Time APPAYMENT CASE WHEN APP.REC_STATUS = 9 AND APP.CHECK_DATE <= APP.DUE_DATE THEN 1 ELSE 0 / INVOICE COUNT
Percent Paid within Terms APPAYMENT CASE WHEN APP.REC_STATUS = 9 AND APP.CHECK_DATE <= APP.DISC_DATE THEN 1 ELSE 0 END / INVOICE COUNT
Percent Payments with Errors APPAYMENT CASE WHEN (APP.[VOID_SEQ] <> 0) AND (APP.VOID_DATE > '1753-01-01 00:00:00.000') THEN APP.[BASE_PMT_AMT] ELSE 0 END / INVOICE COUNT
Percent Received Discount APPAYMENT CASE WHEN APP.[DISC_LOST_FLG] = 'Y' THEN 1 ELSE 0 END / INVOICE COUNT
Percent Rush Payments APPAYMENT CASE WHEN (APP.REC_STATUS = 9 OR APP.REC_STATUS IN(0,1,7)) AND APP.[PAY_IMM_FLAG] = 'Y' THEN 1 ELSE 0 END / INVOICE COUNT
Rush Payment Amount APPAYMENT CASE WHEN (APP.REC_STATUS = 9 OR APP.REC_STATUS IN(0,1,7)) AND APP.[PAY_IMM_FLAG] = 'Y' THEN APP.[TRAN_PMT_AMT] ELSE 0 END
Rush Payment Count APPAYMENT CASE WHEN (APP.REC_STATUS = 9 OR APP.REC_STATUS IN(0,1,7)) AND APP.[PAY_IMM_FLAG] = 'Y' THEN 1 ELSE 0 END
Void Payment Amount APPAYMENT CASE WHEN (APP.[VOID_SEQ] <> 0) AND (APP.VOID_DATE > '1753-01-01 00:00:00.000') THEN APP.[BASE_PMT_AMT] ELSE 0 END
Void Payment Count APPAYMENT CASE WHEN (APP.[VOID_SEQ] <> 0) AND (APP.VOID_DATE > '1753-01-01 00:00:00.000') THEN 1 ELSE 0 END