Material PIV Data Measures

The following table lists details about each data measure shown in the Data Measure column on the Material Projected Inventory View (PIV). Each line provides the name of the data measure, the states of the orders or shipments included in the measure, the resulting destination after clicking the measure's link in a date column (if available for that measure), and any further information about the data measure.

Data Measure	States/Content	Links To	More Information
Inbound Bucketized Order Forecast	Open, Vendor Confirmed With Changes, Buyer Confirmed With Changes, Awaiting Approval, New, Buyer Change Requested, Vendor Change Requested, Soft Promised		Based on the forecast date
Order Forecasts			Approved order forecasts generated by replenishment engine Filter by site or location using the PIV filter
Awaiting Approval Purchase Orders	Awaiting Approval	Search Purchase Orders report	Filter by site or location using the PIV filter Available for Buyer roles and Orchestrators acting on behalf of Buyer (Customer). For vendor roles where My Organization in (Selling Org, Ship from Org) and shipment with status «Pre-ASN» in the Awaiting state should be exist
Confirmed Purchase Orders	New, Buyer Confirmed With Changes, Vendor Confirmed With Changes, Buyer Change Requested, Vendor Change Requested, Open, In Promising In Fulfillment, Partially Shipped, Partially Received: Only for Partially Fulfilled, Shipped, and Received orders that have an ordered quantity not fully covered by the shipment quantity	Search Purchase Orders report	Filter by site or location using the PIV filter
Confirmed Purchase Orders In The Past	New, Buyer Confirmed With Changes, Vendor Confirmed With Changes, Buyer Change Requested, Vendor Change Requested, Open, In Promising In Fulfillment, Partially Shipped, Partially Received: Only for Partially Fulfilled, Shipped, and Received orders that have an ordered quantity not fully covered by the shipment quantity	Search Purchase Orders report based on the “OlderOrderAdjustmentDays” RPL engine configuration, defaults to 10 days	Filter by site or location using the PIV filter
Planned Shipments	Awaiting, Confirmed, Tendered, Pick Ready	Search Shipments report The Search Shipments report is order type agnostic. If shipments exist for different order types (such as deployment and purchase orders), they won’t be reflected in a drill-down report.	Shipment.shipped qty Based on NVL (Delivery Appt, Delivery) Date Range Start
Planned Shipments In The Past	Awaiting, Confirmed, Tendered, Pick Ready, Intransit, Delivery Ready, Delivered	Search Shipments report based on “OlderOrderAdjustmentDays” RPL engine configuration, defaults to 10 days	Based on NVL (Delivery Appt, Delivery) Date Range Start Quantity from the data measure on the PIV and the quantity in the Search Shipments report may be different due to a date range difference
Intransit Shipments	Intransit, Delivery Ready, Delivered	Search Shipments report The Search Shipments report is order type agnostic. If shipments exist for different order types (such as deployment and purchase orders), they won’t be reflected in a drill-down report.	Shipment.shipped qty Based on NVL (Delivery Appt, Delivery) Date Range Start
Awaiting Approval Deployment Orders	Awaiting Approval	Search Enhanced Order report for the Buyer role or Orchestrator role that executes on behalf of the Buyer (Customer)	Filter by site or location using the PIV filter
On Hold Deployment Orders	Awaiting Approval, New	Search Enhanced Orders report	Filter by site or location using the PIV filter Linked to blocking holds in an Open state
Approved Deployment Orders	New, Buyer Confirmed With Changes, Vendor Confirmed With Changes, Buyer Change Requested, Vendor Change Requested, Open, In Promising, In Fulfillment (only for partially fulfilled orders)	Search Enhanced Orders report	Filter by site or location using the PIV filter
Approved Deployment Orders In the Past	New, Buyer Confirmed With Changes, Vendor Confirmed With Changes, Buyer Change Requested, Vendor Change Requested, Open, In Promising, In Fulfillment (only for Partially Fulfilled orders)	Search Deployment Orders report based on the “OlderOrderAdjustmentDays” RPL engine configuration, defaults to 10 days	Quantity from the data measure on the PIV and the quantity in the Search Deployment Orders report may be different
Planned Shipments For Deployment Orders	Awaiting, Confirmed, Tendered, Pick Ready	Search Shipments report The Search Shipments report is order type agnostic. If shipments exist for different order types (such as deployment and purchase orders), they won’t be reflected in a drill-down report.	Based on order type Shipment.shipped qty Based on NVL (Delivery Appt, Delivery) Date Range Start
Planned Shipments For Deployment Orders In The Past	Awaiting, Confirmed, Tendered, Pick Ready, Intransit, Delivery Ready, Delivered	Search Shipments report based on the “OlderOrderAdjustmentDays” RPL engine configuration, defaults to 10 days. The Search Shipments report is order type agnostic. If shipments exist for different order types (such as deployment and purchase orders), they won’t be reflected in a drill-down report.	Based on order type Based on NVL (Delivery Appt, Delivery) Date Range Start Quantity from the data measure on the PIV and the quantity in the Search Shipments report may be different due to a date range difference
Intransit Shipments For Deployment Orders	Intransit, Delivery Ready, Delivered	Search Shipments report The Search Shipments report is order type agnostic. If shipments exist for different order types (such as deployment and purchase orders), they won’t be reflected in a drill-down report.	Based on order type Based on NVL (Delivery Appt, Delivery) Date Range Start Quantity from the data measure on the PIV and the quantity in the Search Shipments report may be different due to a date range difference
Deployment Orders	Awaiting Approval Deployment Orders On Hold Deployment Orders Approved Deployment Orders Approved Deployment Orders In The Past Planned Shipments for Deployment Orders Planned Shipments for Deployment Orders In The Past Intransit Shipments for Deployment Orders
Shipment vs Order	Received vs Ordered Qty States: Received, Closed Formula = received qty - shipped qty Traffic light rule is applied Ordered Quantity (order.agreed qty) States: Open, In Fullfilment, In Transit, Partially Shipped, Partially Received, Received, Closed Shipped Quantity States: Intransit Received Quantity States: Received, Closed Ordered - Shipped Mismatch shipped qty – order.agreed qty Shipped - Received Mismatch received qty – shipment.shipped qty		Comparison is made only for purchase orders and their corresponding shipments.
Demand Forecast	Open	Drill down to the Search Demand Forecast report	Demand Forecast.Forecast Quantity S1 Computed by RPL API
Outbound Bucketized Order Forecast	Open, Vendor Confirmed With Changes, Buyer Confirmed With Changes, Awaiting Approval, New, Buyer Change Requested, Vendor Change Requested, Soft Promised		Based on the forecast date
Projected Inventory – Projected inventory is computed by RPL API.	Supply: Approved OFs, Awaiting Approval, On Hold, Confirmed POs, Planned and Intransit Shipments, Inbound Bucketized Order Forecast Demand: Demand Forecast, Outbound Bucketized Order Forecast		Static Order Policy –ve value is highlighted in red +ve value but less than min quantity is highlighted in yellow +ve value but more than max quantity is highlighted in orange Dynamic Order Policy –ve value is highlighted in red +ve value but less than POH less SS DM value for current bucket date is highlighted in yellow
Projected Inventory w/o Awaiting Approval	Same as Projected Inventory data measure without Awaiting Approval orders
Projected Inventory For Request Qty Only			Replenishment analysis data measure Coloring is the same as on Projected Inventory data measure Available only if the SCPT.ShowReplenishmentAnalysisDataMeasuresOnPIV policy is enabled
Lost Sales			Replenishment analysis data measure Available only if the SCPT.ShowReplenishmentAnalysisDataMeasuresOnPIV policy is enabled
Lost Sales Adjustment			Replenishment analysis data measure Available only if the SCPT.ShowReplenishmentAnalysisDataMeasuresOnPIV policy is enabled
Deferred Lost Sales			Replenishment analysis data measure Available only if the SCPT.ShowReplenishmentAnalysisDataMeasuresOnPIV policy is enabled
Expired On Hand			Replenishment analysis data measure Available only if the SCPT.ShowReplenishmentAnalysisDataMeasuresOnPIV policy is enabled
Late Supply Order			Replenishment analysis data measure Available only if the SCPT.ShowReplenishmentAnalysisDataMeasuresOnPIV policy is enabled
DOS (Days of Supply)			Replenishment analysis data measure Available if the SCPT.Advanced Data Measure policy has this data measure as the value

The following traffic light rules are applied to mismatched data measures:

Red if the –ve and absolute difference are greater than the tolerance percentage
Yellow if the –ve and absolute difference are within the tolerance percentage limit
Green if +ve and the absolute difference are within tolerance percentage limit
Otherwise, no coloring