Vendor Detail - Technical Specification
The data used to generate this dashboard is based on the following:
Analytical Object | AO_SPM_VendorPerformanceManagement |
Query Object | QO_SPM_VendorPerformanceManagement |
Data Source | PAI Foundation |
Cab File | SPM_PAI_Foundation.cab |
Query Object Primary Table | IPCS_ORDER_PLAN_HISTORY |
Query Object Tables | IPCS_ORDER_PLAN_HISTORY VENDORSLIST IPCS_PART_MASTER IPCS_LOC_MASTER IPCS_VENDOR_LOC IPCS_VENDORS IPCS_STOCK_LEVEL IPCS_FORECASTED_DATA |
Parameters | Name | Description | Default |
|---|
PO_SPM_VendorMinOrders | The minimum number of orders to consider | 10 |
|
Predecessor Jobs | Build the cube after every Order Plan History archival process |
Build Type | The following build types are supported: • Full |
Build Frequency | These build frequencies are supported: • Daily |
| • Location • Part Number • Vendor • Vendor Location • Delivery Status Classification • Delivery by Days |
| Measure | Mathematical Function |
|---|
Actual Lead Time | Average of Procurement Length | SPM Lead Time | Average of SL Procurement Length | Delay | A mathematical calculation that contains Actual Lead Time – SPM Lead Time | Number of Orders | Count of Procurement Length | Delivery Status Classification | Count of Delivery Status | The sort order of Vendors is displayed in descending order, based on the first legend show in the widget. For example, sorted by Early, or Late, or On Time delivery status, whichever is displayed first. |
| Total Spend ($) | Sum of Order Price | One Day Demand Value | Sum of One Day Demand Value | Delay Impact ($) | A mathematical calculation that contains Delay * One Day Demand Value | A value of $0.00 is displayed when either of the following are true: • The Delay is 0 • The forecast data is not available for the SKU |
|
|
