Procurement Analysis sourced measures and KPIs
This table shows the Procurement Analysis 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 |
|---|---|
| Days Diff – Conf and Rcvd | Number of goods receiving days between confirmed and received dates |
| Days Diff – Order and Rcvd | Number of goods receiving days between order and received dates |
| Days Diff – Req and Rcvd | Number of goods receiving days between requested and received dates |
| Invcd Approved Qty | Approved quantity in basic unit of measure as stated in invoice |
| Invcd Inspected Qty | Sum of approved and rejected quantities as stated in invoice |
| Invcd Qty not Inspected | Stored quantity when there are no approved or rejected quantities |
| Invcd Received Qty | Received quantity in basic unit of measure as stated in invoice |
| Invcd Rejected Qty | Rejected quantity in basic unit of measure as stated in invoice |
| Invoiced Qty | Invoiced quantity in basic unit of measure |
| Invoiced Value | Value of the invoiced quantity based on invoiced price in the division currency |
| Invoiced Value – Order Currency | Value of the invoiced quantity based on invoiced price in the order currency |
| Lines Correct/Overshp as Conf Qty | Number of lines where the received quantity is greater than or equal
to the confirmed quantity Aggregations: Avg, Sum |
| Lines Correct/Overshp as Req Qty | Number of lines where the received quantity is greater than or equal
to the requested quantity Aggregations: Avg, Sum |
| Lines in Time and Qty as Req | Number of lines where the requested quantity is received on or prior
to the requested date Aggregations: Avg, Sum |
| Lines on Time and Qty as Req | Number of lines where the requested quantity is received on the
requested date Aggregations: Avg, Sum |
| Lines Qty as Conf | Number of lines where the received quantity is equal to the confirmed
quantity Aggregations: Avg, Sum |
| Lines Qty as Req | Number of lines where the received quantity is equal to the requested
quantity Aggregations: Avg, Sum |
| Lines Qty Rcvd Less than Conf | Number of lines where the received quantity is less than the confirmed
quantity Aggregations: Avg, Sum |
| Lines Qty Rcvd Less than Req | Number of lines where the received quantity is less than the requested
quantity Aggregations: Avg, Sum |
| Lines Qty Rcvd More than Conf | Number of lines where the received quantity is greater than the
confirmed quantity Aggregations: Avg, Sum |
| Lines Qty Rcvd More than Req | Number of lines where the received quantity is greater than the
requested quantity Aggregations: Avg, Sum |
| Lines with Agreement | Number of lines with purchase agreements Aggregations: Avg, Sum |
| Net Invoiced Value | Invoiced value minus the discount amount in the division currency |
| Net Invoiced Value – Order Currency | Invoiced value minus the discount amount in the order currency |
| No. of Discrepancy Days | Number of days between the received date and the confirmed or requested date |
| No. of Lines | Number of invoiced purchase order lines Aggregations: Avg, Sum |