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 |