Transfer Detail Mapping

Data is loaded from the W_RTL_TSF_DETAILS_DS.dat and W_RTL_TSF_IT_LC_DY_FS.dat files or from RMFCS. This data is low-level daily transfer details specifically for IPO usage.

Measure	Target Table	Target Column	Data Source
Transfer Number	W_PDS_TSF_IT_LC_DY_F	TSO_NO	W_RTL_TSF_DETAILS_D.TSF_NO
Item	W_PDS_TSF_IT_LC_DY_F	ITEM	W_PDS_PRODUCT_D.ITEM
To Location	W_PDS_TSF_IT_LC_DY_F	TO_LOC	W_PDS_ORGANIZATION_D.LOCATION
To Location Type	W_PDS_TSF_IT_LC_DY_F	TO_LOC_TYPE	W_PDS_ORGANIZATION_D.LOC_TYPE
From Location	W_PDS_TSF_IT_LC_DY_F	FROM_LOC	W_RTL_TSF_DETAILS_D.FROM_LOC
From Location Type	W_PDS_TSF_IT_LC_DY_F	FROM_LOC_TYPE	W_RTL_TSF_DETAILS_D.FROM_LOC_TYPE
Expected DC Date	W_PDS_TSF_IT_LC_DY_F	EXP_DC_DATE	W_RTL_TSF_DETAILS_D.EXP_DC_DATE
Delivery Date	W_PDS_TSF_IT_LC_DY_F	DELIVERY_DATE	W_RTL_TSF_DETAILS_D.DELIVERY_DATE
Not After Date	W_PDS_TSF_IT_LC_DY_F	NOT_AFTER_DATE	W_RTL_TSF_DETAILS_D.NOT_AFTER_DATE
Transfer Qty	W_PDS_TSF_IT_LC_DY_F	TSF_QTY	W_RTL_TSF_IT_LC_DY_F.TSF_QTY
Fill Qty	W_PDS_TSF_IT_LC_DY_F	FILL_QTY	W_RTL_TSF_IT_LC_DY_F.FILL_QTY
Shipped Qty	W_PDS_TSF_IT_LC_DY_F	SHIP_QTY	W_RTL_TSF_IT_LC_DY_F.SHIP_QTY
Received Qty	W_PDS_TSF_IT_LC_DY_F	RECEIVED_QTY	W_RTL_TSF_IT_LC_DY_F.RECEIVED_QTY
Reconciled Qty	W_PDS_TSF_IT_LC_DY_F	RECONCILED_QTY	W_RTL_TSF_IT_LC_DY_F.RECONCILED_QTY
Distro Qty	W_PDS_TSF_IT_LC_DY_F	DISTRO_QTY	W_RTL_TSF_IT_LC_DY_F.DISTRO_QTY
Selected Qty	W_PDS_TSF_IT_LC_DY_F	SELECTED_QTY	W_RTL_TSF_IT_LC_DY_F.SELECTED_QTY
Cancelled Qty	W_PDS_TSF_IT_LC_DY_F	CANCELLED_QTY	W_RTL_TSF_IT_LC_DY_F.CANCELLED_QTY
Item Avg Cost	W_PDS_TSF_IT_LC_DY_F	TSF_AVG_COST_AMT_LCL	W_RTL_TSF_IT_LC_DY_F.TSF_AVG_COST_AMT_LCL
Item Unit Cost	W_PDS_TSF_IT_LC_DY_F	UNIT_COST_AMT_LCL	W_RTL_TSF_IT_LC_DY_F.UNIT_COST_AMT_LCL