Inventory Receipts Mapping

Data is loaded from the RECEIPT.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
PO Receipt Units	W_PDS_INVRC_IT_LC_WK_A	PO_RECEIPT_UNITS	W_RTL_INVRC_IT_LC_WK_A.INVRC_QTY where rcpt type code = 20
PO Receipt Cost	W_PDS_INVRC_IT_LC_WK_A	PO_RECEIPT_COST	W_RTL_INVRC_IT_LC_WK_A.INVRC_COST_AMT where rcpt type code = 20
PO Receipt Retail	W_PDS_INVRC_IT_LC_WK_A	PO_RECEIPT_RETAIL	W_RTL_INVRC_IT_LC_WK_A.INVRC_RTL_AMT where rcpt type code = 20
Transfer/Allocation Receipt Units	W_PDS_INVRC_IT_LC_WK_A	TSF_RECEIPT_UNITS	W_RTL_INVRC_IT_LC_WK_A.INVRC_QTY where rcpt type code = 44~A or 44~T
Transfer/Allocation Receipt Cost	W_PDS_INVRC_IT_LC_WK_A	TSF_RECEIPT_COST	W_RTL_INVRC_IT_LC_WK_A.INVRC_COST_AMT where rcpt type code = 44~A or 44~T
Transfer/Allocation Receipt Retail	W_PDS_INVRC_IT_LC_WK_A	TSF_RECEIPT_RETAIL	W_RTL_INVRC_IT_LC_WK_A.INVRC_RTL_AMT where rcpt type code = 44~A or 44~T
PO Receipt Custom Measures 1 - 20	W_PDS_INVRC_IT_LC_WK_A	PO_FLEX1_NUM_VALUE through PO_FLEX20_NUM_VALUE	W_RTL_INVRC_IT_LC_WK_A.FLEX1_NUM_VALUE through W_RTL_INVRC_IT_LC_WK_A.FLEX20_NUM_VALUE where rcpt type code = 20
Transfer Receipt Custom Measures 1 - 20	W_PDS_INVRC_IT_LC_WK_A	TSF_FLEX1_NUM_VALUE through TSF_FLEX20_NUM_VALUE	W_RTL_INVRC_IT_LC_WK_A.FLEX1_NUM_VALUE through W_RTL_INVRC_IT_LC_WK_A.FLEX20_NUM_VALUE where rcpt type code = 44~A or 44~T