Replenishment Roq (Service Layer)
In ScopeTechnical: SVC_REPL_ROQ | ID: OR-ITM-SVC_REPL_ROQ-REPLENISHMENT_ROQ_SERVICE_LAYER
This is a working table that will serve as temporary placeholder for bulk processing of recommended order quantity for item/loc level.
See how this object fits into Item Management
Review the broader sequencing and dependencies for this domain
Migration Details
- Complexity
- Medium
- Sequencing
- Stage 2
- Typical Sources
- ERPLegacy
Classification
- Object Type
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- SVC_REPL_ROQ
Field Definitions(95)
Rules & Considerations(89)
Sample Load Data(4)
| _scenario | I_HI | I_TI | I_ASO | I_ESO | I_DATE | I_DEPT | I_ITEM | I_LOCN | I_BUYER | I_CLASS | I_DUE_IND | THREAD_ID | I_ALLOC_NO | I_INCR_PCT | I_ORDER_NO | I_PACK_IND | I_PHASE_ID | I_REPL_IND | I_SUBCLASS | I_DOMAIN_ID | I_LOCN_TYPE | I_MAX_STOCK | I_MIN_STOCK | I_REPL_PACK | I_SEASON_ID | I_SOURCE_WH | I_STOCK_CAT | I_UNIT_COST | I_UOM_CLASS | I_ALL_ORDERS | I_DEMO_STOCK | I_ITEM_LEVEL | I_PRES_STOCK | I_STORE_NEED | I_STORE_TYPE | I_TRAN_LEVEL | I_ITEM_PARENT | I_ORDER_POINT | I_REPL_METHOD | I_UNIT_RETAIL | I_OPTIMIZE_IND | I_REVIEW_CYCLE | I_STANDARD_UOM | I_SUB_ITEM_LOC | I_WH_LEAD_TIME | I_ACTIVATE_DATE | I_MBR_ORDER_QTY | I_PHYSICAL_LOCN | I_POOL_SUPPLIER | I_REPL_PACK_QTY | I_SERVICE_LEVEL | I_SUB_STOCK_IND | I_CONTAINER_ITEM | I_STORE_ORD_MULT | I_SUPP_LEAD_TIME | I_SUPP_PACK_SIZE | I_TSF_PO_LINK_NO | I_DEACTIVATE_DATE | I_INNER_PACK_SIZE | I_MAX_SCALE_VALUE | I_MAX_SUPPLY_DAYS | I_MIN_SUPPLY_DAYS | I_NON_SCALING_IND | I_REPL_ORDER_CTRL | I_UOM_CONV_FACTOR | I_INV_SELLING_DAYS | I_ITEM_GRANDPARENT | I_LAST_REVIEW_DATE | I_PICKUP_LEAD_TIME | I_SUB_FORECAST_IND | I_SUP_DEPT_LVL_ORD | I_ADD_LEAD_TIME_IND | I_DEPOSIT_ITEM_TYPE | I_LOST_SALES_FACTOR | I_ORIGIN_COUNTRY_ID | I_ROUND_TO_CASE_PCT | I_STORE_USER_ACCESS | I_DRC_STORE_ORD_MULT | I_LAST_DELIVERY_DATE | I_NEXT_DELIVERY_DATE | I_ROUND_TO_INNER_PCT | I_SERVICE_LEVEL_TYPE | I_SOURCE_PHYSICAL_WH | I_TERMINAL_STOCK_QTY | I_WH_DELIVERY_POLICY | I_DUE_ORD_PROCESS_IND | I_LAST_RUN_OF_THE_DAY | I_ROUND_TO_PALLET_PCT | I_SUP_DELIVERY_POLICY | I_TIME_SUPPLY_HORIZON | I_REJECT_STORE_ORD_IND | I_REPL_RESULTS_ALL_IND | I_ADDITIONAL_DEMAND_QTY | I_PRIMARY_REPL_SUPPLIER | I_INCLUDE_ADDITIONAL_DEMAND |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 2026-01-01 | 1 | SAMPLE | 1 | 1 | 1 | S | 1 | 1 | 1.0000 | 1 | S | 1 | S | 1 | 1 | SAMPLE | 1.0000 | 1.0000 | SAMPLE | 1 | 1 | SAMPLE | 1.0000 | SAMPLE | S | 1.0000 | 1 | 1.0000 | 1.0000 | SAMPLE | 1 | SAMPLE | 1.0000 | SAMPLE | 1.0000 | S | SAMPLE | SAMP | 1 | 1 | 2026-01-01 | 1.0000 | 1 | 1 | 1.0000 | 1.00 | S | SAMPLE | S | 1 | 1.0000 | 1 | 2026-01-01 | 1.0000 | 1.0000 | 1 | 1 | S | SAMPLE | 1.0000000000 | 1 | SAMPLE | 2026-01-01 | 1 | S | SAMPLE | S | SAMPLE | 1.00 | SAM | 1.0000 | SAMPLE | S | 2026-01-01 | 2026-01-01 | 1.0000 | SA | 1 | 1.0000 | SAMPLE | S | S | 1.0000 | SAMPLE | 1 | S | S | 1.0000 | 1 | S |
Example values from field definitions
- I_HI
- 1.0000
- I_TI
- 1.0000
- I_ASO
- 1.0000
- I_ESO
- 1.0000
- I_DATE
- 2026-01-01
- I_DEPT
- 1
- I_ITEM
- SAMPLE
- I_LOCN
- 1
- I_BUYER
- 1
- I_CLASS
- 1
- I_DUE_IND
- S
- THREAD_ID
- 1
- I_ALLOC_NO
- 1
- I_INCR_PCT
- 1.0000
- I_ORDER_NO
- 1
- I_PACK_IND
- S
- I_PHASE_ID
- 1
- I_REPL_IND
- S
- I_SUBCLASS
- 1
- I_DOMAIN_ID
- 1
- I_LOCN_TYPE
- SAMPLE
- I_MAX_STOCK
- 1.0000
- I_MIN_STOCK
- 1.0000
- I_REPL_PACK
- SAMPLE
- I_SEASON_ID
- 1
- I_SOURCE_WH
- 1
- I_STOCK_CAT
- SAMPLE
- I_UNIT_COST
- 1.0000
- I_UOM_CLASS
- SAMPLE
- I_ALL_ORDERS
- S
- I_DEMO_STOCK
- 1.0000
- I_ITEM_LEVEL
- 1
- I_PRES_STOCK
- 1.0000
- I_STORE_NEED
- 1.0000
- I_STORE_TYPE
- SAMPLE
- I_TRAN_LEVEL
- 1
- I_ITEM_PARENT
- SAMPLE
- I_ORDER_POINT
- 1.0000
- I_REPL_METHOD
- SAMPLE
- I_UNIT_RETAIL
- 1.0000
- I_OPTIMIZE_IND
- S
- I_REVIEW_CYCLE
- SAMPLE
- I_STANDARD_UOM
- SAMP
- I_SUB_ITEM_LOC
- 1
- I_WH_LEAD_TIME
- 1
- I_ACTIVATE_DATE
- 2026-01-01
- I_MBR_ORDER_QTY
- 1.0000
- I_PHYSICAL_LOCN
- 1
- I_POOL_SUPPLIER
- 1
- I_REPL_PACK_QTY
- 1.0000
- I_SERVICE_LEVEL
- 1.00
- I_SUB_STOCK_IND
- S
- I_CONTAINER_ITEM
- SAMPLE
- I_STORE_ORD_MULT
- S
- I_SUPP_LEAD_TIME
- 1
- I_SUPP_PACK_SIZE
- 1.0000
- I_TSF_PO_LINK_NO
- 1
- I_DEACTIVATE_DATE
- 2026-01-01
- I_INNER_PACK_SIZE
- 1.0000
- I_MAX_SCALE_VALUE
- 1.0000
- I_MAX_SUPPLY_DAYS
- 1
- I_MIN_SUPPLY_DAYS
- 1
- I_NON_SCALING_IND
- S
- I_REPL_ORDER_CTRL
- SAMPLE
- I_UOM_CONV_FACTOR
- 1.0000000000
- I_INV_SELLING_DAYS
- 1
- I_ITEM_GRANDPARENT
- SAMPLE
- I_LAST_REVIEW_DATE
- 2026-01-01
- I_PICKUP_LEAD_TIME
- 1
- I_SUB_FORECAST_IND
- S
- I_SUP_DEPT_LVL_ORD
- SAMPLE
- I_ADD_LEAD_TIME_IND
- S
- I_DEPOSIT_ITEM_TYPE
- SAMPLE
- I_LOST_SALES_FACTOR
- 1.00
- I_ORIGIN_COUNTRY_ID
- SAM
- I_ROUND_TO_CASE_PCT
- 1.0000
- I_STORE_USER_ACCESS
- SAMPLE
- I_DRC_STORE_ORD_MULT
- S
- I_LAST_DELIVERY_DATE
- 2026-01-01
- I_NEXT_DELIVERY_DATE
- 2026-01-01
- I_ROUND_TO_INNER_PCT
- 1.0000
- I_SERVICE_LEVEL_TYPE
- SA
- I_SOURCE_PHYSICAL_WH
- 1
- I_TERMINAL_STOCK_QTY
- 1.0000
- I_WH_DELIVERY_POLICY
- SAMPLE
- I_DUE_ORD_PROCESS_IND
- S
- I_LAST_RUN_OF_THE_DAY
- S
- I_ROUND_TO_PALLET_PCT
- 1.0000
- I_SUP_DELIVERY_POLICY
- SAMPLE
- I_TIME_SUPPLY_HORIZON
- 1
- I_REJECT_STORE_ORD_IND
- S
- I_REPL_RESULTS_ALL_IND
- S
- I_ADDITIONAL_DEMAND_QTY
- 1.0000
- I_PRIMARY_REPL_SUPPLIER
- 1
- I_INCLUDE_ADDITIONAL_DEMAND
- S
Rule Validation Summary
- Source Rule Count
- 111
- Governed Rule Count
- 89