Allocation Detail Mapping

Data is loaded from the W_RTL_ALC_DETAILS_DS.dat and W_RTL_ALC_IT_LC_DY_FS.dat files or from RMFCS. This data is low-level daily allocation details specifically for IPO usage.

Measure	Target Table	Target Column	Data Source
Allocation Number	W_PDS_ALC_IT_LC_DY_F	ALLOC_NO	W_RTL_ALC_DETAILS_D.ALLOC_NO
Item	W_PDS_ALC_IT_LC_DY_F	ITEM	W_PDS_PRODUCT_D.ITEM
To Location	W_PDS_ALC_IT_LC_DY_F	TO_LOC	W_PDS_ORGANIZATION_D.LOCATION
To Location Type	W_PDS_ALC_IT_LC_DY_F	TO_LOC_TYPE	W_PDS_ORGANIZATION_D.LOC_TYPE
From Location	W_PDS_ALC_IT_LC_DY_F	FROM_LOC	W_RTL_ALC_DETAILS_D.SOURCE_WH
From Location Type	W_PDS_ALC_IT_LC_DY_F	FROM_LOC_TYPE	'W'
In Store Date	W_PDS_ALC_IT_LC_DY_F	IN_STORE_DATE	W_RTL_ALC_IT_LC_DY_F.IN_STORE_DATE
Transferred Qty	W_PDS_ALC_IT_LC_DY_F	TRANSFERRED_QTY	W_RTL_ALC_IT_LC_DY_F.TRANSFERRED_QTY
Received Qty	W_PDS_ALC_IT_LC_DY_F	RECEIVED_QTY	W_RTL_ALC_IT_LC_DY_F.RECEIVED_QTY
Allocated Qty	W_PDS_ALC_IT_LC_DY_F	ALLOCATED_QTY	W_RTL_ALC_IT_LC_DY_F.ALLOCATED_QTY
Prescaled Qty	W_PDS_ALC_IT_LC_DY_F	PRESCALED_QTY	W_RTL_ALC_IT_LC_DY_F.PRESCALED_QTY
Reconciled Qty	W_PDS_ALC_IT_LC_DY_F	RECONCILED_QTY	W_RTL_ALC_IT_LC_DY_F.RECONCILED_QTY
Distro Qty	W_PDS_ALC_IT_LC_DY_F	DISTRO_QTY	W_RTL_ALC_IT_LC_DY_F.DISTRO_QTY
Selected Qty	W_PDS_ALC_IT_LC_DY_F	SELECTED_QTY	W_RTL_ALC_IT_LC_DY_F.SELECTED_QTY
Cancelled Qty	W_PDS_ALC_IT_LC_DY_F	CANCELLED_QTY	W_RTL_ALC_IT_LC_DY_F.CANCELLED_QTY
Item Avg Cost	W_PDS_ALC_IT_LC_DY_F	ITEM_AVG_COST_AMT_LCL	W_RTL_ALC_IT_LC_DY_F.ITEM_AVG_COST_AMT_LCL