Inventory Position Mapping
Data is loaded from the INVENTORY.csv file or from RMFCS. The primary data warehouse table is the week-level
aggregate generated by the historical load process. Only data for stockholding locations (STOCKHOLDING_FLG=Y) is exported to PDS.
| Measure | Target Table | Target Column | Data Source |
|---|---|---|---|
|
Inventory Units |
W_PDS_INV_IT_LC_WK_A |
REGULAR_INVENTORY_UNITS |
W_RTL_INV_IT_LC_WK_A.INV_SOH_QTY + INV_IN_TRAN_QTY |
|
Inventory Cost |
W_PDS_INV_IT_LC_WK_A |
REGULAR_INVENTORY_COST |
W_RTL_INV_IT_LC_WK_A.INV_SOH_COST_AMT + INV_IN_TRAN_COST_AMT |
|
Inventory Retail |
W_PDS_INV_IT_LC_WK_A |
REGULAR_INVENTORY_RETAIL |
W_RTL_INV_IT_LC_WK_A.INV_SOH_RTL_AMT + INV_IN_TRAN_RTL_AMT |
|
Unit Cost |
W_PDS_INV_IT_LC_WK_A |
UNIT_COST |
W_RTL_INV_IT_LC_WK_A.INV_UNIT_COST_AMT |
|
Average Cost |
W_PDS_INV_IT_LC_WK_A |
AV_COST |
W_RTL_INV_IT_LC_WK_A.INV_AVG_COST_AMT |
|
Unit Retail |
W_PDS_INV_IT_LC_WK_A |
UNIT_RETAIL |
W_RTL_INV_IT_LC_WK_A.INV_UNIT_RTL_AMT |
|
Custom Measures 1 - 20 |
W_PDS_INV_IT_LC_WK_A |
FLEX1_NUM_VALUE through FLEX20_NUM_VALUE |
W_RTL_INV_IT_LC_WK_A.FLEX1_NUM_VALUE through W_RTL_INV_IT_LC_WK_A.FLEX20_NUM_VALUE |