Replenishment Attribute Mapping
The replenishment attribute data is loaded from the PROD_LOC_REPL.csv file or from RMFCS. This data is
not used by any planning solution in the default templates, but it is made available for customer extensions.
| Measure | Target Table | Target Column | Data Source |
|---|---|---|---|
|
Item |
W_PDS_REPL_ATTR_IT_LC_D |
ITEM |
W_PRODUCT_D_RTL_TMP.PROD_IT_NUM |
|
Location |
W_PDS_REPL_ATTR_IT_LC_D |
LOCATION |
W_INT_ORG_D_RTL_TMP.ORG_NUM |
|
Food Stamp Flag |
W_PDS_REPL_ATTR_IT_LC_D |
FOOD_STAMP_IND |
W_INVENTORY_PRODUCT_ATTR_D.INV_ATTR1_NAME |
|
Reward Eligible Flag |
W_PDS_REPL_ATTR_IT_LC_D |
REWARD_ELIGIBLE_IND |
W_INVENTORY_PRODUCT_ATTR_D.INV_ATTR2_NAME |
|
Natl Brand Comp Item |
W_PDS_REPL_ATTR_IT_LC_D |
NATL_BRAND_COMP_ITEM |
W_INVENTORY_PRODUCT_ATTR_D.INV_ATTR3_NAME |
|
Elect Mkt Clubs |
W_PDS_REPL_ATTR_IT_LC_D |
ELECT_MKT_CLUBS |
W_INVENTORY_PRODUCT_ATTR_D.INV_ATTR4_NAME |
|
Store Reorderable Flag |
W_PDS_REPL_ATTR_IT_LC_D |
STORE_REORDERABLE_IND |
W_INVENTORY_PRODUCT_ATTR_D.INV_ATTR5_NAME |
|
Manual Price Entry |
W_PDS_REPL_ATTR_IT_LC_D |
MANUAL_PRICE_ENTRY |
W_INVENTORY_PRODUCT_ATTR_D.INV_ATTR6_NAME |
|
WIC Flag |
W_PDS_REPL_ATTR_IT_LC_D |
WIC_IND |
W_INVENTORY_PRODUCT_ATTR_D.INV_ATTR7_NAME |
|
In Store Market Basket |
W_PDS_REPL_ATTR_IT_LC_D |
IN_STORE_MARKET_BASKET |
W_INVENTORY_PRODUCT_ATTR_D.INV_ATTR8_NAME |
|
Returnable Flag |
W_PDS_REPL_ATTR_IT_LC_D |
RETURNABLE_IND |
W_INVENTORY_PRODUCT_ATTR_D.INV_ATTR9_NAME |
|
Launch Date |
W_PDS_REPL_ATTR_IT_LC_D |
LAUNCH_DATE |
W_INVENTORY_PRODUCT_ATTR_D.INV_ATTR1_DATE |
|
Refundable Flag |
W_PDS_REPL_ATTR_IT_LC_D |
REFUNDABLE_IND |
W_INVENTORY_PRODUCT_ATTR_D.REFUNDABLE_IND |
|
Back Order Flag |
W_PDS_REPL_ATTR_IT_LC_D |
BACK_ORDER_IND |
W_INVENTORY_PRODUCT_ATTR_D.BACK_ORDER_IND |
|
Replenishment Supplier Num |
W_PDS_REPL_ATTR_IT_LC_D |
REPL_SUPPLIER_NUM |
W_INVENTORY_PRODUCT_ATTR_D.REPL_SUPPLIER_NUM |
|
Replenishment Country Code |
W_PDS_REPL_ATTR_IT_LC_D |
REPL_COUNTRY_CODE |
W_INVENTORY_PRODUCT_ATTR_D.REPL_COUNTRY_CODE |
|
Replenishment Review Cycle |
W_PDS_REPL_ATTR_IT_LC_D |
REPL_REVIEW_CYCLE |
W_INVENTORY_PRODUCT_ATTR_D.REPL_REVIEW_CYCLE |
|
Replenishment Stock Cat |
W_PDS_REPL_ATTR_IT_LC_D |
REPL_STOCK_CAT |
W_INVENTORY_PRODUCT_ATTR_D.REPL_STOCK_CAT |
|
Replenishment Source Wh |
W_PDS_REPL_ATTR_IT_LC_D |
REPL_SOURCE_WH |
W_INVENTORY_PRODUCT_ATTR_D.REPL_SOURCE_WH |
|
Replenishment Activate Dt |
W_PDS_REPL_ATTR_IT_LC_D |
REPL_ACTIVATE_DT |
W_INVENTORY_PRODUCT_ATTR_D.REPL_ACTIVATE_DT |
|
Replenishment Deactivate Dt |
W_PDS_REPL_ATTR_IT_LC_D |
REPL_DEACTIVATE_DT |
NVL(W_INVENTORY_PRODUCT_ATTR_D.REPL_DEACTIVATE_DT ,'2100-01-01') |
|
Replenishment Pres Stock |
W_PDS_REPL_ATTR_IT_LC_D |
REPL_PRES_STOCK |
W_INVENTORY_PRODUCT_ATTR_D.REPL_PRES_STOCK |
|
Replenishment Demo Stock |
W_PDS_REPL_ATTR_IT_LC_D |
REPL_DEMO_STOCK |
W_INVENTORY_PRODUCT_ATTR_D.REPL_DEMO_STOCK |
|
Replenishment Min Stock |
W_PDS_REPL_ATTR_IT_LC_D |
REPL_MIN_STOCK |
W_INVENTORY_PRODUCT_ATTR_D.REPL_MIN_STOCK |
|
Replenishment Max Stock |
W_PDS_REPL_ATTR_IT_LC_D |
REPL_MAX_STOCK |
W_INVENTORY_PRODUCT_ATTR_D.REPL_MAX_STOCK |
|
Replenishment Service Level |
W_PDS_REPL_ATTR_IT_LC_D |
REPL_SERVICE_LEVEL |
W_INVENTORY_PRODUCT_ATTR_D.REPL_SERVICE_LEVEL |
|
Replenishment Pickup Leadtime |
W_PDS_REPL_ATTR_IT_LC_D |
REPL_PICKUP_LEADTIME |
W_INVENTORY_PRODUCT_ATTR_D.REPL_PICKUP_LEADTIME |
|
Replenishment Wh Leadtime |
W_PDS_REPL_ATTR_IT_LC_D |
REPL_WH_LEADTIME |
W_INVENTORY_PRODUCT_ATTR_D.REPL_WH_LEADTIME |
|
Replenishment Active Flag |
W_PDS_REPL_ATTR_IT_LC_D |
REPL_ACTIVE_FLAG |
CASE WHEN W_INVENTORY_PRODUCT_ATTR_D.REPL_ACTIVE_FLAG IS NULL THEN CASE WHEN NVL(W_INVENTORY_PRODUCT_ATTR_D.REPL_DEACTIVATE_DT ,'2100-01-01') > current_dt THEN ''Y'' ELSE ''N'' END ELSE W_INVENTORY_PRODUCT_ATTR_D.REPL_ACTIVE_FLAG END |
|
Exit Date |
W_PDS_REPL_ATTR_IT_LC_D |
EXIT_DATE |
W_INVENTORY_PRODUCT_ATTR_D.EXIT_DATE |
|
Promo Exclude Flg |
W_PDS_REPL_ATTR_IT_LC_D |
PROMO_EXCL_FLG |
W_INVENTORY_PRODUCT_ATTR_D.PROMO_EXCL_FLG |
|
Mkdn Exclude Flg |
W_PDS_REPL_ATTR_IT_LC_D |
MKDN_EXCL_FLG |
W_INVENTORY_PRODUCT_ATTR_D.MKDN_EXCL_FLG |
|
Replenishment Order Ctrl |
W_PDS_REPL_ATTR_IT_LC_D |
REPL_ORDER_CTRL |
W_INVENTORY_PRODUCT_ATTR_D.REPL_ORDER_CTRL |
|
Replenishment Method |
W_PDS_REPL_ATTR_IT_LC_D |
REPL_METHOD |
W_INVENTORY_PRODUCT_ATTR_D.REPL_METHOD |
|
Incr Percent |
W_PDS_REPL_ATTR_IT_LC_D |
INCR_PCT |
W_INVENTORY_PRODUCT_ATTR_D.INCR_PCT |
|
Min Supply Days |
W_PDS_REPL_ATTR_IT_LC_D |
MIN_SUPPLY_DAYS |
W_INVENTORY_PRODUCT_ATTR_D.MIN_SUPPLY_DAYS |
|
Max Supply Days |
W_PDS_REPL_ATTR_IT_LC_D |
MAX_SUPPLY_DAYS |
W_INVENTORY_PRODUCT_ATTR_D.MAX_SUPPLY_DAYS |
|
Time Supply Horizon |
W_PDS_REPL_ATTR_IT_LC_D |
TIME_SUPPLY_HORIZON |
W_INVENTORY_PRODUCT_ATTR_D.TIME_SUPPLY_HORIZON |
|
Inv Selling Days |
W_PDS_REPL_ATTR_IT_LC_D |
INV_SELLING_DAYS |
W_INVENTORY_PRODUCT_ATTR_D.INV_SELLING_DAYS |
|
Lost Sales Factor |
W_PDS_REPL_ATTR_IT_LC_D |
LOST_SALES_FACTOR |
W_INVENTORY_PRODUCT_ATTR_D.LOST_SALES_FACTOR |
|
Reject Store Order Flag |
W_PDS_REPL_ATTR_IT_LC_D |
REJECT_STORE_ORD_IND |
W_INVENTORY_PRODUCT_ATTR_D.REJECT_STORE_ORD_IND |
|
Non Scaling Flag |
W_PDS_REPL_ATTR_IT_LC_D |
NON_SCALING_IND |
W_INVENTORY_PRODUCT_ATTR_D.NON_SCALING_IND |
|
Max Scale Value |
W_PDS_REPL_ATTR_IT_LC_D |
MAX_SCALE_VALUE |
W_INVENTORY_PRODUCT_ATTR_D.MAX_SCALE_VALUE |
|
Terminal Stock Qty |
W_PDS_REPL_ATTR_IT_LC_D |
TERMINAL_STOCK_QTY |
W_INVENTORY_PRODUCT_ATTR_D.TERMINAL_STOCK_QTY |
|
Season Id |
W_PDS_REPL_ATTR_IT_LC_D |
SEASON_ID |
W_INVENTORY_PRODUCT_ATTR_D.SEASON_ID |
|
Phase Id |
W_PDS_REPL_ATTR_IT_LC_D |
PHASE_ID |
W_INVENTORY_PRODUCT_ATTR_D.PHASE_ID |
|
Last Review Date |
W_PDS_REPL_ATTR_IT_LC_D |
LAST_REVIEW_DATE |
W_INVENTORY_PRODUCT_ATTR_D.LAST_REVIEW_DATE |
|
Next Review Date |
W_PDS_REPL_ATTR_IT_LC_D |
NEXT_REVIEW_DATE |
W_INVENTORY_PRODUCT_ATTR_D.NEXT_REVIEW_DATE |
|
Unit Tolerance |
W_PDS_REPL_ATTR_IT_LC_D |
UNIT_TOLERANCE |
W_INVENTORY_PRODUCT_ATTR_D.UNIT_TOLERANCE |
|
Percent Tolerance |
W_PDS_REPL_ATTR_IT_LC_D |
PCT_TOLERANCE |
W_INVENTORY_PRODUCT_ATTR_D.PCT_TOLERANCE |
|
Use Tolerance Flag |
W_PDS_REPL_ATTR_IT_LC_D |
USE_TOLERANCE_IND |
W_INVENTORY_PRODUCT_ATTR_D.USE_TOLERANCE_IND |
|
Last Delivery Date |
W_PDS_REPL_ATTR_IT_LC_D |
LAST_DELIVERY_DATE |
W_INVENTORY_PRODUCT_ATTR_D.LAST_DELIVERY_DATE |
|
Next Delivery Date |
W_PDS_REPL_ATTR_IT_LC_D |
NEXT_DELIVERY_DATE |
W_INVENTORY_PRODUCT_ATTR_D.NEXT_DELIVERY_DATE |
|
MBR Order Qty |
W_PDS_REPL_ATTR_IT_LC_D |
MBR_ORDER_QTY |
W_INVENTORY_PRODUCT_ATTR_D.MBR_ORDER_QTY |
|
Adj Pickup Lead Time |
W_PDS_REPL_ATTR_IT_LC_D |
ADJ_PICKUP_LEAD_TIME |
W_INVENTORY_PRODUCT_ATTR_D.ADJ_PICKUP_LEAD_TIME |
|
Adj Supp Lead Time |
W_PDS_REPL_ATTR_IT_LC_D |
ADJ_SUPP_LEAD_TIME |
W_INVENTORY_PRODUCT_ATTR_D.ADJ_SUPP_LEAD_TIME |
|
Tsf Po Link No |
W_PDS_REPL_ATTR_IT_LC_D |
TSF_PO_LINK_NO |
W_INVENTORY_PRODUCT_ATTR_D.TSF_PO_LINK_NO |
|
Last ROQ |
W_PDS_REPL_ATTR_IT_LC_D |
LAST_ROQ |
W_INVENTORY_PRODUCT_ATTR_D.LAST_ROQ |
|
Store Ord Multiple |
W_PDS_REPL_ATTR_IT_LC_D |
STORE_ORD_MULT |
W_INVENTORY_PRODUCT_ATTR_D.STORE_ORD_MULT |
|
Unit Cost |
W_PDS_REPL_ATTR_IT_LC_D |
UNIT_COST |
W_INVENTORY_PRODUCT_ATTR_D.UNIT_COST |
|
Supplier Lead Time |
W_PDS_REPL_ATTR_IT_LC_D |
SUPP_LEAD_TIME |
W_INVENTORY_PRODUCT_ATTR_D.SUPP_LEAD_TIME |
|
Inner Pack Size |
W_PDS_REPL_ATTR_IT_LC_D |
INNER_PACK_SIZE |
W_INVENTORY_PRODUCT_ATTR_D.INNER_PACK_SIZE |
|
Supplier Pack Size |
W_PDS_REPL_ATTR_IT_LC_D |
SUPP_PACK_SIZE |
W_INVENTORY_PRODUCT_ATTR_D.SUPP_PACK_SIZE |
|
Tier |
W_PDS_REPL_ATTR_IT_LC_D |
TIER |
W_INVENTORY_PRODUCT_ATTR_D.TIER |
|
Height |
W_PDS_REPL_ATTR_IT_LC_D |
HEIGHT |
W_INVENTORY_PRODUCT_ATTR_D.HEIGHT |
|
Round Lvl |
W_PDS_REPL_ATTR_IT_LC_D |
ROUND_LVL |
W_INVENTORY_PRODUCT_ATTR_D.ROUND_LVL |
|
Round To Inner Percent |
W_PDS_REPL_ATTR_IT_LC_D |
ROUND_TO_INNER_PCT |
W_INVENTORY_PRODUCT_ATTR_D.ROUND_TO_INNER_PCT |
|
Round To Case Percent |
W_PDS_REPL_ATTR_IT_LC_D |
ROUND_TO_CASE_PCT |
W_INVENTORY_PRODUCT_ATTR_D.ROUND_TO_CASE_PCT |
|
Round To Layer Percent |
W_PDS_REPL_ATTR_IT_LC_D |
ROUND_TO_LAYER_PCT |
W_INVENTORY_PRODUCT_ATTR_D.ROUND_TO_LAYER_PCT |
|
Round To Pallet Percent |
W_PDS_REPL_ATTR_IT_LC_D |
ROUND_TO_PALLET_PCT |
W_INVENTORY_PRODUCT_ATTR_D.ROUND_TO_PALLET_PCT |
|
Service Level Type |
W_PDS_REPL_ATTR_IT_LC_D |
SERVICE_LEVEL_TYPE |
W_INVENTORY_PRODUCT_ATTR_D.SERVICE_LEVEL_TYPE |
|
Tsf Zero SOH Flag |
W_PDS_REPL_ATTR_IT_LC_D |
TSF_ZERO_SOH_IND |
W_INVENTORY_PRODUCT_ATTR_D.TSF_ZERO_SOH_IND |
|
Multiple Runs Per Day Flag |
W_PDS_REPL_ATTR_IT_LC_D |
MULT_RUNS_PER_DAY_IND |
W_INVENTORY_PRODUCT_ATTR_D.MULT_RUNS_PER_DAY_IND |
|
Add Lead Time Flag |
W_PDS_REPL_ATTR_IT_LC_D |
ADD_LEAD_TIME_IND |
W_INVENTORY_PRODUCT_ATTR_D.ADD_LEAD_TIME_IND |
|
Deposit Code |
W_PDS_REPL_ATTR_IT_LC_D |
DEPOSIT_CODE |
W_INVENTORY_PRODUCT_ATTR_D.DEPOSIT_CODE |
|
Proportional Tare Percent |
W_PDS_REPL_ATTR_IT_LC_D |
PROPORTIONAL_TARE_PCT |
W_INVENTORY_PRODUCT_ATTR_D.PROPORTIONAL_TARE_PCT |
|
Fixed Tare Value |
W_PDS_REPL_ATTR_IT_LC_D |
FIXED_TARE_VALUE |
W_INVENTORY_PRODUCT_ATTR_D.FIXED_TARE_VALUE |
|
Fixed Tare UOM |
W_PDS_REPL_ATTR_IT_LC_D |
FIXED_TARE_UOM |
W_INVENTORY_PRODUCT_ATTR_D.FIXED_TARE_UOM |
|
Return Policy |
W_PDS_REPL_ATTR_IT_LC_D |
RETURN_POLICY |
W_INVENTORY_PRODUCT_ATTR_D.RETURN_POLICY |
|
Stop Sale Flag |
W_PDS_REPL_ATTR_IT_LC_D |
STOP_SALE_IND |
W_INVENTORY_PRODUCT_ATTR_D.STOP_SALE_IND |
|
Report Code |
W_PDS_REPL_ATTR_IT_LC_D |
REPORT_CODE |
W_INVENTORY_PRODUCT_ATTR_D.REPORT_CODE |
|
Reference Date Type For Exit |
W_PDS_REPL_ATTR_IT_LC_D |
REFERENCE_DATE_TYPE_FOR_EXIT |
W_INVENTORY_PRODUCT_ATTR_D.REFERENCE_DATE_TYPE_FOR_EXIT |
|
Weeks To Exit |
W_PDS_REPL_ATTR_IT_LC_D |
WEEKS_TO_EXIT |
W_INVENTORY_PRODUCT_ATTR_D.WEEKS_TO_EXIT |
|
Optimize Flag |
W_PDS_REPL_ATTR_IT_LC_D |
OPTIMIZE_IND |
W_INVENTORY_PRODUCT_ATTR_D.OPTIMIZE_IND |