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(5)
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 |
| default | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 2026-01-03 | 1003 | Svc Repl Roq-002-ALT | 3 | 3 | 1103 | S | 1000000003 | 4 | 12.5000 | 4 | S | 100003 | S | 1113 | 100003 | Svc Re | 12.5000 | 12.5000 | Svc Repl Roq-002-ALT | 100003 | 9003 | L | 12.5000 | Svc Re | N | 12.5000 | 3 | 12.5000 | 12.5000 | C | 3 | Svc Repl Roq-002-ALT | 12.5000 | Svc Re | 12.5000 | S | Svc Re | Svc | 3 | 3 | 2026-01-03 | 12.5000 | 3 | 3 | 12.5000 | 12.50 | S | Svc Repl Roq-002-ALT | S | 3 | 12.5000 | 4 | 2026-01-03 | 12.5000 | 12.5000 | 3 | 3 | S | Semi | 12.5000000000 | 3 | Svc Repl Roq-002-ALT | 2026-01-03 | 3 | N | Svc Re | S | Svc Re | 12.50 | ALT | 12.5000 | REV | u | 2026-01-03 | 2026-01-03 | 12.5000 | Sv | 9003 | 12.5000 | Svc Re | N | S | 12.5000 | Svc Re | 3 | S | S | 12.5000 | 3 | S |
| default | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 2026-01-05 | 1005 | Svc Repl Roq-003-EDGE | 5 | 5 | 1105 | S | 1000000005 | 6 | 14.0000 | 6 | S | 100005 | S | 1115 | 100005 | Svc Re | 14.0000 | 14.0000 | Svc Repl Roq-003-EDGE | 100005 | 9005 | Cross | 14.0000 | Svc Re | N | 14.0000 | 5 | 14.0000 | 14.0000 | F | 5 | Svc Repl Roq-003-EDGE | 14.0000 | Svc Re | 14.0000 | S | Svc Re | Svc | 5 | 5 | 2026-01-05 | 14.0000 | 5 | 5 | 14.0000 | 14.00 | S | Svc Repl Roq-003-EDGE | S | 5 | 14.0000 | 6 | 2026-01-05 | 14.0000 | 14.0000 | 5 | 5 | S | create | 14.0000000000 | 5 | Svc Repl Roq-003-EDGE | 2026-01-05 | 5 | Y | Svc Re | S | Svc Re | 14.00 | EDG | 14.0000 | APRV | u | 2026-01-05 | 2026-01-05 | 14.0000 | Sv | 9005 | 14.0000 | Svc Re | Y | S | 14.0000 | Svc Re | 5 | S | S | 14.0000 | 5 | 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
default
- I_HI
- 12.5000
- I_TI
- 12.5000
- I_ASO
- 12.5000
- I_ESO
- 12.5000
- I_DATE
- 2026-01-03
- I_DEPT
- 1003
- I_ITEM
- Svc Repl Roq-002-ALT
- I_LOCN
- 3
- I_BUYER
- 3
- I_CLASS
- 1103
- I_DUE_IND
- S
- THREAD_ID
- 1000000003
- I_ALLOC_NO
- 4
- I_INCR_PCT
- 12.5000
- I_ORDER_NO
- 4
- I_PACK_IND
- S
- I_PHASE_ID
- 100003
- I_REPL_IND
- S
- I_SUBCLASS
- 1113
- I_DOMAIN_ID
- 100003
- I_LOCN_TYPE
- Svc Re
- I_MAX_STOCK
- 12.5000
- I_MIN_STOCK
- 12.5000
- I_REPL_PACK
- Svc Repl Roq-002-ALT
- I_SEASON_ID
- 100003
- I_SOURCE_WH
- 9003
- I_STOCK_CAT
- L
- I_UNIT_COST
- 12.5000
- I_UOM_CLASS
- Svc Re
- I_ALL_ORDERS
- N
- I_DEMO_STOCK
- 12.5000
- I_ITEM_LEVEL
- 3
- I_PRES_STOCK
- 12.5000
- I_STORE_NEED
- 12.5000
- I_STORE_TYPE
- C
- I_TRAN_LEVEL
- 3
- I_ITEM_PARENT
- Svc Repl Roq-002-ALT
- I_ORDER_POINT
- 12.5000
- I_REPL_METHOD
- Svc Re
- I_UNIT_RETAIL
- 12.5000
- I_OPTIMIZE_IND
- S
- I_REVIEW_CYCLE
- Svc Re
- I_STANDARD_UOM
- Svc
- I_SUB_ITEM_LOC
- 3
- I_WH_LEAD_TIME
- 3
- I_ACTIVATE_DATE
- 2026-01-03
- I_MBR_ORDER_QTY
- 12.5000
- I_PHYSICAL_LOCN
- 3
- I_POOL_SUPPLIER
- 3
- I_REPL_PACK_QTY
- 12.5000
- I_SERVICE_LEVEL
- 12.50
- I_SUB_STOCK_IND
- S
- I_CONTAINER_ITEM
- Svc Repl Roq-002-ALT
- I_STORE_ORD_MULT
- S
- I_SUPP_LEAD_TIME
- 3
- I_SUPP_PACK_SIZE
- 12.5000
- I_TSF_PO_LINK_NO
- 4
- I_DEACTIVATE_DATE
- 2026-01-03
- I_INNER_PACK_SIZE
- 12.5000
- I_MAX_SCALE_VALUE
- 12.5000
- I_MAX_SUPPLY_DAYS
- 3
- I_MIN_SUPPLY_DAYS
- 3
- I_NON_SCALING_IND
- S
- I_REPL_ORDER_CTRL
- Semi
- I_UOM_CONV_FACTOR
- 12.5000000000
- I_INV_SELLING_DAYS
- 3
- I_ITEM_GRANDPARENT
- Svc Repl Roq-002-ALT
- I_LAST_REVIEW_DATE
- 2026-01-03
- I_PICKUP_LEAD_TIME
- 3
- I_SUB_FORECAST_IND
- N
- I_SUP_DEPT_LVL_ORD
- Svc Re
- I_ADD_LEAD_TIME_IND
- S
- I_DEPOSIT_ITEM_TYPE
- Svc Re
- I_LOST_SALES_FACTOR
- 12.50
- I_ORIGIN_COUNTRY_ID
- ALT
- I_ROUND_TO_CASE_PCT
- 12.5000
- I_STORE_USER_ACCESS
- REV
- I_DRC_STORE_ORD_MULT
- u
- I_LAST_DELIVERY_DATE
- 2026-01-03
- I_NEXT_DELIVERY_DATE
- 2026-01-03
- I_ROUND_TO_INNER_PCT
- 12.5000
- I_SERVICE_LEVEL_TYPE
- Sv
- I_SOURCE_PHYSICAL_WH
- 9003
- I_TERMINAL_STOCK_QTY
- 12.5000
- I_WH_DELIVERY_POLICY
- Svc Re
- I_DUE_ORD_PROCESS_IND
- N
- I_LAST_RUN_OF_THE_DAY
- S
- I_ROUND_TO_PALLET_PCT
- 12.5000
- I_SUP_DELIVERY_POLICY
- Svc Re
- I_TIME_SUPPLY_HORIZON
- 3
- I_REJECT_STORE_ORD_IND
- S
- I_REPL_RESULTS_ALL_IND
- S
- I_ADDITIONAL_DEMAND_QTY
- 12.5000
- I_PRIMARY_REPL_SUPPLIER
- 3
- I_INCLUDE_ADDITIONAL_DEMAND
- S
default
- I_HI
- 14.0000
- I_TI
- 14.0000
- I_ASO
- 14.0000
- I_ESO
- 14.0000
- I_DATE
- 2026-01-05
- I_DEPT
- 1005
- I_ITEM
- Svc Repl Roq-003-EDGE
- I_LOCN
- 5
- I_BUYER
- 5
- I_CLASS
- 1105
- I_DUE_IND
- S
- THREAD_ID
- 1000000005
- I_ALLOC_NO
- 6
- I_INCR_PCT
- 14.0000
- I_ORDER_NO
- 6
- I_PACK_IND
- S
- I_PHASE_ID
- 100005
- I_REPL_IND
- S
- I_SUBCLASS
- 1115
- I_DOMAIN_ID
- 100005
- I_LOCN_TYPE
- Svc Re
- I_MAX_STOCK
- 14.0000
- I_MIN_STOCK
- 14.0000
- I_REPL_PACK
- Svc Repl Roq-003-EDGE
- I_SEASON_ID
- 100005
- I_SOURCE_WH
- 9005
- I_STOCK_CAT
- Cross
- I_UNIT_COST
- 14.0000
- I_UOM_CLASS
- Svc Re
- I_ALL_ORDERS
- N
- I_DEMO_STOCK
- 14.0000
- I_ITEM_LEVEL
- 5
- I_PRES_STOCK
- 14.0000
- I_STORE_NEED
- 14.0000
- I_STORE_TYPE
- F
- I_TRAN_LEVEL
- 5
- I_ITEM_PARENT
- Svc Repl Roq-003-EDGE
- I_ORDER_POINT
- 14.0000
- I_REPL_METHOD
- Svc Re
- I_UNIT_RETAIL
- 14.0000
- I_OPTIMIZE_IND
- S
- I_REVIEW_CYCLE
- Svc Re
- I_STANDARD_UOM
- Svc
- I_SUB_ITEM_LOC
- 5
- I_WH_LEAD_TIME
- 5
- I_ACTIVATE_DATE
- 2026-01-05
- I_MBR_ORDER_QTY
- 14.0000
- I_PHYSICAL_LOCN
- 5
- I_POOL_SUPPLIER
- 5
- I_REPL_PACK_QTY
- 14.0000
- I_SERVICE_LEVEL
- 14.00
- I_SUB_STOCK_IND
- S
- I_CONTAINER_ITEM
- Svc Repl Roq-003-EDGE
- I_STORE_ORD_MULT
- S
- I_SUPP_LEAD_TIME
- 5
- I_SUPP_PACK_SIZE
- 14.0000
- I_TSF_PO_LINK_NO
- 6
- I_DEACTIVATE_DATE
- 2026-01-05
- I_INNER_PACK_SIZE
- 14.0000
- I_MAX_SCALE_VALUE
- 14.0000
- I_MAX_SUPPLY_DAYS
- 5
- I_MIN_SUPPLY_DAYS
- 5
- I_NON_SCALING_IND
- S
- I_REPL_ORDER_CTRL
- create
- I_UOM_CONV_FACTOR
- 14.0000000000
- I_INV_SELLING_DAYS
- 5
- I_ITEM_GRANDPARENT
- Svc Repl Roq-003-EDGE
- I_LAST_REVIEW_DATE
- 2026-01-05
- I_PICKUP_LEAD_TIME
- 5
- I_SUB_FORECAST_IND
- Y
- I_SUP_DEPT_LVL_ORD
- Svc Re
- I_ADD_LEAD_TIME_IND
- S
- I_DEPOSIT_ITEM_TYPE
- Svc Re
- I_LOST_SALES_FACTOR
- 14.00
- I_ORIGIN_COUNTRY_ID
- EDG
- I_ROUND_TO_CASE_PCT
- 14.0000
- I_STORE_USER_ACCESS
- APRV
- I_DRC_STORE_ORD_MULT
- u
- I_LAST_DELIVERY_DATE
- 2026-01-05
- I_NEXT_DELIVERY_DATE
- 2026-01-05
- I_ROUND_TO_INNER_PCT
- 14.0000
- I_SERVICE_LEVEL_TYPE
- Sv
- I_SOURCE_PHYSICAL_WH
- 9005
- I_TERMINAL_STOCK_QTY
- 14.0000
- I_WH_DELIVERY_POLICY
- Svc Re
- I_DUE_ORD_PROCESS_IND
- Y
- I_LAST_RUN_OF_THE_DAY
- S
- I_ROUND_TO_PALLET_PCT
- 14.0000
- I_SUP_DELIVERY_POLICY
- Svc Re
- I_TIME_SUPPLY_HORIZON
- 5
- I_REJECT_STORE_ORD_IND
- S
- I_REPL_RESULTS_ALL_IND
- S
- I_ADDITIONAL_DEMAND_QTY
- 14.0000
- I_PRIMARY_REPL_SUPPLIER
- 5
- I_INCLUDE_ADDITIONAL_DEMAND
- S
Rule Validation Summary
- Source Rule Count
- 111
- Governed Rule Count
- 89