Item Location Level Replenishment Attributes
In ScopeTechnical: REPL_ITEM_LOC | ID: OR-REPL-REPL_ITEM_LOC-REPLENISHMENT_ITEM_LOCATION
This table is used to store item location level replenishment attributes.
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
- Object Type
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- REPL_ITEM_LOC
Field Definitions(5)
Rules & Considerations(92)
validation
constraint
Sample Load Data(4)
| _scenario | ITEMRPK | LOCATIONRPK | LOC_TYPER | HI | TI | DEPT | CLASS | STATUS | INCR_PCT | LAST_ROQ | PHASE_ID | SUBCLASS | MAX_STOCK | MIN_STOCK | ROUND_LVL | SEASON_ID | SOURCE_WH | STOCK_CAT | UNIT_COST | DEMO_STOCK | PRES_STOCK | ITEM_PARENT | REPL_METHOD | OPTIMIZE_IND | REVIEW_CYCLE | WH_LEAD_TIME | ACTIVATE_DATE | MBR_ORDER_QTY | PCT_TOLERANCE | SERVICE_LEVEL | LAST_UPDATE_ID | STORE_ORD_MULT | SUPP_LEAD_TIME | SUPP_PACK_SIZE | TSF_PO_LINK_NO | UNIT_TOLERANCE | CREATE_DATETIME | DEACTIVATE_DATE | INNER_PACK_SIZE | MAX_SCALE_VALUE | MAX_SUPPLY_DAYS | MIN_SUPPLY_DAYS | NON_SCALING_IND | PRIMARY_PACK_NO | REPL_ORDER_CTRL | INV_SELLING_DAYS | ITEM_GRANDPARENT | LAST_REVIEW_DATE | NEXT_REVIEW_DATE | PICKUP_LEAD_TIME | PRIMARY_PACK_QTY | TSF_ZERO_SOH_IND | ADD_LEAD_TIME_IND | LOST_SALES_FACTOR | ORIGIN_COUNTRY_ID | ROUND_TO_CASE_PCT | STORE_USER_ACCESS | USE_TOLERANCE_IND | ADJ_SUPP_LEAD_TIME | ITEM_SEASON_SEQ_NO | LAST_DELIVERY_DATE | NEXT_DELIVERY_DATE | ROUND_TO_INNER_PCT | ROUND_TO_LAYER_PCT | SERVICE_LEVEL_TYPE | TERMINAL_STOCK_QTY | ROUND_TO_PALLET_PCT | TIME_SUPPLY_HORIZON | ADJ_PICKUP_LEAD_TIME | LAST_UPDATE_DATETIME | REJECT_STORE_ORD_IND | STORE_TOLERANCE_TYPE | MULT_RUNS_PER_DAY_IND | PRIMARY_REPL_SUPPLIER | INCLUDE_ADDITIONAL_DEMAND |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | 1 | SAMPLE | 1.0000 | 1.0000 | 1 | 1 | S | 1.0000 | 1.0000 | 1 | 1 | 1.0000 | 1.0000 | SAMPLE | 1 | 1 | SAMPLE | 1.0000 | 1.0000 | 1.0000 | SAMPLE | SAMPLE | S | SAMPLE | 1 | 2026-01-01 | 1.0000 | 1.0000 | 1.00 | SAMPLE | SAMPLE | 1 | 1.0000 | 1 | 1.0000 | 2026-01-01 | 2026-01-01 | 1.0000 | 1.0000 | 1 | 1 | S | SAMPLE | SAMPLE | 1 | SAMPLE | 2026-01-01 | 2026-01-01 | 1 | 1.0000 | S | S | 1.00 | SAM | 1.0000 | SAMPLE | S | 1 | 1 | 2026-01-01 | 2026-01-01 | 1.0000 | 1.0000 | SA | 1.0000 | 1.0000 | 1 | 1 | 2026-01-01 | S | SAMPLE | S | 1 | S |
| default | Repl Item Loc-002-ALT | 3 | Repl I | 12.5000 | 12.5000 | 1003 | 1103 | S | 12.5000 | 12.5000 | 100003 | 1113 | 12.5000 | 12.5000 | Repl I | 100003 | 9003 | L | 12.5000 | 12.5000 | 12.5000 | Repl Item Loc-002-ALT | Repl I | N | Repl I | 3 | 2026-01-03 | 12.5000 | 12.5000 | 12.50 | MDM_USER | used | 3 | 12.5000 | 4 | 12.5000 | 2026-01-03 | 2026-01-03 | 12.5000 | 12.5000 | 3 | 3 | R | Repl Item Loc-002-ALT | Semi | 3 | Repl Item Loc-002-ALT | 2026-01-03 | 2026-01-03 | 3 | 12.5000 | N | R | 12.50 | ALT | 12.5000 | REV | R | 3 | 4 | 2026-01-03 | 2026-01-03 | 12.5000 | 12.5000 | Re | 12.5000 | 12.5000 | 3 | 3 | 2026-01-03 | R | UNI | N | 3 | N |
| default | Repl Item Loc-003-EDGE | 5 | Repl I | 14.0000 | 14.0000 | 1005 | 1105 | A | 14.0000 | 14.0000 | 100005 | 1115 | 14.0000 | 14.0000 | Repl I | 100005 | 9005 | Cross | 14.0000 | 14.0000 | 14.0000 | Repl Item Loc-003-EDGE | Repl I | N | Repl I | 5 | 2026-01-05 | 14.0000 | 14.0000 | 14.00 | BATCH_USER | used | 5 | 14.0000 | 6 | 14.0000 | 2026-01-05 | 2026-01-05 | 14.0000 | 14.0000 | 5 | 5 | R | Repl Item Loc-003-EDGE | create | 5 | Repl Item Loc-003-EDGE | 2026-01-05 | 2026-01-05 | 5 | 14.0000 | N | R | 14.00 | EDG | 14.0000 | APRV | R | 5 | 6 | 2026-01-05 | 2026-01-05 | 14.0000 | 14.0000 | Re | 14.0000 | 14.0000 | 5 | 5 | 2026-01-05 | R | PER | N | 5 | N |
Example values from field definitions
- ITEMRPK
- SAMPLE
- LOCATIONRPK
- 1
- LOC_TYPER
- SAMPLE
- HI
- 1.0000
- TI
- 1.0000
- DEPT
- 1
- CLASS
- 1
- STATUS
- S
- INCR_PCT
- 1.0000
- LAST_ROQ
- 1.0000
- PHASE_ID
- 1
- SUBCLASS
- 1
- MAX_STOCK
- 1.0000
- MIN_STOCK
- 1.0000
- ROUND_LVL
- SAMPLE
- SEASON_ID
- 1
- SOURCE_WH
- 1
- STOCK_CAT
- SAMPLE
- UNIT_COST
- 1.0000
- DEMO_STOCK
- 1.0000
- PRES_STOCK
- 1.0000
- ITEM_PARENT
- SAMPLE
- REPL_METHOD
- SAMPLE
- OPTIMIZE_IND
- S
- REVIEW_CYCLE
- SAMPLE
- WH_LEAD_TIME
- 1
- ACTIVATE_DATE
- 2026-01-01
- MBR_ORDER_QTY
- 1.0000
- PCT_TOLERANCE
- 1.0000
- SERVICE_LEVEL
- 1.00
- LAST_UPDATE_ID
- SAMPLE
- STORE_ORD_MULT
- SAMPLE
- SUPP_LEAD_TIME
- 1
- SUPP_PACK_SIZE
- 1.0000
- TSF_PO_LINK_NO
- 1
- UNIT_TOLERANCE
- 1.0000
- CREATE_DATETIME
- 2026-01-01
- DEACTIVATE_DATE
- 2026-01-01
- INNER_PACK_SIZE
- 1.0000
- MAX_SCALE_VALUE
- 1.0000
- MAX_SUPPLY_DAYS
- 1
- MIN_SUPPLY_DAYS
- 1
- NON_SCALING_IND
- S
- PRIMARY_PACK_NO
- SAMPLE
- REPL_ORDER_CTRL
- SAMPLE
- INV_SELLING_DAYS
- 1
- ITEM_GRANDPARENT
- SAMPLE
- LAST_REVIEW_DATE
- 2026-01-01
- NEXT_REVIEW_DATE
- 2026-01-01
- PICKUP_LEAD_TIME
- 1
- PRIMARY_PACK_QTY
- 1.0000
- TSF_ZERO_SOH_IND
- S
- ADD_LEAD_TIME_IND
- S
- LOST_SALES_FACTOR
- 1.00
- ORIGIN_COUNTRY_ID
- SAM
- ROUND_TO_CASE_PCT
- 1.0000
- STORE_USER_ACCESS
- SAMPLE
- USE_TOLERANCE_IND
- S
- ADJ_SUPP_LEAD_TIME
- 1
- ITEM_SEASON_SEQ_NO
- 1
- LAST_DELIVERY_DATE
- 2026-01-01
- NEXT_DELIVERY_DATE
- 2026-01-01
- ROUND_TO_INNER_PCT
- 1.0000
- ROUND_TO_LAYER_PCT
- 1.0000
- SERVICE_LEVEL_TYPE
- SA
- TERMINAL_STOCK_QTY
- 1.0000
- ROUND_TO_PALLET_PCT
- 1.0000
- TIME_SUPPLY_HORIZON
- 1
- ADJ_PICKUP_LEAD_TIME
- 1
- LAST_UPDATE_DATETIME
- 2026-01-01
- REJECT_STORE_ORD_IND
- S
- STORE_TOLERANCE_TYPE
- SAMPLE
- MULT_RUNS_PER_DAY_IND
- S
- PRIMARY_REPL_SUPPLIER
- 1
- INCLUDE_ADDITIONAL_DEMAND
- S
default
- ITEMRPK
- Repl Item Loc-002-ALT
- LOCATIONRPK
- 3
- LOC_TYPER
- Repl I
- HI
- 12.5000
- TI
- 12.5000
- DEPT
- 1003
- CLASS
- 1103
- STATUS
- S
- INCR_PCT
- 12.5000
- LAST_ROQ
- 12.5000
- PHASE_ID
- 100003
- SUBCLASS
- 1113
- MAX_STOCK
- 12.5000
- MIN_STOCK
- 12.5000
- ROUND_LVL
- Repl I
- SEASON_ID
- 100003
- SOURCE_WH
- 9003
- STOCK_CAT
- L
- UNIT_COST
- 12.5000
- DEMO_STOCK
- 12.5000
- PRES_STOCK
- 12.5000
- ITEM_PARENT
- Repl Item Loc-002-ALT
- REPL_METHOD
- Repl I
- OPTIMIZE_IND
- N
- REVIEW_CYCLE
- Repl I
- WH_LEAD_TIME
- 3
- ACTIVATE_DATE
- 2026-01-03
- MBR_ORDER_QTY
- 12.5000
- PCT_TOLERANCE
- 12.5000
- SERVICE_LEVEL
- 12.50
- LAST_UPDATE_ID
- MDM_USER
- STORE_ORD_MULT
- used
- SUPP_LEAD_TIME
- 3
- SUPP_PACK_SIZE
- 12.5000
- TSF_PO_LINK_NO
- 4
- UNIT_TOLERANCE
- 12.5000
- CREATE_DATETIME
- 2026-01-03
- DEACTIVATE_DATE
- 2026-01-03
- INNER_PACK_SIZE
- 12.5000
- MAX_SCALE_VALUE
- 12.5000
- MAX_SUPPLY_DAYS
- 3
- MIN_SUPPLY_DAYS
- 3
- NON_SCALING_IND
- R
- PRIMARY_PACK_NO
- Repl Item Loc-002-ALT
- REPL_ORDER_CTRL
- Semi
- INV_SELLING_DAYS
- 3
- ITEM_GRANDPARENT
- Repl Item Loc-002-ALT
- LAST_REVIEW_DATE
- 2026-01-03
- NEXT_REVIEW_DATE
- 2026-01-03
- PICKUP_LEAD_TIME
- 3
- PRIMARY_PACK_QTY
- 12.5000
- TSF_ZERO_SOH_IND
- N
- ADD_LEAD_TIME_IND
- R
- LOST_SALES_FACTOR
- 12.50
- ORIGIN_COUNTRY_ID
- ALT
- ROUND_TO_CASE_PCT
- 12.5000
- STORE_USER_ACCESS
- REV
- USE_TOLERANCE_IND
- R
- ADJ_SUPP_LEAD_TIME
- 3
- ITEM_SEASON_SEQ_NO
- 4
- LAST_DELIVERY_DATE
- 2026-01-03
- NEXT_DELIVERY_DATE
- 2026-01-03
- ROUND_TO_INNER_PCT
- 12.5000
- ROUND_TO_LAYER_PCT
- 12.5000
- SERVICE_LEVEL_TYPE
- Re
- TERMINAL_STOCK_QTY
- 12.5000
- ROUND_TO_PALLET_PCT
- 12.5000
- TIME_SUPPLY_HORIZON
- 3
- ADJ_PICKUP_LEAD_TIME
- 3
- LAST_UPDATE_DATETIME
- 2026-01-03
- REJECT_STORE_ORD_IND
- R
- STORE_TOLERANCE_TYPE
- UNI
- MULT_RUNS_PER_DAY_IND
- N
- PRIMARY_REPL_SUPPLIER
- 3
- INCLUDE_ADDITIONAL_DEMAND
- N
default
- ITEMRPK
- Repl Item Loc-003-EDGE
- LOCATIONRPK
- 5
- LOC_TYPER
- Repl I
- HI
- 14.0000
- TI
- 14.0000
- DEPT
- 1005
- CLASS
- 1105
- STATUS
- A
- INCR_PCT
- 14.0000
- LAST_ROQ
- 14.0000
- PHASE_ID
- 100005
- SUBCLASS
- 1115
- MAX_STOCK
- 14.0000
- MIN_STOCK
- 14.0000
- ROUND_LVL
- Repl I
- SEASON_ID
- 100005
- SOURCE_WH
- 9005
- STOCK_CAT
- Cross
- UNIT_COST
- 14.0000
- DEMO_STOCK
- 14.0000
- PRES_STOCK
- 14.0000
- ITEM_PARENT
- Repl Item Loc-003-EDGE
- REPL_METHOD
- Repl I
- OPTIMIZE_IND
- N
- REVIEW_CYCLE
- Repl I
- WH_LEAD_TIME
- 5
- ACTIVATE_DATE
- 2026-01-05
- MBR_ORDER_QTY
- 14.0000
- PCT_TOLERANCE
- 14.0000
- SERVICE_LEVEL
- 14.00
- LAST_UPDATE_ID
- BATCH_USER
- STORE_ORD_MULT
- used
- SUPP_LEAD_TIME
- 5
- SUPP_PACK_SIZE
- 14.0000
- TSF_PO_LINK_NO
- 6
- UNIT_TOLERANCE
- 14.0000
- CREATE_DATETIME
- 2026-01-05
- DEACTIVATE_DATE
- 2026-01-05
- INNER_PACK_SIZE
- 14.0000
- MAX_SCALE_VALUE
- 14.0000
- MAX_SUPPLY_DAYS
- 5
- MIN_SUPPLY_DAYS
- 5
- NON_SCALING_IND
- R
- PRIMARY_PACK_NO
- Repl Item Loc-003-EDGE
- REPL_ORDER_CTRL
- create
- INV_SELLING_DAYS
- 5
- ITEM_GRANDPARENT
- Repl Item Loc-003-EDGE
- LAST_REVIEW_DATE
- 2026-01-05
- NEXT_REVIEW_DATE
- 2026-01-05
- PICKUP_LEAD_TIME
- 5
- PRIMARY_PACK_QTY
- 14.0000
- TSF_ZERO_SOH_IND
- N
- ADD_LEAD_TIME_IND
- R
- LOST_SALES_FACTOR
- 14.00
- ORIGIN_COUNTRY_ID
- EDG
- ROUND_TO_CASE_PCT
- 14.0000
- STORE_USER_ACCESS
- APRV
- USE_TOLERANCE_IND
- R
- ADJ_SUPP_LEAD_TIME
- 5
- ITEM_SEASON_SEQ_NO
- 6
- LAST_DELIVERY_DATE
- 2026-01-05
- NEXT_DELIVERY_DATE
- 2026-01-05
- ROUND_TO_INNER_PCT
- 14.0000
- ROUND_TO_LAYER_PCT
- 14.0000
- SERVICE_LEVEL_TYPE
- Re
- TERMINAL_STOCK_QTY
- 14.0000
- ROUND_TO_PALLET_PCT
- 14.0000
- TIME_SUPPLY_HORIZON
- 5
- ADJ_PICKUP_LEAD_TIME
- 5
- LAST_UPDATE_DATETIME
- 2026-01-05
- REJECT_STORE_ORD_IND
- R
- STORE_TOLERANCE_TYPE
- PER
- MULT_RUNS_PER_DAY_IND
- N
- PRIMARY_REPL_SUPPLIER
- 5
- INCLUDE_ADDITIONAL_DEMAND
- N
Rule Validation Summary
- Source Rule Count
- 150
- Governed Rule Count
- 92