Replenishment Attr Upd History
In ScopeTechnical: REPL_ATTR_UPD_HIST | ID: OR-REPL-REPL_ATTR_UPD_HIST-REPLENISHMENT_ATTR_UPD_HISTORY
Stores data that is captured whenever a change occurs on the replenishment form. A new row would be added to this table everytime a new replenishment is defined or when...
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_ATTR_UPD_HIST
Field Definitions(5)
Rules & Considerations(59)
Sample Load Data(4)
| _scenario | REPL_ATTR_UPD_IDRPK | DEPT | ITEM | CLASS | INCR_PCT | LOCATION | LOC_TYPE | PHASE_ID | SUBCLASS | WEEK_NUM | MAX_STOCK | MIN_STOCK | SEASON_ID | SOURCE_WH | STOCK_CAT | DEMO_STOCK | PRES_STOCK | ITEM_PARENT | REPL_METHOD | OPTIMIZE_IND | REVIEW_CYCLE | WH_LEAD_TIME | ACTIVATE_DATE | PCT_TOLERANCE | SERVICE_LEVEL | DIFF_AGGREGATE | LAST_UPDATE_ID | UNIT_TOLERANCE | DEACTIVATE_DATE | 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 | PICKUP_LEAD_TIME | PRIMARY_PACK_QTY | SIZE_PROFILE_IND | STORE_ORDER_MULT | TSF_ZERO_SOH_IND | LOST_SALES_FACTOR | ORIGIN_COUNTRY_ID | STORE_USER_ACCESS | USE_TOLERANCE_IND | SERVICE_LEVEL_TYPE | TERMINAL_STOCK_QTY | TIME_SUPPLY_HORIZON | 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 | 1 | 1 | SAMPLE | 1 | 1.0000 | SAMPLE | SAMPLE | 1 | 1 | 1 | 1.0000 | 1.0000 | 1 | 1 | SAMPLE | 1.0000 | 1.0000 | SAMPLE | SAMPLE | S | SAMPLE | 1 | 2026-01-01 | 1.0000 | 1.00 | SAMPLE | SAMPLE | 1.0000 | 2026-01-01 | 1.0000 | 1 | 1 | S | SAMPLE | SAMPLE | 1 | SAMPLE | 2026-01-01 | 1 | 1.0000 | S | SAMPLE | S | 1.00 | SAM | SAMPLE | S | SA | 1.0000 | 1 | 2026-01-01 | S | SAMPLE | S | 1 | S |
| default | 1000000003 | 1003 | Repl Attr Upd Hist-002-AL | 1103 | 12.5000 | Repl Attr Upd Hist-0 | Repl A | 100003 | 1113 | 4 | 12.5000 | 12.5000 | 100003 | 9003 | Repl A | 12.5000 | 12.5000 | Repl Attr Upd Hist-002-AL | Repl A | R | Repl A | 3 | 2026-01-03 | 12.5000 | 12.50 | Repl Attr Upd Hist-002-ALT | MDM_USER | 12.5000 | 2026-01-03 | 12.5000 | 3 | 3 | R | Repl Attr Upd Hist-002-AL | Repl A | 3 | Repl Attr Upd Hist-002-AL | 2026-01-03 | 3 | 12.5000 | R | Repl A | N | 12.50 | ALT | REV | R | Re | 12.5000 | 3 | 2026-01-03 | R | UNI | N | 3 | N |
| default | 1000000005 | 1005 | Repl Attr Upd Hist-003-ED | 1105 | 14.0000 | Repl Attr Upd Hist-0 | Repl A | 100005 | 1115 | 6 | 14.0000 | 14.0000 | 100005 | 9005 | Repl A | 14.0000 | 14.0000 | Repl Attr Upd Hist-003-ED | Repl A | R | Repl A | 5 | 2026-01-05 | 14.0000 | 14.00 | Repl Attr Upd Hist-003-EDGE | BATCH_USER | 14.0000 | 2026-01-05 | 14.0000 | 5 | 5 | R | Repl Attr Upd Hist-003-ED | Repl A | 5 | Repl Attr Upd Hist-003-ED | 2026-01-05 | 5 | 14.0000 | R | Repl A | N | 14.00 | EDG | APRV | R | Re | 14.0000 | 5 | 2026-01-05 | R | PER | N | 5 | N |
Example values from field definitions
- REPL_ATTR_UPD_IDRPK
- 1
- DEPT
- 1
- ITEM
- SAMPLE
- CLASS
- 1
- INCR_PCT
- 1.0000
- LOCATION
- SAMPLE
- LOC_TYPE
- SAMPLE
- PHASE_ID
- 1
- SUBCLASS
- 1
- WEEK_NUM
- 1
- MAX_STOCK
- 1.0000
- MIN_STOCK
- 1.0000
- SEASON_ID
- 1
- SOURCE_WH
- 1
- STOCK_CAT
- SAMPLE
- 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
- PCT_TOLERANCE
- 1.0000
- SERVICE_LEVEL
- 1.00
- DIFF_AGGREGATE
- SAMPLE
- LAST_UPDATE_ID
- SAMPLE
- UNIT_TOLERANCE
- 1.0000
- DEACTIVATE_DATE
- 2026-01-01
- 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
- PICKUP_LEAD_TIME
- 1
- PRIMARY_PACK_QTY
- 1.0000
- SIZE_PROFILE_IND
- S
- STORE_ORDER_MULT
- SAMPLE
- TSF_ZERO_SOH_IND
- S
- LOST_SALES_FACTOR
- 1.00
- ORIGIN_COUNTRY_ID
- SAM
- STORE_USER_ACCESS
- SAMPLE
- USE_TOLERANCE_IND
- S
- SERVICE_LEVEL_TYPE
- SA
- TERMINAL_STOCK_QTY
- 1.0000
- TIME_SUPPLY_HORIZON
- 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
- REPL_ATTR_UPD_IDRPK
- 1000000003
- DEPT
- 1003
- ITEM
- Repl Attr Upd Hist-002-AL
- CLASS
- 1103
- INCR_PCT
- 12.5000
- LOCATION
- Repl Attr Upd Hist-0
- LOC_TYPE
- Repl A
- PHASE_ID
- 100003
- SUBCLASS
- 1113
- WEEK_NUM
- 4
- MAX_STOCK
- 12.5000
- MIN_STOCK
- 12.5000
- SEASON_ID
- 100003
- SOURCE_WH
- 9003
- STOCK_CAT
- Repl A
- DEMO_STOCK
- 12.5000
- PRES_STOCK
- 12.5000
- ITEM_PARENT
- Repl Attr Upd Hist-002-AL
- REPL_METHOD
- Repl A
- OPTIMIZE_IND
- R
- REVIEW_CYCLE
- Repl A
- WH_LEAD_TIME
- 3
- ACTIVATE_DATE
- 2026-01-03
- PCT_TOLERANCE
- 12.5000
- SERVICE_LEVEL
- 12.50
- DIFF_AGGREGATE
- Repl Attr Upd Hist-002-ALT
- LAST_UPDATE_ID
- MDM_USER
- UNIT_TOLERANCE
- 12.5000
- DEACTIVATE_DATE
- 2026-01-03
- MAX_SCALE_VALUE
- 12.5000
- MAX_SUPPLY_DAYS
- 3
- MIN_SUPPLY_DAYS
- 3
- NON_SCALING_IND
- R
- PRIMARY_PACK_NO
- Repl Attr Upd Hist-002-AL
- REPL_ORDER_CTRL
- Repl A
- INV_SELLING_DAYS
- 3
- ITEM_GRANDPARENT
- Repl Attr Upd Hist-002-AL
- LAST_REVIEW_DATE
- 2026-01-03
- PICKUP_LEAD_TIME
- 3
- PRIMARY_PACK_QTY
- 12.5000
- SIZE_PROFILE_IND
- R
- STORE_ORDER_MULT
- Repl A
- TSF_ZERO_SOH_IND
- N
- LOST_SALES_FACTOR
- 12.50
- ORIGIN_COUNTRY_ID
- ALT
- STORE_USER_ACCESS
- REV
- USE_TOLERANCE_IND
- R
- SERVICE_LEVEL_TYPE
- Re
- TERMINAL_STOCK_QTY
- 12.5000
- TIME_SUPPLY_HORIZON
- 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
- REPL_ATTR_UPD_IDRPK
- 1000000005
- DEPT
- 1005
- ITEM
- Repl Attr Upd Hist-003-ED
- CLASS
- 1105
- INCR_PCT
- 14.0000
- LOCATION
- Repl Attr Upd Hist-0
- LOC_TYPE
- Repl A
- PHASE_ID
- 100005
- SUBCLASS
- 1115
- WEEK_NUM
- 6
- MAX_STOCK
- 14.0000
- MIN_STOCK
- 14.0000
- SEASON_ID
- 100005
- SOURCE_WH
- 9005
- STOCK_CAT
- Repl A
- DEMO_STOCK
- 14.0000
- PRES_STOCK
- 14.0000
- ITEM_PARENT
- Repl Attr Upd Hist-003-ED
- REPL_METHOD
- Repl A
- OPTIMIZE_IND
- R
- REVIEW_CYCLE
- Repl A
- WH_LEAD_TIME
- 5
- ACTIVATE_DATE
- 2026-01-05
- PCT_TOLERANCE
- 14.0000
- SERVICE_LEVEL
- 14.00
- DIFF_AGGREGATE
- Repl Attr Upd Hist-003-EDGE
- LAST_UPDATE_ID
- BATCH_USER
- UNIT_TOLERANCE
- 14.0000
- DEACTIVATE_DATE
- 2026-01-05
- MAX_SCALE_VALUE
- 14.0000
- MAX_SUPPLY_DAYS
- 5
- MIN_SUPPLY_DAYS
- 5
- NON_SCALING_IND
- R
- PRIMARY_PACK_NO
- Repl Attr Upd Hist-003-ED
- REPL_ORDER_CTRL
- Repl A
- INV_SELLING_DAYS
- 5
- ITEM_GRANDPARENT
- Repl Attr Upd Hist-003-ED
- LAST_REVIEW_DATE
- 2026-01-05
- PICKUP_LEAD_TIME
- 5
- PRIMARY_PACK_QTY
- 14.0000
- SIZE_PROFILE_IND
- R
- STORE_ORDER_MULT
- Repl A
- TSF_ZERO_SOH_IND
- N
- LOST_SALES_FACTOR
- 14.00
- ORIGIN_COUNTRY_ID
- EDG
- STORE_USER_ACCESS
- APRV
- USE_TOLERANCE_IND
- R
- SERVICE_LEVEL_TYPE
- Re
- TERMINAL_STOCK_QTY
- 14.0000
- TIME_SUPPLY_HORIZON
- 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
- 75
- Governed Rule Count
- 59