Purchase Orders sourced measures and KPIs

This table shows the Purchase Orders measures that are sourced directly in Data Warehouse.

These measures can be analyzed by different time series. These time series are available:

  • Month Ago
  • Quarter Ago
  • Quarter-To-date
  • Trailing 12 Months
  • Trailing 3 Months
  • Year Ago
  • Year-To-date

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
Line Amt Recorded amount in the division currency
Line Amt – Order Currency Recorded amount in the order currency
Lines with Agreement Number of order lines with purchase agreements

Aggregations: Avg, Sum

No. of Lines Number of purchase order lines

Aggregation: Sum

No. of Orders Number of purchase orders

Aggregation: Count Distinct

Order Qty Order quantity in basic unit of measure
Order Qty Alt Unit Order quantity in alternate unit of measure
Purchase Price Price per basic unit of measure in the division currency

Aggregations: Avg, Max, Min

Purchase Price – Order Currency Price per basic unit of measure in the order currency

Aggregations: Avg, Max, Min