| 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 |