Sourced measures and KPIs
This table shows the measures that are sourced directly in Data Warehouse:
| Measure | Description |
|---|---|
| Adjustment Amt | The amount of invoices from adjustment customer orders in the division currency |
| Adjustment Amt – For Curr | The amount of invoices from adjustment customer orders in the foreign currency |
| ARC Amt | The sum of adjustment, return, and corrective invoice amounts in the division currency |
| ARC Amt – For Curr | The sum of adjustment, return, and corrective invoice amounts in the foreign currency |
| Billback Amt | The amount of invoices with an accounting option equal to 15 in the division currency |
| Billback Amt – For Curr | The amount of invoices with an accounting option equal to 15 in the foreign currency |
| Bonus & Comm Amt | The amount of invoices from bonus and commission customer orders in the division currency |
| Bonus & Comm Amt – For Curr | The amount of invoices from bonus and commission customer orders in the foreign currency |
| Cash Disc Amt | The amount of invoices with an accounting option equal to 18 in the division currency |
| Cash Disc Amt – For Curr | The amount of invoices with an accounting option equal to 18 in the foreign currency |
| Corrected Invc Amt | The amount of invoices with an AR additional information number equal to 236 or 256 in the division currency |
| Corrected Invc Amt – For Curr | The amount of invoices with an AR additional information number equal to 236 or 256 in the foreign currency |
| Corrective Invc Amt | The amount of invoices with an AR additional information number equal to 235 or 255 in the division currency |
| Corrective Invc Amt – For Curr | The amount of invoices with an AR additional information number equal to 235 or 255 in the foreign currency |
| Cumulative Interest Amt | The cumulative interest amount in the division currency |
| Debit Note Amt | The amount of invoices with an accounting option equal to 16 in the division currency |
| Debit Note Amt – For Curr | The amount of invoices with an accounting option equal to 16 in the foreign currency |
| Invoice Amt | The invoice amount in the division currency |
| Invoice Amt – For Curr | The invoice amount in the foreign currency |
| Manual Amt | The amount of non-order invoices with an accounting option equal to 0 in the division currency |
| Manual Amt – For Curr | The amount of non-order invoices with an accounting option equal to 0 in the foreign currency |
| No. of Adj Invc | The number of invoices from adjustment customer orders |
| No. of ARC Invc | The total number of adjustment, return, and corrective invoices |
| No. of Billback Invc | The number of invoices with an accounting option equal to 15 |
| No. of Bonus & Comm Invc | The number of invoices from bonus and commission customer orders |
| No. of Corrected Invc | The number of invoices with an AR additional information number equal to 236 or 256 |
| No. of Corrective Invc | The number of invoices with an AR additional information number equal to 235 or 255 |
| No. of Debit Note Invc | The number of invoices with an accounting option equal to 16 |
| No. of Invc w/ Cash Disc | The number of invoices with an accounting option equal to 18 |
| No. of Invc w/ Ded | The number of invoices that have payments with deductions |
| No. of Invc w/ Var | The number of invoices that have payments with an accounting option not equal to 0 or 18 |
| No. of Invc w/o Ded | The number of invoices that have payments without deductions |
| No. of Invc w/o Var | The number of invoices that have payments with an accounting option equal to 0 or 18 only |
| No. of Invoices | The number of invoices |
| No. of Manual Invc | The amount of non-order invoices with an accounting option equal to 0 |
| No. of Normal Order Invc | The number of invoices from normal customer orders |
| No. of Payments | The number of payments made on an invoice |
| No. of Pmt Reminders | The number of payment reminders of an invoice |
| No. of Pmt w/ Ded | The number of payments to invoices with deductions specified by an accounting option greater than 0 |
| No. of Pmt w/o Ded | The number of payments to invoices with deductions specified by an accounting option equal to 0 |
| No. of Return Invc | The number of invoices from return customer orders |
| No. of Total Order Invc | The number of invoices that are coming from sales orders |
| No. of Write-Off Invc | The number of invoices with an accounting option greater than 19 |
| Normal Order Amt | The amount of invoices from normal customer orders in the division currency |
| Normal Order Amt – For Curr | The amount of invoices from normal customer orders in the foreign currency |
| Pmt Tolerance Amt | The amount of invoices with an accounting option equal to 19 in the division currency |
| Pmt Tolerance Amt – For Curr | The amount of invoices with an accounting option equal to 19 in the foreign currency |
| Return Amt | The amount of invoices from return customer orders in the division currency |
| Return Amt – For Curr | The amount of invoices from return customer orders in the foreign currency |
| Total Order Amt | The total amount of invoices that are coming from customer orders and variances in the division currency |
| Total Order Amt – For Curr | The total amount of invoices that are coming from customer orders and variances in the foreign currency |
| Total Var Amt | The sum of debit note, billback, and write-off invoice amounts in the division currency |
| Total Var Amt – For Curr | The sum of debit note, billback, and write-off invoice amounts in the foreign currency |
| Write-Off Amt | The amount of invoices with an accounting option greater than 19 in the division currency |
| Write-Off Amt – For Curr | The amount of invoices with an accounting option greater than 19 in the foreign currency |