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(80)
Rules & Considerations(99)
validation
constraint
Sample Load Data(4)
| _scenario | ITEMRPK | LOCATIONR | LOC_TYPER | STOCK_CATR | FRIDAY_INDR | MONDAY_INDR | SUNDAY_INDR | REPL_METHODR | TUESDAY_INDR | OPTIMIZE_INDR | REVIEW_CYCLER | SATURDAY_INDR | THURSDAY_INDR | WEDNESDAY_INDR | LAST_UPDATE_IDR | CREATE_DATETIMER | NON_SCALING_INDR | REPL_ORDER_CTRLR | UPDATE_DAYS_INDR | 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 | SOURCE_WH | 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 | 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 | 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | 1 | SAMPLE | SAMPLE | S | S | S | SAMPLE | S | S | SAMPLE | S | S | S | SAMPLE | 2026-01-01 | S | SAMPLE | S | S | S | 2026-01-01 | S | 1.0000 | 1.0000 | 1 | 1 | S | 1.0000 | 1.0000 | 1 | 1 | 1.0000 | 1.0000 | SAMPLE | 1 | 1 | 1.0000 | 1.0000 | 1.0000 | SAMPLE | 1 | 1.0000 | 1.0000 | 1.00 | SAMPLE | 1 | 1.0000 | 1 | 1.0000 | 1.0000 | 1.0000 | 1 | 1 | SAMPLE | 1 | SAMPLE | 2026-01-01 | 2026-01-01 | 1 | 1.0000 | 1.00 | SAM | 1.0000 | SAMPLE | 1 | 1 | 2026-01-01 | 2026-01-01 | 1.0000 | 1.0000 | SA | 1.0000 | 1.0000 | 1 | 1 | S | SAMPLE | 1 | S |
Example values from field definitions
- ITEMRPK
- SAMPLE
- LOCATIONR
- 1
- LOC_TYPER
- SAMPLE
- STOCK_CATR
- SAMPLE
- FRIDAY_INDR
- S
- MONDAY_INDR
- S
- SUNDAY_INDR
- S
- REPL_METHODR
- SAMPLE
- TUESDAY_INDR
- S
- OPTIMIZE_INDR
- S
- REVIEW_CYCLER
- SAMPLE
- SATURDAY_INDR
- S
- THURSDAY_INDR
- S
- WEDNESDAY_INDR
- S
- LAST_UPDATE_IDR
- SAMPLE
- CREATE_DATETIMER
- 2026-01-01
- NON_SCALING_INDR
- S
- REPL_ORDER_CTRLR
- SAMPLE
- UPDATE_DAYS_INDR
- S
- TSF_ZERO_SOH_INDR
- S
- USE_TOLERANCE_INDR
- S
- LAST_UPDATE_DATETIMER
- 2026-01-01
- MULT_RUNS_PER_DAY_INDR
- S
- 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
- UNIT_COST
- 1.0000
- DEMO_STOCK
- 1.0000
- PRES_STOCK
- 1.0000
- ITEM_PARENT
- SAMPLE
- WH_LEAD_TIME
- 1
- MBR_ORDER_QTY
- 1.0000
- PCT_TOLERANCE
- 1.0000
- SERVICE_LEVEL
- 1.00
- STORE_ORD_MULT
- SAMPLE
- SUPP_LEAD_TIME
- 1
- SUPP_PACK_SIZE
- 1.0000
- TSF_PO_LINK_NO
- 1
- UNIT_TOLERANCE
- 1.0000
- INNER_PACK_SIZE
- 1.0000
- MAX_SCALE_VALUE
- 1.0000
- MAX_SUPPLY_DAYS
- 1
- MIN_SUPPLY_DAYS
- 1
- PRIMARY_PACK_NO
- 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
- LOST_SALES_FACTOR
- 1.00
- ORIGIN_COUNTRY_ID
- SAM
- ROUND_TO_CASE_PCT
- 1.0000
- STORE_USER_ACCESS
- SAMPLE
- 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
- REJECT_STORE_ORD_IND
- S
- STORE_TOLERANCE_TYPE
- SAMPLE
- PRIMARY_REPL_SUPPLIER
- 1
- INCLUDE_ADDITIONAL_DEMAND
- S
Rule Validation Summary
- Source Rule Count
- 99
- Governed Rule Count
- 99