Inventory RTVs Mapping
Data is loaded from the RTV.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 |
---|---|---|---|
RTV Units |
W_PDS_INVRTV_IT_LC_WK_A |
RTV_UNITS |
W_RTL_INVRTV_IT_LC_WK_A.RTV_QTY |
RTV Cost |
W_PDS_INVRTV_IT_LC_WK_A |
RTV_COST |
W_RTL_INVRTV_IT_LC_WK_A.RTV_COST_AMT |
RTV Retail |
W_PDS_INVRTV_IT_LC_WK_A |
RTV_RETAIL |
W_RTL_INVRTV_IT_LC_WK_A.RTV_RTL_AMT |
RTV Restocking Fee |
W_PDS_INVRTV_IT_LC_WK_A |
RTV_RESTOCK_FEE |
W_RTL_INVRTV_IT_LC_WK_A.RTV_RSTCK_COST_AMT |