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. 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 |
|---|---|
| Ordered Value – Transaction | Value of the ordered quantity based on invoiced price in the order currency |
| Ordered Value – Division | Value of the ordered quantity based on invoiced price in the division currency |
| Ordered Value – Company | Value of the ordered quantity based on invoiced price in the company currency |
| Confirmed Value – Transaction | Value of the confirmed quantity based on invoiced price in the order currency |
| Confirmed Value – Division | Value of the confirmed quantity based on invoiced price in the division currency |
| Confirmed Value – Company | Value of the confirmed quantity based on invoiced price in the company currency |
| Received Value – Transaction | Value of the received quantity based on invoiced price in the order currency |
| Received Value – Division | Value of the received quantity based on invoiced price in the division currency |
| Received Value – Company | Value of the received quantity based on invoiced price in the company currency |
| Approved Value – Transaction | Value of the approved quantity based on invoiced price in the order currency |
| Approved Value – Division | Value of the approved quantity based on invoiced price in the division currency |
| Approved Value – Company | Value of the approved quantity based on invoiced price in the company currency |
| Rejected Value – Transaction | Value of the rejected quantity based on invoiced price in the order currency |
| Rejected Value – Division | Value of the rejected quantity based on invoiced price in the division currency |
| Rejected Value – Company | Value of the rejected quantity based on invoiced price in the company currency |
| Invoiced Value – Transaction | Value of the invoiced quantity based on invoiced price in the order currency |
| Invoiced Value – Division | Value of the invoiced quantity based on invoiced price in the division currency |
| Invoiced Value – Company | Value of the invoiced quantity based on invoiced price in the company currency |
| Net Invoiced Value – Transaction | Invoiced value minus the discount amount in the order currency |
| Net Invoiced Value – Division | Invoiced value minus the discount amount in the division currency |
| Net Invoiced Value – Company | Invoiced value minus the discount amount in the company currency |
| Ordered Qty | Ordered quantity in basic unit of measure |
| Ordered Qty Alt Unit | Ordered quantity in alternate unit of measure |
| Confirmed Qty | Confirmed quantity in basic unit of measure |
| Confirmed Qty Alt Unit | Confirmed quantity in alternate unit of measure |
| Invcd Received Qty | Received quantity in basic unit of measure as stated in invoice |
| Invcd Received Qty Alt Unit | Received quantity in alternate unit of measure as stated in invoice |
| Invcd Approved Qty | Approved quantity in basic unit of measure as stated in invoice |
| Invcd Approved Qty Alt Unit | Approved quantity in alternate unit of measure as stated in invoice |
| Invcd Rejected Qty | Rejected quantity in basic unit of measure as stated in invoice |
| Invcd Rejected Qty Alt Unit | Rejected quantity in alternate unit of measure as stated in invoice |
| Invcd Inspected Qty | Sum of approved and rejected quantities as stated in invoice |
| Stored Qty | Stored quantity in basic unit of measure |
| Stored Qty Alt Unit | Stored quantity in alternate units of measure |
| Invcd Not Inspected Qty | Stored quantity when there are no approved or rejected quantities |
| Invcd Qty | Invoiced quantity in basic unit of measure |
| Invcd Qty Alt Unit | Invoiced quantity in alternate unit of measure |
| Lines Qty as Req | Number of lines where the received quantity is equal to the
requested quantity Aggregations: Avg, Sum |
| Lines Qty as Conf | Number of lines where the received quantity is equal to the
confirmed quantity Aggregations: Avg, Sum |
| Lines Correct/Overshipped as Req Qty | Number of lines where the received quantity is greater than or
equal to the requested quantity Aggregations: Avg, Sum |
| Lines Correct/Overshipped as Conf Qty | Number of lines where the received quantity is greater than or
equal to 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 Qty Rcvd More than Conf | Number of lines where the received quantity is greater 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 Less than Conf | Number of lines where the received quantity is less than the
confirmed quantity Aggregations: Avg, Sum |
| No. of Lines | Number of invoiced purchase order lines Aggregations: Avg, Sum |
| No. of Returns | Number of returned purchase order lines Aggregations: Avg, Sum |
| No. of Discrepancy Days | Number of days between the received date and the confirmed or requested date |
| Days Diff – Confirmed and Rcvd | Number of goods receiving days between confirmed and received dates |
| Hrs Diff – Confirmed and Rcvd | Number of goods receiving hours between confirmed and received dates |
| Min Diff – Confirmed and Rcvd | Number of goods receiving minutes between confirmed and received dates |
| Days Diff – Confirmed and Requested | Number of goods receiving days between confirmed and requested dates |
| Days Diff – Requested and Rcvd | Number of goods receiving days between requested and received dates |
| Hrs Diff – Requested and Rcvd | Number of goods receiving hours between requested and received dates |
| Min Diff – Requested and Rcvd | Number of goods receiving minutes between requested and received dates |
| Days Diff – Order and Rcvd | Number of goods receiving days between order and received dates |
| Lead Time | Time it takes to acquire an item, from when a demand is initiated until it has been fulfilled |