Inventory Adjustments Mapping
Data is loaded from the ADJUSTMENT.csv
file or from RMFCS. The primary data warehouse table is the week-level
aggregate generated by the historical load process.
Measure | Target Table | Target Column | Data Source |
---|---|---|---|
Shrink Units |
W_PDS_INVADJ_IT_LC_WK_A |
SHRINK_UNITS |
W_RTL_INVADJ_IT_LC_WK_A.INVADJ_QTY where adj type = 22 |
Shrink Cost |
W_PDS_INVADJ_IT_LC_WK_A |
SHRINK_COST |
W_RTL_INVADJ_IT_LC_WK_A.INVADJ_COST_AMT where adj type = 22 |
Shrink Retail |
W_PDS_INVADJ_IT_LC_WK_A |
SHRINK_RETAIL |
W_RTL_INVADJ_IT_LC_WK_A.INVADJ_RTL_AMT where adj type = 22 |
Non-Shrink Adjustments Units |
W_PDS_INVADJ_IT_LC_WK_A |
NON_SHRINK_ADJ_UNITS |
W_RTL_INVADJ_IT_LC_WK_A.INVADJ_QTY where adj type = 23 |
Non-Shrink Adjustments Cost |
W_PDS_INVADJ_IT_LC_WK_A |
NON_SHRINK_ADJ_COST |
W_RTL_INVADJ_IT_LC_WK_A.INVADJ_COST_AMT where adj type = 23 |
Non-Shrink Adjustments Retail |
W_PDS_INVADJ_IT_LC_WK_A |
NON_SHRINK_ADJ_RETAIL |
W_RTL_INVADJ_IT_LC_WK_A.INVADJ_RTL_AMT where adj type = 23 |