Mra Records For An Item/Location Combination
In ScopeTechnical: MASTER_REPL_ATTR | ID: OR-REPL-MASTER_REPL_ATTR-MASTER_REPLENISHMENT_ATTR
Table for Master Replenishment Attribute (MRA) records. This table holds MRA records for an item/location combination.
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
- MASTER_REPL_ATTR
Field Definitions(5)
Rules & Considerations(100)
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 | FRIDAY_IND | MONDAY_IND | PRES_STOCK | SUNDAY_IND | ITEM_PARENT | REPL_METHOD | TUESDAY_IND | OPTIMIZE_IND | REVIEW_CYCLE | SATURDAY_IND | THURSDAY_IND | WH_LEAD_TIME | MBR_ORDER_QTY | PCT_TOLERANCE | SERVICE_LEVEL | WEDNESDAY_IND | LAST_UPDATE_ID | STORE_ORD_MULT | SUPP_LEAD_TIME | SUPP_PACK_SIZE | TSF_PO_LINK_NO | UNIT_TOLERANCE | CREATE_DATETIME | INNER_PACK_SIZE | MAX_SCALE_VALUE | MAX_SUPPLY_DAYS | MIN_SUPPLY_DAYS | NON_SCALING_IND | PRIMARY_PACK_NO | REPL_ORDER_CTRL | UPDATE_DAYS_IND | INV_SELLING_DAYS | ITEM_GRANDPARENT | LAST_REVIEW_DATE | NEXT_REVIEW_DATE | PICKUP_LEAD_TIME | PRIMARY_PACK_QTY | TSF_ZERO_SOH_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 | S | S | 1.0000 | S | SAMPLE | SAMPLE | S | S | SAMPLE | S | S | 1 | 1.0000 | 1.0000 | 1.00 | S | SAMPLE | SAMPLE | 1 | 1.0000 | 1 | 1.0000 | 2026-01-01 | 1.0000 | 1.0000 | 1 | 1 | S | SAMPLE | SAMPLE | S | 1 | SAMPLE | 2026-01-01 | 2026-01-01 | 1 | 1.0000 | 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 | Master Repl Attr-002-ALT | 3 | Master | 12.5000 | 12.5000 | 1003 | 1103 | S | 12.5000 | 12.5000 | 100003 | 1113 | 12.5000 | 12.5000 | Master | 100003 | 9003 | L | 12.5000 | 12.5000 | N | N | 12.5000 | N | Master Repl Attr-002-ALT | Master | N | N | Master | N | N | 3 | 12.5000 | 12.5000 | 12.50 | N | MDM_USER | used | 3 | 12.5000 | 4 | 12.5000 | 2026-01-03 | 12.5000 | 12.5000 | 3 | 3 | N | Master Repl Attr-002-ALT | Semi | N | 3 | Master Repl Attr-002-ALT | 2026-01-03 | 2026-01-03 | 3 | 12.5000 | N | 12.50 | ALT | 12.5000 | REV | N | 3 | 4 | 2026-01-03 | 2026-01-03 | 12.5000 | 12.5000 | Ma | 12.5000 | 12.5000 | 3 | 3 | 2026-01-03 | N | UNI | N | 3 | N |
| default | Master Repl Attr-003-EDGE | 5 | Master | 14.0000 | 14.0000 | 1005 | 1105 | A | 14.0000 | 14.0000 | 100005 | 1115 | 14.0000 | 14.0000 | Master | 100005 | 9005 | Cross | 14.0000 | 14.0000 | Y | Y | 14.0000 | Y | Master Repl Attr-003-EDGE | Master | Y | N | Master | Y | Y | 5 | 14.0000 | 14.0000 | 14.00 | Y | BATCH_USER | used | 5 | 14.0000 | 6 | 14.0000 | 2026-01-05 | 14.0000 | 14.0000 | 5 | 5 | N | Master Repl Attr-003-EDGE | create | Y | 5 | Master Repl Attr-003-EDGE | 2026-01-05 | 2026-01-05 | 5 | 14.0000 | N | 14.00 | EDG | 14.0000 | APRV | N | 5 | 6 | 2026-01-05 | 2026-01-05 | 14.0000 | 14.0000 | Ma | 14.0000 | 14.0000 | 5 | 5 | 2026-01-05 | N | 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
- FRIDAY_IND
- S
- MONDAY_IND
- S
- PRES_STOCK
- 1.0000
- SUNDAY_IND
- S
- ITEM_PARENT
- SAMPLE
- REPL_METHOD
- SAMPLE
- TUESDAY_IND
- S
- OPTIMIZE_IND
- S
- REVIEW_CYCLE
- SAMPLE
- SATURDAY_IND
- S
- THURSDAY_IND
- S
- WH_LEAD_TIME
- 1
- MBR_ORDER_QTY
- 1.0000
- PCT_TOLERANCE
- 1.0000
- SERVICE_LEVEL
- 1.00
- WEDNESDAY_IND
- S
- 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
- 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
- UPDATE_DAYS_IND
- S
- 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
- 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
- Master Repl Attr-002-ALT
- LOCATIONRPK
- 3
- LOC_TYPER
- Master
- 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
- Master
- SEASON_ID
- 100003
- SOURCE_WH
- 9003
- STOCK_CAT
- L
- UNIT_COST
- 12.5000
- DEMO_STOCK
- 12.5000
- FRIDAY_IND
- N
- MONDAY_IND
- N
- PRES_STOCK
- 12.5000
- SUNDAY_IND
- N
- ITEM_PARENT
- Master Repl Attr-002-ALT
- REPL_METHOD
- Master
- TUESDAY_IND
- N
- OPTIMIZE_IND
- N
- REVIEW_CYCLE
- Master
- SATURDAY_IND
- N
- THURSDAY_IND
- N
- WH_LEAD_TIME
- 3
- MBR_ORDER_QTY
- 12.5000
- PCT_TOLERANCE
- 12.5000
- SERVICE_LEVEL
- 12.50
- WEDNESDAY_IND
- N
- 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
- INNER_PACK_SIZE
- 12.5000
- MAX_SCALE_VALUE
- 12.5000
- MAX_SUPPLY_DAYS
- 3
- MIN_SUPPLY_DAYS
- 3
- NON_SCALING_IND
- N
- PRIMARY_PACK_NO
- Master Repl Attr-002-ALT
- REPL_ORDER_CTRL
- Semi
- UPDATE_DAYS_IND
- N
- INV_SELLING_DAYS
- 3
- ITEM_GRANDPARENT
- Master Repl Attr-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
- LOST_SALES_FACTOR
- 12.50
- ORIGIN_COUNTRY_ID
- ALT
- ROUND_TO_CASE_PCT
- 12.5000
- STORE_USER_ACCESS
- REV
- USE_TOLERANCE_IND
- N
- 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
- Ma
- 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
- N
- STORE_TOLERANCE_TYPE
- UNI
- MULT_RUNS_PER_DAY_IND
- N
- PRIMARY_REPL_SUPPLIER
- 3
- INCLUDE_ADDITIONAL_DEMAND
- N
default
- ITEMRPK
- Master Repl Attr-003-EDGE
- LOCATIONRPK
- 5
- LOC_TYPER
- Master
- 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
- Master
- SEASON_ID
- 100005
- SOURCE_WH
- 9005
- STOCK_CAT
- Cross
- UNIT_COST
- 14.0000
- DEMO_STOCK
- 14.0000
- FRIDAY_IND
- Y
- MONDAY_IND
- Y
- PRES_STOCK
- 14.0000
- SUNDAY_IND
- Y
- ITEM_PARENT
- Master Repl Attr-003-EDGE
- REPL_METHOD
- Master
- TUESDAY_IND
- Y
- OPTIMIZE_IND
- N
- REVIEW_CYCLE
- Master
- SATURDAY_IND
- Y
- THURSDAY_IND
- Y
- WH_LEAD_TIME
- 5
- MBR_ORDER_QTY
- 14.0000
- PCT_TOLERANCE
- 14.0000
- SERVICE_LEVEL
- 14.00
- WEDNESDAY_IND
- Y
- 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
- INNER_PACK_SIZE
- 14.0000
- MAX_SCALE_VALUE
- 14.0000
- MAX_SUPPLY_DAYS
- 5
- MIN_SUPPLY_DAYS
- 5
- NON_SCALING_IND
- N
- PRIMARY_PACK_NO
- Master Repl Attr-003-EDGE
- REPL_ORDER_CTRL
- create
- UPDATE_DAYS_IND
- Y
- INV_SELLING_DAYS
- 5
- ITEM_GRANDPARENT
- Master Repl Attr-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
- LOST_SALES_FACTOR
- 14.00
- ORIGIN_COUNTRY_ID
- EDG
- ROUND_TO_CASE_PCT
- 14.0000
- STORE_USER_ACCESS
- APRV
- USE_TOLERANCE_IND
- N
- 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
- Ma
- 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
- N
- STORE_TOLERANCE_TYPE
- PER
- MULT_RUNS_PER_DAY_IND
- N
- PRIMARY_REPL_SUPPLIER
- 5
- INCLUDE_ADDITIONAL_DEMAND
- N
Rule Validation Summary
- Source Rule Count
- 100
- Governed Rule Count
- 100