Credit Management Performance sourced measures and KPIs
This table shows the Credit Management Performance measures that are sourced directly in Data Warehouse.
Most measures have Avg, Max, Min, and Sum aggregations. For cases where this does not apply, the available aggregations are indicated in this table:
| Measure | Description |
|---|---|
| Amt by Day – Adj Due and Pmt – For Curr | The amount paid past the adjusted due date in the foreign currency multiplied by the number of days between the adjusted due date and the payment date |
| Amt by Day – Adj Due Date and Pmt | The amount paid past the adjusted due date in the division currency multiplied by the number of days between the adjusted due date and the payment date |
| Amt by Day – Adj Follow up and Pmt | The amount paid past the adjusted follow-up date in the division currency multiplied by the number of days between the adjusted follow-up date and the payment date |
| Amt by Day – Adj Follow up and Pmt – For Curr | The amount paid past the adjusted follow-up date in the foreign currency multiplied by the number of days between the adjusted follow-up date and the payment date |
| Amt by Day – Due and Pmt | The amount paid past the due date in the division currency multiplied by the number of days between the due date and the payment date |
| Amt by Day – Due and Pmt – For Curr | The amount paid past the due date in the foreign currency multiplied by the number of days between the due date and the payment date |
| Amt by Day – Follow up and Pmt | The amount paid past the follow-up date in the division currency multiplied by the number of days between the follow-up date and the payment date |
| Amt by Day – Follow up and Pmt – For Curr | The amount paid past the follow-up date in the foreign currency multiplied by the number of days between the follow-up date and the payment date |
| Amt by Day – Invoice and Pmt | The total payment amount in the division currency multiplied by the number of days between the invoice and payment dates |
| Amt by Day – Invoice and Pmt – For Curr | The total payment amount in the foreign currency multiplied by the number of days between the invoice and payment dates |
| Amt Paid Past Adj Due Date | The total amount paid past the due date including the defined credit limit 4 of a customer in the division currency |
| Amt Paid Past Adj Due Date – For Curr | The total amount paid past the due date including the defined credit limit 4 of a customer in the foreign currency |
| Amt Paid Past Adj Follow up | The total amount paid past the follow-up date including the defined credit limit 4 of a customer in the division currency |
| Amt Paid Past Adj Follow up – For Curr | The total amount paid past the follow-up date including the defined credit limit 4 of a customer in the foreign currency |
| Amt Paid Past Due Date | The total amount paid past the due date in the division currency |
| Amt Paid Past Due Date – For Curr | The total amount paid past the due date in the foreign currency |
| Amt Paid Past Follow up | The total amount paid past the follow-up date in the division currency |
| Amt Paid Past Follow up – For Curr | The total amount paid past the follow-up date in the foreign currency |
| Credit Limit 1 – For Curr | The payer's highest credit amount permitted for past due invoices in the payer's currency |
| Credit Limit 2 – For Curr | The payer's highest credit amount permitted for invoices that are open but not past due in the payer's currency |
| Credit Limit 3 – For Curr | The payer's highest credit amount permitted for open invoices and open orders together in the payer's currency |
| Days Diff – Adj Due Date and Pmt | Number of days between the due date including the defined credit limit 4 of a customer and payment date |
| Days Diff – Adj Follow up and Pmt | Number of days between the follow-up date including the defined credit limit 4 of a customer and payment date |
| Days Diff – Due and Pmt | Number of days between the due date and the payment date |
| Days Diff – Follow up and Pmt | Number of days between the follow-up date and the payment date |
| Days Diff – Invoice and Pmt | Number of days between the invoice date and the payment date |
| DSO Value |
The average time for payment of customer invoices in days of each payer for the period Aggregations: Avg, Max, Min |
| Insurance Limit Amt – For Curr | The amount for which a payer is insured in the payer's currency |
| Invoice Amt | The total invoice amount for the period in the division currency |
| Invoice Amt – For Curr | The total invoice amount for the period in the foreign currency |
| No. of Fully Paid Invoices | Number of invoices that have been paid in full for the period |
| No. of Payments | The number of payments made for the period |
| Open Order Amt | Amount of open orders in the division currency |
| Open Order Amt – For Curr | Amount of open orders in the foreign currency |
| Outstanding Amt | The amount of outstanding invoices in the division currency |
| Outstanding Amt – For Curr | The amount of outstanding invoices in the foreign currency |
| Overdue Amt | Amount of past due invoices in the division currency |
| Overdue Amt – For Curr | Amount of past due invoices in the foreign currency |
| Payment Amt | Payments made for the period in the division currency |
| Payment Amt – For Curr | Payments made for the period in the foreign currency |
| Payment Var 1 | The payment variance in Reference Field Amount 15 for the period in the division currency |
| Payment Var 1 – For Curr | The payment variance in Reference Field Amount 15 for the period in the foreign currency |
| Payment Var 2 | The payment variance in Reference Field Amount 16 for the period in the division currency |
| Payment Var 2 – For Curr | The payment variance in Reference Field Amount 16 for the period in the foreign currency |
| Payment Var 3 | The payment variance in Reference Field Amount 18 for the period in the division currency |
| Payment Var 3 – For Curr | The payment variance in Reference Field Amount 18 for the period in the foreign currency |
| Payment Var 4 | The payment variance in Reference Field Amount 19 for the period in the division currency |
| Payment Var 4 – For Curr | The payment variance in Reference Field Amount 19 for the period in the foreign currency |
| Payment Var 5 | The payment variance in Reference Field Amount 20 for the period in the division currency |
| Payment Var 5 – For Curr | The payment variance in Reference Field Amount 20 for the period in the foreign currency |
| Pmts Past Adj Due Date | Number of payments made after the allowed number of days past the due date |
| Pmts Past Adj Follow up Date | Number of payments made after the allowed number of days past the follow-up date |
| Pmts Past Due Date | Number of payments made after the due date |
| Pmts Past Follow up Date | Number of payments made after the follow-up date |
| Sales Amt | The total sales amount for the period in the division currency |
| Sales Amt – For Curr | The total sales amount for the period in the foreign currency |
| Stopped Amt | Total amount stopped for a customer when credit limit is exceeded, recorded in the division currency |
| Stopped Amt – For Curr | Total amount stopped for a customer when credit limit is exceeded in the foreign currency |
| Weighted Pmt |
The weighted payment amount by day divided by the number of days between invoice and payment dates divided by the amount per payment Aggregations: Avg, Max, Min |