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 |