Repl Item Loc
In ScopeTechnical: REPL_ITEM_LOC | ID: OR-MFCS-REPL_ITEM_LOC
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
Target Structure
- Load Approach
- Table
- Target Objects
- REPL_ITEM_LOC
Field Definitions(75)
Rules & Considerations(181)
Sample Load Data(4)
| _scenario | ITEMRPK | LOCATIONR | LOC_TYPER | SOURCE_WHPK | STOCK_CATR | REPL_METHODR | OPTIMIZE_INDR | REVIEW_CYCLER | ACTIVATE_DATER | LAST_UPDATE_IDR | CREATE_DATETIMER | NON_SCALING_INDR | REPL_ORDER_CTRLR | TSF_ZERO_SOH_INDR | USE_TOLERANCE_INDR | LAST_UPDATE_DATETIMER | MULT_RUNS_PER_DAY_INDR | HI | TI | DEPT | CLASS | STATUS | INCR_PCT | LAST_ROQ | PHASE_ID | SUBCLASS | MAX_STOCK | MIN_STOCK | ROUND_LVL | SEASON_ID | UNIT_COST | DEMO_STOCK | PRES_STOCK | ITEM_PARENT | WH_LEAD_TIME | MBR_ORDER_QTY | PCT_TOLERANCE | SERVICE_LEVEL | STORE_ORD_MULT | SUPP_LEAD_TIME | SUPP_PACK_SIZE | TSF_PO_LINK_NO | UNIT_TOLERANCE | DEACTIVATE_DATE | INNER_PACK_SIZE | MAX_SCALE_VALUE | MAX_SUPPLY_DAYS | MIN_SUPPLY_DAYS | PRIMARY_PACK_NO | INV_SELLING_DAYS | ITEM_GRANDPARENT | LAST_REVIEW_DATE | NEXT_REVIEW_DATE | PICKUP_LEAD_TIME | PRIMARY_PACK_QTY | ADD_LEAD_TIME_IND | LOST_SALES_FACTOR | ORIGIN_COUNTRY_ID | ROUND_TO_CASE_PCT | STORE_USER_ACCESS | 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 | REJECT_STORE_ORD_IND | STORE_TOLERANCE_TYPE | PRIMARY_REPL_SUPPLIER | INCLUDE_ADDITIONAL_DEMAND |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | Repl Item Loc-001 | 1 | Repl Item Loc-001 | 9001 | Cross | Repl Item Loc-001 | N | Repl Item Loc-001 | 2026-01-01 | MIG_USER | 2026-01-01 | Repl Item Loc-001 | table | N | Repl Item Loc-001 | 2026-01-01 | N | 11.0000 | 11.0000 | 1001 | 1101 | W | 11.0000 | 11.0000 | 100001 | 1111 | 11.0000 | 11.0000 | Repl Item Loc-001 | 100001 | 11.0000 | 11.0000 | 11.0000 | Repl Item Loc-001 | 0001 | 11.0000 | 11.0000 | 11.00 | used | 0001 | 11.0000 | 2 | 11.0000 | 2026-01-01 | 11.0000 | 11.0000 | 001 | 001 | Repl Item Loc-001 | 001 | Repl Item Loc-001 | 2026-01-01 | 2026-01-01 | 0001 | 11.0000 | Repl Item Loc-001 | 11.00 | STD-REPL_ITEM-001 | 11.0000 | RES | 0001 | 0002 | 2026-01-01 | 2026-01-01 | 11.0000 | 11.0000 | Repl Item Loc-001 | 11.0000 | 11.0000 | 001 | 0001 | Repl Item Loc-001 | PER | 1 | N |
default
- ITEMRPK
- Repl Item Loc-001
- LOCATIONR
- 1
- LOC_TYPER
- Repl Item Loc-001
- SOURCE_WHPK
- 9001
- STOCK_CATR
- Cross
- REPL_METHODR
- Repl Item Loc-001
- OPTIMIZE_INDR
- N
- REVIEW_CYCLER
- Repl Item Loc-001
- ACTIVATE_DATER
- 2026-01-01
- LAST_UPDATE_IDR
- MIG_USER
- CREATE_DATETIMER
- 2026-01-01
- NON_SCALING_INDR
- Repl Item Loc-001
- REPL_ORDER_CTRLR
- table
- TSF_ZERO_SOH_INDR
- N
- USE_TOLERANCE_INDR
- Repl Item Loc-001
- LAST_UPDATE_DATETIMER
- 2026-01-01
- MULT_RUNS_PER_DAY_INDR
- N
- HI
- 11.0000
- TI
- 11.0000
- DEPT
- 1001
- CLASS
- 1101
- STATUS
- W
- INCR_PCT
- 11.0000
- LAST_ROQ
- 11.0000
- PHASE_ID
- 100001
- SUBCLASS
- 1111
- MAX_STOCK
- 11.0000
- MIN_STOCK
- 11.0000
- ROUND_LVL
- Repl Item Loc-001
- SEASON_ID
- 100001
- UNIT_COST
- 11.0000
- DEMO_STOCK
- 11.0000
- PRES_STOCK
- 11.0000
- ITEM_PARENT
- Repl Item Loc-001
- WH_LEAD_TIME
- 0001
- MBR_ORDER_QTY
- 11.0000
- PCT_TOLERANCE
- 11.0000
- SERVICE_LEVEL
- 11.00
- STORE_ORD_MULT
- used
- SUPP_LEAD_TIME
- 0001
- SUPP_PACK_SIZE
- 11.0000
- TSF_PO_LINK_NO
- 2
- UNIT_TOLERANCE
- 11.0000
- DEACTIVATE_DATE
- 2026-01-01
- INNER_PACK_SIZE
- 11.0000
- MAX_SCALE_VALUE
- 11.0000
- MAX_SUPPLY_DAYS
- 001
- MIN_SUPPLY_DAYS
- 001
- PRIMARY_PACK_NO
- Repl Item Loc-001
- INV_SELLING_DAYS
- 001
- ITEM_GRANDPARENT
- Repl Item Loc-001
- LAST_REVIEW_DATE
- 2026-01-01
- NEXT_REVIEW_DATE
- 2026-01-01
- PICKUP_LEAD_TIME
- 0001
- PRIMARY_PACK_QTY
- 11.0000
- ADD_LEAD_TIME_IND
- Repl Item Loc-001
- LOST_SALES_FACTOR
- 11.00
- ORIGIN_COUNTRY_ID
- STD-REPL_ITEM-001
- ROUND_TO_CASE_PCT
- 11.0000
- STORE_USER_ACCESS
- RES
- ADJ_SUPP_LEAD_TIME
- 0001
- ITEM_SEASON_SEQ_NO
- 0002
- LAST_DELIVERY_DATE
- 2026-01-01
- NEXT_DELIVERY_DATE
- 2026-01-01
- ROUND_TO_INNER_PCT
- 11.0000
- ROUND_TO_LAYER_PCT
- 11.0000
- SERVICE_LEVEL_TYPE
- Repl Item Loc-001
- TERMINAL_STOCK_QTY
- 11.0000
- ROUND_TO_PALLET_PCT
- 11.0000
- TIME_SUPPLY_HORIZON
- 001
- ADJ_PICKUP_LEAD_TIME
- 0001
- REJECT_STORE_ORD_IND
- Repl Item Loc-001
- STORE_TOLERANCE_TYPE
- PER
- PRIMARY_REPL_SUPPLIER
- 1
- INCLUDE_ADDITIONAL_DEMAND
- N