Inventory Transfers Mapping
Data is loaded from the TRANSFER.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 |
---|---|---|---|
Transfer Type |
W_PDS_INVTSF_IT_LC_WK_A |
TSF_TYPE |
W_XACT_TYPE_D.W_XACT_TYPE_CODE in (N,B,I) (for normal/book/intercompany tsfs) |
Transfer Inbound Units |
W_PDS_INVTSF_IT_LC_WK_A |
TSF_IN_UNITS |
W_RTL_INVTSF_IT_LC_WK_A.TSF_TO_LOC_QTY |
Transfer Inbound Cost |
W_PDS_INVTSF_IT_LC_WK_A |
TSF_IN_COST |
W_RTL_INVTSF_IT_LC_WK_A.TSF_TO_LOC_COST_AMT |
Transfer Inbound Retail |
W_PDS_INVTSF_IT_LC_WK_A |
TSF_IN_RETAIL |
W_RTL_INVTSF_IT_LC_WK_A.TSF_TO_LOC_RTL_AMT |
Transfer Outbound Units |
W_PDS_INVTSF_IT_LC_WK_A |
TSF_OUT_UNITS |
W_RTL_INVTSF_IT_LC_WK_A.TSF_FROM_LOC_QTY |
Transfer Outbound Cost |
W_PDS_INVTSF_IT_LC_WK_A |
TSF_OUT_COST |
W_RTL_INVTSF_IT_LC_WK_A.TSF_FROM_LOC_COST_AMT |
Transfer Outbound Retail |
W_PDS_INVTSF_IT_LC_WK_A |
TSF_OUT_RETAIL |
W_RTL_INVTSF_IT_LC_WK_A.TSF_FROM_LOC_RTL_AMT |