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 |