Shelf Replenish
In ScopeTechnical: SHELF_REPLENISH | ID: OR-STO-SHELF_REPLENISH-SHELF_REPLENISH
this table will contain shelf replenishment record.
See how this object fits into Store Operations
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
- SHELF_REPLENISH
Field Definitions(5)
Rules & Considerations(29)
constraint
validation
Sample Load Data(4)
| _scenario | IDRPK | TYPER | STATUSR | STORE_IDR | CLASS_ID | USER_NAME | STATUS_DATE | SUBCLASS_ID | DEPARTMENT_ID | TRAN_EVENT_ID | AMOUNT_TO_PICK | REPLENISH_MODE | CREATE_DATETIME | PRODUCT_GROUP_ID | REPLENISH_GAP_ID | UNIT_OF_MEASURE_TYPE | TRAN_EVENT_DESCRIPTION |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | 1 | 1 | 1 | SAMPLE | 2026-01-01 | 1 | 1 | 1 | 1.0000 | 1 | 2026-01-01 | 1 | 1 | 1 | SAMPLE |
| default | 3 | 1 | 1 | 1000000003 | 1000000003 | Shelf Replenish Secondary | 2026-01-03 | 1000000003 | 1000000003 | 1000000003 | 12.5000 | 1 | 2026-01-03 | 1000000003 | 1000000003 | 2 | Shelf Replenish: Alternate source profile |
| default | 5 | 2 | 2 | 1000000005 | 1000000005 | Shelf Replenish Core | 2026-01-05 | 1000000005 | 1000000005 | 1000000005 | 14.0000 | 0 | 2026-01-05 | 1000000005 | 1000000005 | 3 | — |
Example values from field definitions
- IDRPK
- 1
- TYPER
- 1
- STATUSR
- 1
- STORE_IDR
- 1
- CLASS_ID
- 1
- USER_NAME
- SAMPLE
- STATUS_DATE
- 2026-01-01
- SUBCLASS_ID
- 1
- DEPARTMENT_ID
- 1
- TRAN_EVENT_ID
- 1
- AMOUNT_TO_PICK
- 1.0000
- REPLENISH_MODE
- 1
- CREATE_DATETIME
- 2026-01-01
- PRODUCT_GROUP_ID
- 1
- REPLENISH_GAP_ID
- 1
- UNIT_OF_MEASURE_TYPE
- 1
- TRAN_EVENT_DESCRIPTION
- SAMPLE
default
- IDRPK
- 3
- TYPER
- 1
- STATUSR
- 1
- STORE_IDR
- 1000000003
- CLASS_ID
- 1000000003
- USER_NAME
- Shelf Replenish Secondary
- STATUS_DATE
- 2026-01-03
- SUBCLASS_ID
- 1000000003
- DEPARTMENT_ID
- 1000000003
- TRAN_EVENT_ID
- 1000000003
- AMOUNT_TO_PICK
- 12.5000
- REPLENISH_MODE
- 1
- CREATE_DATETIME
- 2026-01-03
- PRODUCT_GROUP_ID
- 1000000003
- REPLENISH_GAP_ID
- 1000000003
- UNIT_OF_MEASURE_TYPE
- 2
- TRAN_EVENT_DESCRIPTION
- Shelf Replenish: Alternate source profile
default
- IDRPK
- 5
- TYPER
- 2
- STATUSR
- 2
- STORE_IDR
- 1000000005
- CLASS_ID
- 1000000005
- USER_NAME
- Shelf Replenish Core
- STATUS_DATE
- 2026-01-05
- SUBCLASS_ID
- 1000000005
- DEPARTMENT_ID
- 1000000005
- TRAN_EVENT_ID
- 1000000005
- AMOUNT_TO_PICK
- 14.0000
- REPLENISH_MODE
- 0
- CREATE_DATETIME
- 2026-01-05
- PRODUCT_GROUP_ID
- 1000000005
- REPLENISH_GAP_ID
- 1000000005
- UNIT_OF_MEASURE_TYPE
- 3
- TRAN_EVENT_DESCRIPTION
- —
Rule Validation Summary
- Source Rule Count
- 43
- Governed Rule Count
- 29