On Order Mapping

Data is loaded from the ORDER_HEAD.csv and ORDER_DETAIL.csv files or from RMFCS. Purchase order data is transformed from the raw order line details into a forward-looking total on-order amount based on the OTB end-of-week date on the order. The calendar date on the export is further altered based on the parameter PDS_EXPORT_DAILY_ONORD in C_ODI_PARAM_VW to either allow or prevent non-week-ending dates. Data is also filtered to remove orders not flagged as Include On Order.

Measure	Target Table	Target Column	Data Source
On Order Units	W_PDS_PO_ONORD_IT_LC_WK_A	ON_ORDER_UNITS	W_RTL_PO_ONORD_IT_LC_DY_F.PO_ONORD_QTY
On Order Cost	W_PDS_PO_ONORD_IT_LC_WK_A	ON_ORDER_COST	W_RTL_PO_ONORD_IT_LC_DY_F.PO_ONORD_COST_AMT_LCL
On Order Retail	W_PDS_PO_ONORD_IT_LC_WK_A	ON_ORDER_RETAIL	W_RTL_PO_ONORD_IT_LC_DY_F.PO_ONORD_RTL_AMT_LCL
Custom Measures 1 - 20	W_PDS_PO_ONORD_IT_LC_WK_A	FLEX1_NUM_VALUE through FLEX20_NUM_VALUE	W_RTL_PO_ONORD_IT_LC_WK_A.FLEX1_NUM_VALUE through W_RTL_PO_ONORD_IT_LC_WK_A.FLEX20_NUM_VALUE