Sales Orders sourced measures and KPIs
This table shows the Sales Orders 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 |
|---|---|
| Line Amt – Transaction | Recorded amount in the order currency |
| Line Amt – Division | Recorded amount in the division currency |
| Line Amt – Company | Recorded amount in the company currency |
| Line Amt 2 – Transaction | Recorded amount in the order currency, defined by line type |
| Line Amt 2 – Division | Recorded amount in the division currency, defined by line type |
| Line Amt 2 – Company | Recorded amount in the company currency, defined by line type |
| Order Value – Transaction | Order quantity in basic unit of measure multiplied by the sales price in the order currency |
| Order Value – Division | Order quantity in basic unit of measure multiplied by the sales price in the division currency |
| Order Value – Company | Order quantity in basic unit of measure multiplied by the sales price in the company currency |
| Standard Cost – Transaction | Order quantity multiplied by the cost price in the order currency per basic unit of measure |
| Standard Cost – Division | Order quantity multiplied by the cost price in the division currency per basic unit of measure |
| Standard Cost – Company | Order quantity multiplied by the cost price in the company currency per basic unit of measure |
| Contribution – Transaction | Order value in order currency minus the standard cost in order currency |
| Contribution – Division | Order value in division currency minus the standard cost in division currency |
| Contribution – Company | Order value in company currency minus the standard cost in company currency |
| Order Qty | Order quantity in basic unit of measure |
| Allocated Qty | Allocated quantity in basic unit of measure |
| Picking List Qty | Quantity in basic unit of measure with picking list printed |
| Delivered Qty | Delivered quantity in basic unit of measure |
| Invoiced Qty | Invoiced quantity in basic unit of measure |
| Remaining Qty | Remaining quantity in basic unit of measure |
| Qty not Delivered | Quantity not yet delivered or invoiced in basic unit of measure |
| Qty not Invoiced | Quantity not yet invoiced in basic unit of measure |
| No. of Lines | Number of order lines Aggregations: Avg, Sum |
| No. of Orders | Number of customer orders Aggregations: Avg, Sum Can be analyzed by: Order Date |
| No. of Stopped Orders | The number of customer orders where
customer order stop is greater than zero Aggregations: Avg, Sum Can be analyzed by: Order Date |
| No. of Stopped Order Lines | The number of order lines where
customer order stop is greater than zero Aggregations: Avg, Sum |
| No. of Overdue Lines | The number of order lines where the
line status is less than 65 and the planning date is less than the ETL
run date Aggregations: Avg, Sum |
| No. of Stocked Lines | The number of order lines where the
line status is not equal to 22 Aggregations: Avg, Sum |