Sourced measures and KPIs

Measure	Description
Amt by Day – Adj Due & 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 & 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 & 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 & 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 & 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 & 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 & 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 & 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 & 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 & 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 & 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 & Pmt	Number of days between the follow-up date including the defined credit limit 4 of a customer and payment date
Days Diff – Due & Pmt	Number of days between the due date and the payment date
Days Diff – Follow-up & Pmt	Number of days between the follow-up date and the payment date
Days Diff – Invoice & 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
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

Amt by Day – Adj Due & 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 & 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 & 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 & 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 & 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 & 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 & 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 & 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 & 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 & 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 & 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 & Pmt

Number of days between the follow-up date including the defined credit limit 4 of a customer and payment date

Days Diff – Due & Pmt

Number of days between the due date and the payment date

Days Diff – Follow-up & Pmt

Number of days between the follow-up date and the payment date

Days Diff – Invoice & 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

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