Replenishment Results
In ScopeTechnical: REPL_RESULTS | ID: OR-REPL-REPL_RESULTS-REPLENISHMENT_RESULTS
This table is used to store item location level replenishment results information and the replenishment attributes used to drive the order quantities for the item location.
See how this object fits into Replenishment
Review the broader sequencing and dependencies for this domain
Migration Details
- Complexity
- Medium
- Sequencing
- Stage 2
- Typical Sources
- ERPLegacy
Classification
- Information Type
- Transaction
- Object Type
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- REPL_RESULTS
Field Definitions(5)
Rules & Considerations(126)
constraint
validation
Sample Load Data(4)
| _scenario | STATUSR | SOURCE_TYPER | HI | ID | TI | DEPT | ITEM | BUYER | CLASS | AUDSID | DUE_IND | RAW_ROQ | RTV_QTY | ALLOC_NO | INCR_PCT | LOCATION | LOC_TYPE | ON_ORDER | ORDER_NO | PACK_QTY | PHASE_ID | SUBCLASS | CASE_SIZE | ITEM_TYPE | MAX_STOCK | MIN_STOCK | NEED_DATE | ORDER_ROQ | REPL_DATE | SEASON_ID | SOURCE_WH | STOCK_CAT | UNIT_COST | COLT_ADDED | DEMO_STOCK | INNER_SIZE | LOST_SALES | NOLT_ADDED | PRES_STOCK | RECALC_QTY | MASTER_ITEM | ORDER_POINT | PHYSICAL_WH | RECALC_TYPE | REPL_METHOD | REVIEW_TIME | SOURCED_ROQ | ALLOC_IN_QTY | CONTRACT_ROQ | OPTIMIZE_IND | ORIG_RAW_ROQ | PRESCALE_ROQ | RAW_ROQ_PACK | REVIEW_CYCLE | SAFETY_STOCK | TSF_RESV_QTY | WH_LEAD_TIME | ACTIVATE_DATE | ALLOC_OUT_QTY | NET_INVENTORY | PACK_COMP_EXP | PACK_COMP_SOH | POOL_SUPPLIER | SERVICE_LEVEL | STOCK_ON_HAND | IN_TRANSIT_QTY | PACK_COMP_RESV | STORE_ORD_MULT | SUPP_LEAD_TIME | SUPP_UNIT_COST | TSF_PO_LINK_NO | DEACTIVATE_DATE | MAX_SCALE_VALUE | MAX_SUPPLY_DAYS | MIN_SUPPLY_DAYS | NON_SCALING_IND | ORD_TEMP_SEQ_NO | REPL_ORDER_CTRL | DELIVERY_SLOT_ID | INV_SELLING_DAYS | LAST_ROUNDED_QTY | NON_SELLABLE_QTY | PACK_COMP_INTRAN | PICKUP_LEAD_TIME | TSF_EXPECTED_QTY | LOST_SALES_FACTOR | ORDER_UP_TO_POINT | ORIGIN_COUNTRY_ID | ORIG_RAW_ROQ_PACK | STORE_USER_ACCESS | ACCEPTED_STOCK_OUT | TERMINAL_STOCK_QTY | ESTIMATED_STOCK_OUT | TIME_SUPPLY_HORIZON | CURR_ORDER_LEAD_TIME | LAST_GRP_ROUNDED_QTY | NEXT_ORDER_LEAD_TIME | REJECT_STORE_ORD_IND | REVIEW_TIME_FORECAST | IN_PROGRESS_SALES_QTY | PRIMARY_REPL_SUPPLIER | INV_SELL_DAYS_FORECAST | NEXT_LEAD_TIME_FORECAST | MAX_SUPPLY_DAYS_FORECAST | MIN_SUPPLY_DAYS_FORECAST | ORDER_LEAD_TIME_FORECAST | INCLUDE_ADDITIONAL_DEMAND | TIME_SUPPLY_HORIZON_FORECAST |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | SAMPLE | 1.0000 | 1 | 1.0000 | 1 | SAMPLE | 1 | 1 | 1 | S | 1.0000 | 1.0000 | 1 | 1.0000 | 1 | S | 1.0000 | 1 | 1.0000 | 1 | 1 | 1.0000 | S | 1.0000 | 1.0000 | 2026-01-01 | 1.0000 | 2026-01-01 | 1 | 1 | SAMPLE | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | SAMPLE | 1.0000 | 1 | S | SAMPLE | 1 | 1.0000 | 1.0000 | 1.0000 | S | 1.0000 | 1.0000 | 1.0000 | SAMPLE | 1.0000 | 1.0000 | 1 | 2026-01-01 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1 | 1.00 | 1.0000 | 1.0000 | 1.0000 | S | 1 | 1.0000 | 1 | 2026-01-01 | 1.0000 | 1 | 1 | S | 1 | SAMPLE | SAMPLE | 1 | 1.0000 | 1.0000 | 1.0000 | 1 | 1.0000 | 1.00 | 1.0000 | SAM | 1.0000 | SAMPLE | 1.0000 | 1.0000 | 1.0000 | 1 | 1.0000 | 1.0000 | 1.0000 | S | 1.0000 | 1.0000 | 1 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | S | 1.0000 |
| default | D | R | 12.5000 | 3 | 12.5000 | 1003 | Repl Results-002-ALT | 3 | 1103 | 3 | N | 12.5000 | 12.5000 | 4 | 12.5000 | 3 | R | 12.5000 | 4 | 12.5000 | 100003 | 1113 | 12.5000 | P | 12.5000 | 12.5000 | 2026-01-03 | 12.5000 | Q | 100003 | 9003 | L | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | Repl Results-002-ALT | 12.5000 | 9003 | R | Repl R | 3 | 12.5000 | 12.5000 | 12.5000 | N | 12.5000 | 12.5000 | 12.5000 | Repl R | 12.5000 | 12.5000 | 3 | 2026-01-03 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 3 | 12.50 | 12.5000 | 12.5000 | 12.5000 | R | 3 | 12.5000 | 4 | 2026-01-03 | 12.5000 | 3 | 3 | R | 4 | Semi | ALT-REPL_RESUL- | 3 | 12.5000 | 12.5000 | 12.5000 | 3 | 12.5000 | 12.50 | 12.5000 | ALT | 12.5000 | REV | 12.5000 | 12.5000 | 12.5000 | 3 | 12.5000 | 12.5000 | 12.5000 | R | 12.5000 | 12.5000 | 3 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | N | 12.5000 |
| default | W | R | 14.0000 | 5 | 14.0000 | 1005 | Repl Results-003-EDGE | 5 | 1105 | 5 | Y | 14.0000 | 14.0000 | 6 | 14.0000 | 5 | R | 14.0000 | 6 | 14.0000 | 100005 | 1115 | 14.0000 | S | 14.0000 | 14.0000 | 2026-01-05 | 14.0000 | A | 100005 | 9005 | Cross | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | Repl Results-003-EDGE | 14.0000 | 9005 | R | Repl R | 5 | 14.0000 | 14.0000 | 14.0000 | N | 14.0000 | 14.0000 | 14.0000 | Repl R | 14.0000 | 14.0000 | 5 | 2026-01-05 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 5 | 14.00 | 14.0000 | 14.0000 | 14.0000 | R | 5 | 14.0000 | 6 | 2026-01-05 | 14.0000 | 5 | 5 | R | 6 | create | EDGE-REPL_RESUL | 5 | 14.0000 | 14.0000 | 14.0000 | 5 | 14.0000 | 14.00 | 14.0000 | EDG | 14.0000 | APRV | 14.0000 | 14.0000 | 14.0000 | 5 | 14.0000 | 14.0000 | 14.0000 | R | 14.0000 | 14.0000 | 5 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | N | 14.0000 |
Example values from field definitions
- STATUSR
- SAMPLE
- SOURCE_TYPER
- SAMPLE
- HI
- 1.0000
- ID
- 1
- TI
- 1.0000
- DEPT
- 1
- ITEM
- SAMPLE
- BUYER
- 1
- CLASS
- 1
- AUDSID
- 1
- DUE_IND
- S
- RAW_ROQ
- 1.0000
- RTV_QTY
- 1.0000
- ALLOC_NO
- 1
- INCR_PCT
- 1.0000
- LOCATION
- 1
- LOC_TYPE
- S
- ON_ORDER
- 1.0000
- ORDER_NO
- 1
- PACK_QTY
- 1.0000
- PHASE_ID
- 1
- SUBCLASS
- 1
- CASE_SIZE
- 1.0000
- ITEM_TYPE
- S
- MAX_STOCK
- 1.0000
- MIN_STOCK
- 1.0000
- NEED_DATE
- 2026-01-01
- ORDER_ROQ
- 1.0000
- REPL_DATE
- 2026-01-01
- SEASON_ID
- 1
- SOURCE_WH
- 1
- STOCK_CAT
- SAMPLE
- UNIT_COST
- 1.0000
- COLT_ADDED
- 1.0000
- DEMO_STOCK
- 1.0000
- INNER_SIZE
- 1.0000
- LOST_SALES
- 1.0000
- NOLT_ADDED
- 1.0000
- PRES_STOCK
- 1.0000
- RECALC_QTY
- 1.0000
- MASTER_ITEM
- SAMPLE
- ORDER_POINT
- 1.0000
- PHYSICAL_WH
- 1
- RECALC_TYPE
- S
- REPL_METHOD
- SAMPLE
- REVIEW_TIME
- 1
- SOURCED_ROQ
- 1.0000
- ALLOC_IN_QTY
- 1.0000
- CONTRACT_ROQ
- 1.0000
- OPTIMIZE_IND
- S
- ORIG_RAW_ROQ
- 1.0000
- PRESCALE_ROQ
- 1.0000
- RAW_ROQ_PACK
- 1.0000
- REVIEW_CYCLE
- SAMPLE
- SAFETY_STOCK
- 1.0000
- TSF_RESV_QTY
- 1.0000
- WH_LEAD_TIME
- 1
- ACTIVATE_DATE
- 2026-01-01
- ALLOC_OUT_QTY
- 1.0000
- NET_INVENTORY
- 1.0000
- PACK_COMP_EXP
- 1.0000
- PACK_COMP_SOH
- 1.0000
- POOL_SUPPLIER
- 1
- SERVICE_LEVEL
- 1.00
- STOCK_ON_HAND
- 1.0000
- IN_TRANSIT_QTY
- 1.0000
- PACK_COMP_RESV
- 1.0000
- STORE_ORD_MULT
- S
- SUPP_LEAD_TIME
- 1
- SUPP_UNIT_COST
- 1.0000
- TSF_PO_LINK_NO
- 1
- DEACTIVATE_DATE
- 2026-01-01
- MAX_SCALE_VALUE
- 1.0000
- MAX_SUPPLY_DAYS
- 1
- MIN_SUPPLY_DAYS
- 1
- NON_SCALING_IND
- S
- ORD_TEMP_SEQ_NO
- 1
- REPL_ORDER_CTRL
- SAMPLE
- DELIVERY_SLOT_ID
- SAMPLE
- INV_SELLING_DAYS
- 1
- LAST_ROUNDED_QTY
- 1.0000
- NON_SELLABLE_QTY
- 1.0000
- PACK_COMP_INTRAN
- 1.0000
- PICKUP_LEAD_TIME
- 1
- TSF_EXPECTED_QTY
- 1.0000
- LOST_SALES_FACTOR
- 1.00
- ORDER_UP_TO_POINT
- 1.0000
- ORIGIN_COUNTRY_ID
- SAM
- ORIG_RAW_ROQ_PACK
- 1.0000
- STORE_USER_ACCESS
- SAMPLE
- ACCEPTED_STOCK_OUT
- 1.0000
- TERMINAL_STOCK_QTY
- 1.0000
- ESTIMATED_STOCK_OUT
- 1.0000
- TIME_SUPPLY_HORIZON
- 1
- CURR_ORDER_LEAD_TIME
- 1.0000
- LAST_GRP_ROUNDED_QTY
- 1.0000
- NEXT_ORDER_LEAD_TIME
- 1.0000
- REJECT_STORE_ORD_IND
- S
- REVIEW_TIME_FORECAST
- 1.0000
- IN_PROGRESS_SALES_QTY
- 1.0000
- PRIMARY_REPL_SUPPLIER
- 1
- INV_SELL_DAYS_FORECAST
- 1.0000
- NEXT_LEAD_TIME_FORECAST
- 1.0000
- MAX_SUPPLY_DAYS_FORECAST
- 1.0000
- MIN_SUPPLY_DAYS_FORECAST
- 1.0000
- ORDER_LEAD_TIME_FORECAST
- 1.0000
- INCLUDE_ADDITIONAL_DEMAND
- S
- TIME_SUPPLY_HORIZON_FORECAST
- 1.0000
default
- STATUSR
- D
- SOURCE_TYPER
- R
- HI
- 12.5000
- ID
- 3
- TI
- 12.5000
- DEPT
- 1003
- ITEM
- Repl Results-002-ALT
- BUYER
- 3
- CLASS
- 1103
- AUDSID
- 3
- DUE_IND
- N
- RAW_ROQ
- 12.5000
- RTV_QTY
- 12.5000
- ALLOC_NO
- 4
- INCR_PCT
- 12.5000
- LOCATION
- 3
- LOC_TYPE
- R
- ON_ORDER
- 12.5000
- ORDER_NO
- 4
- PACK_QTY
- 12.5000
- PHASE_ID
- 100003
- SUBCLASS
- 1113
- CASE_SIZE
- 12.5000
- ITEM_TYPE
- P
- MAX_STOCK
- 12.5000
- MIN_STOCK
- 12.5000
- NEED_DATE
- 2026-01-03
- ORDER_ROQ
- 12.5000
- REPL_DATE
- Q
- SEASON_ID
- 100003
- SOURCE_WH
- 9003
- STOCK_CAT
- L
- UNIT_COST
- 12.5000
- COLT_ADDED
- 12.5000
- DEMO_STOCK
- 12.5000
- INNER_SIZE
- 12.5000
- LOST_SALES
- 12.5000
- NOLT_ADDED
- 12.5000
- PRES_STOCK
- 12.5000
- RECALC_QTY
- 12.5000
- MASTER_ITEM
- Repl Results-002-ALT
- ORDER_POINT
- 12.5000
- PHYSICAL_WH
- 9003
- RECALC_TYPE
- R
- REPL_METHOD
- Repl R
- REVIEW_TIME
- 3
- SOURCED_ROQ
- 12.5000
- ALLOC_IN_QTY
- 12.5000
- CONTRACT_ROQ
- 12.5000
- OPTIMIZE_IND
- N
- ORIG_RAW_ROQ
- 12.5000
- PRESCALE_ROQ
- 12.5000
- RAW_ROQ_PACK
- 12.5000
- REVIEW_CYCLE
- Repl R
- SAFETY_STOCK
- 12.5000
- TSF_RESV_QTY
- 12.5000
- WH_LEAD_TIME
- 3
- ACTIVATE_DATE
- 2026-01-03
- ALLOC_OUT_QTY
- 12.5000
- NET_INVENTORY
- 12.5000
- PACK_COMP_EXP
- 12.5000
- PACK_COMP_SOH
- 12.5000
- POOL_SUPPLIER
- 3
- SERVICE_LEVEL
- 12.50
- STOCK_ON_HAND
- 12.5000
- IN_TRANSIT_QTY
- 12.5000
- PACK_COMP_RESV
- 12.5000
- STORE_ORD_MULT
- R
- SUPP_LEAD_TIME
- 3
- SUPP_UNIT_COST
- 12.5000
- TSF_PO_LINK_NO
- 4
- DEACTIVATE_DATE
- 2026-01-03
- MAX_SCALE_VALUE
- 12.5000
- MAX_SUPPLY_DAYS
- 3
- MIN_SUPPLY_DAYS
- 3
- NON_SCALING_IND
- R
- ORD_TEMP_SEQ_NO
- 4
- REPL_ORDER_CTRL
- Semi
- DELIVERY_SLOT_ID
- ALT-REPL_RESUL-
- INV_SELLING_DAYS
- 3
- LAST_ROUNDED_QTY
- 12.5000
- NON_SELLABLE_QTY
- 12.5000
- PACK_COMP_INTRAN
- 12.5000
- PICKUP_LEAD_TIME
- 3
- TSF_EXPECTED_QTY
- 12.5000
- LOST_SALES_FACTOR
- 12.50
- ORDER_UP_TO_POINT
- 12.5000
- ORIGIN_COUNTRY_ID
- ALT
- ORIG_RAW_ROQ_PACK
- 12.5000
- STORE_USER_ACCESS
- REV
- ACCEPTED_STOCK_OUT
- 12.5000
- TERMINAL_STOCK_QTY
- 12.5000
- ESTIMATED_STOCK_OUT
- 12.5000
- TIME_SUPPLY_HORIZON
- 3
- CURR_ORDER_LEAD_TIME
- 12.5000
- LAST_GRP_ROUNDED_QTY
- 12.5000
- NEXT_ORDER_LEAD_TIME
- 12.5000
- REJECT_STORE_ORD_IND
- R
- REVIEW_TIME_FORECAST
- 12.5000
- IN_PROGRESS_SALES_QTY
- 12.5000
- PRIMARY_REPL_SUPPLIER
- 3
- INV_SELL_DAYS_FORECAST
- 12.5000
- NEXT_LEAD_TIME_FORECAST
- 12.5000
- MAX_SUPPLY_DAYS_FORECAST
- 12.5000
- MIN_SUPPLY_DAYS_FORECAST
- 12.5000
- ORDER_LEAD_TIME_FORECAST
- 12.5000
- INCLUDE_ADDITIONAL_DEMAND
- N
- TIME_SUPPLY_HORIZON_FORECAST
- 12.5000
default
- STATUSR
- W
- SOURCE_TYPER
- R
- HI
- 14.0000
- ID
- 5
- TI
- 14.0000
- DEPT
- 1005
- ITEM
- Repl Results-003-EDGE
- BUYER
- 5
- CLASS
- 1105
- AUDSID
- 5
- DUE_IND
- Y
- RAW_ROQ
- 14.0000
- RTV_QTY
- 14.0000
- ALLOC_NO
- 6
- INCR_PCT
- 14.0000
- LOCATION
- 5
- LOC_TYPE
- R
- ON_ORDER
- 14.0000
- ORDER_NO
- 6
- PACK_QTY
- 14.0000
- PHASE_ID
- 100005
- SUBCLASS
- 1115
- CASE_SIZE
- 14.0000
- ITEM_TYPE
- S
- MAX_STOCK
- 14.0000
- MIN_STOCK
- 14.0000
- NEED_DATE
- 2026-01-05
- ORDER_ROQ
- 14.0000
- REPL_DATE
- A
- SEASON_ID
- 100005
- SOURCE_WH
- 9005
- STOCK_CAT
- Cross
- UNIT_COST
- 14.0000
- COLT_ADDED
- 14.0000
- DEMO_STOCK
- 14.0000
- INNER_SIZE
- 14.0000
- LOST_SALES
- 14.0000
- NOLT_ADDED
- 14.0000
- PRES_STOCK
- 14.0000
- RECALC_QTY
- 14.0000
- MASTER_ITEM
- Repl Results-003-EDGE
- ORDER_POINT
- 14.0000
- PHYSICAL_WH
- 9005
- RECALC_TYPE
- R
- REPL_METHOD
- Repl R
- REVIEW_TIME
- 5
- SOURCED_ROQ
- 14.0000
- ALLOC_IN_QTY
- 14.0000
- CONTRACT_ROQ
- 14.0000
- OPTIMIZE_IND
- N
- ORIG_RAW_ROQ
- 14.0000
- PRESCALE_ROQ
- 14.0000
- RAW_ROQ_PACK
- 14.0000
- REVIEW_CYCLE
- Repl R
- SAFETY_STOCK
- 14.0000
- TSF_RESV_QTY
- 14.0000
- WH_LEAD_TIME
- 5
- ACTIVATE_DATE
- 2026-01-05
- ALLOC_OUT_QTY
- 14.0000
- NET_INVENTORY
- 14.0000
- PACK_COMP_EXP
- 14.0000
- PACK_COMP_SOH
- 14.0000
- POOL_SUPPLIER
- 5
- SERVICE_LEVEL
- 14.00
- STOCK_ON_HAND
- 14.0000
- IN_TRANSIT_QTY
- 14.0000
- PACK_COMP_RESV
- 14.0000
- STORE_ORD_MULT
- R
- SUPP_LEAD_TIME
- 5
- SUPP_UNIT_COST
- 14.0000
- TSF_PO_LINK_NO
- 6
- DEACTIVATE_DATE
- 2026-01-05
- MAX_SCALE_VALUE
- 14.0000
- MAX_SUPPLY_DAYS
- 5
- MIN_SUPPLY_DAYS
- 5
- NON_SCALING_IND
- R
- ORD_TEMP_SEQ_NO
- 6
- REPL_ORDER_CTRL
- create
- DELIVERY_SLOT_ID
- EDGE-REPL_RESUL
- INV_SELLING_DAYS
- 5
- LAST_ROUNDED_QTY
- 14.0000
- NON_SELLABLE_QTY
- 14.0000
- PACK_COMP_INTRAN
- 14.0000
- PICKUP_LEAD_TIME
- 5
- TSF_EXPECTED_QTY
- 14.0000
- LOST_SALES_FACTOR
- 14.00
- ORDER_UP_TO_POINT
- 14.0000
- ORIGIN_COUNTRY_ID
- EDG
- ORIG_RAW_ROQ_PACK
- 14.0000
- STORE_USER_ACCESS
- APRV
- ACCEPTED_STOCK_OUT
- 14.0000
- TERMINAL_STOCK_QTY
- 14.0000
- ESTIMATED_STOCK_OUT
- 14.0000
- TIME_SUPPLY_HORIZON
- 5
- CURR_ORDER_LEAD_TIME
- 14.0000
- LAST_GRP_ROUNDED_QTY
- 14.0000
- NEXT_ORDER_LEAD_TIME
- 14.0000
- REJECT_STORE_ORD_IND
- R
- REVIEW_TIME_FORECAST
- 14.0000
- IN_PROGRESS_SALES_QTY
- 14.0000
- PRIMARY_REPL_SUPPLIER
- 5
- INV_SELL_DAYS_FORECAST
- 14.0000
- NEXT_LEAD_TIME_FORECAST
- 14.0000
- MAX_SUPPLY_DAYS_FORECAST
- 14.0000
- MIN_SUPPLY_DAYS_FORECAST
- 14.0000
- ORDER_LEAD_TIME_FORECAST
- 14.0000
- INCLUDE_ADDITIONAL_DEMAND
- N
- TIME_SUPPLY_HORIZON_FORECAST
- 14.0000
Rule Validation Summary
- Source Rule Count
- 190
- Governed Rule Count
- 126