Inventory Reclass Mapping

Data is loaded from the INV_RECLASS.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
Reclass In Units	W_PDS_INVRECLASS_IT_LC_WK_A	RECLASS_IN_UNITS	W_RTL_INVRCL_IT_LC_WK_A.RCL_TO_LOC_QTY
Reclass In Cost	W_PDS_INVRECLASS_IT_LC_WK_A	RECLASS_IN_COST	W_RTL_INVRCL_IT_LC_WK_A.RCL_TO_LOC_COST_AMT
Reclass In Retail	W_PDS_INVRECLASS_IT_LC_WK_A	RECLASS_IN_RETAIL	W_RTL_INVRCL_IT_LC_WK_A.RCL_TO_LOC_RTL_AMT
Reclass Out Units	W_PDS_INVRECLASS_IT_LC_WK_A	RECLASS_OUT_UNITS	W_RTL_INVRCL_IT_LC_WK_A.RCL_FROM_LOC_QTY
Reclass Out Cost	W_PDS_INVRECLASS_IT_LC_WK_A	RECLASS_OUT_COST	W_RTL_INVRCL_IT_LC_WK_A.RCL_FROM_LOC_COST_AMT
Reclass Out Retail	W_PDS_INVRECLASS_IT_LC_WK_A	RECLASS_OUT_RETAIL	W_RTL_INVRCL_IT_LC_WK_A.RCL_FROM_LOC_RTL_AMT