AR Balances sourced measures and KPIs
This table shows the AR Balances measures that are sourced directly in Data Warehouse.
These measures can be analyzed by different time series. For the list of available time series measures, see Time.
Aggregations available are Avg, Max, Min, and Sum. For cases where this does not apply, the available aggregations are indicated in this table:
| Measure | Description |
|---|---|
| Invc Amt – Transaction | The total invoice amount for the period in the transaction currency |
| Invc Amt – Division | The total invoice amount for the period in the division currency |
| Pmt Amt – Transaction | The payments made for the period in the transaction currency |
| Pmt Amt – Division | The payments made for the period in the division currency |
| Sales Amt – Transaction | The total sales amount for the period in the transaction currency |
| Sales Amt – Division | The total sales amount for the period in the division currency |
| Outstanding Amt – Transaction | The amount of outstanding invoices in the transaction currency |
| Outstanding Amt – Division | The amount of outstanding invoices in the division currency |
| Overdue Invc Amt – Transaction | The amount of past due invoices in the transaction currency |
| Overdue Invc Amt – Division | The amount of past due invoices in the division currency |
| Stopped Amt – Transaction | Total amount stopped in transaction currency for a customer when credit limit is exceeded |
| Stopped Amt – Division | Total amount stopped in division currency for a customer when credit limit is exceeded |
| Open Order Amt – Transaction | The amount of open orders in the transaction currency |
| Open Order Amt – Division | The amount of open orders in the division currency |
| DSO Value | The average time for payment of customer invoices in days of each payer for the period |
| Pmt Var 1 – Transaction | The payment variance in reference field amount 15 for the period in the transaction currency |
| Pmt Var 1 – Division | The payment variance in reference field amount 15 for the period in the division currency |
| Pmt Var 2 – Transaction | The payment variance in reference field amount 16 for the period in the transaction currency |
| Pmt Var 2 – Division | The payment variance in reference field amount 16 for the period in the division currency |
| Pmt Var 3 – Transaction | The payment variance in reference field amount 18 for the period in the transaction currency |
| Pmt Var 3 – Division | The payment variance in reference field amount 18 for the period in the division currency |
| Pmt Var 4 – Transaction | The payment variance in reference field amount 19 for the period in the transaction currency |
| Pmt Var 4 – Division | The payment variance in reference field amount 19 for the period in the division currency |
| Pmt Var 5 – Transaction | The payment variance in reference field amount 20 for the period in the transaction currency |
| Pmt Var 5 – Division | The payment variance in reference field amount 20 for the period in the division currency |
| No. of AR Balance Records |
The total number of AR balance records Aggregation: Avg, Sum |