Items At Warehouse
In ScopeTechnical: WAREHOUSE_ITEM | ID: OR-STO-WAREHOUSE_ITEM-WAREHOUSE_ITEM
Stores items at warehouse.
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
- WAREHOUSE_ITEM
Field Definitions(5)
Rules & Considerations(19)
constraint
validation
Sample Load Data(4)
| _scenario | STATUSR | ITEM_IDRPK | WAREHOUSE_IDRPK | QUANTITY_TOTALR | QUANTITY_RESERVEDR | STANDARD_UOM | QUANTITY_IN_TRANSIT | QUANTITY_RESET_DATE | QUANTITY_UNAVAILABLE |
|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SA | SAMPLE | 1 | 1.0000 | 1.0000 | SAMP | 1.0000 | 2026-01-01 | 1.0000 |
| default | PE | ALT-WAREHOUSE_-002 | 1000000003 | 12.5000 | 12.5000 | Ware | 12.5000 | 2026-01-03 | 12.5000 |
| default | AC | EDGE-WAREHOUSE_-003 | 1000000005 | 14.0000 | 14.0000 | Ware | 14.0000 | 2026-01-05 | 14.0000 |
Example values from field definitions
- STATUSR
- SA
- ITEM_IDRPK
- SAMPLE
- WAREHOUSE_IDRPK
- 1
- QUANTITY_TOTALR
- 1.0000
- QUANTITY_RESERVEDR
- 1.0000
- STANDARD_UOM
- SAMP
- QUANTITY_IN_TRANSIT
- 1.0000
- QUANTITY_RESET_DATE
- 2026-01-01
- QUANTITY_UNAVAILABLE
- 1.0000
default
- STATUSR
- PE
- ITEM_IDRPK
- ALT-WAREHOUSE_-002
- WAREHOUSE_IDRPK
- 1000000003
- QUANTITY_TOTALR
- 12.5000
- QUANTITY_RESERVEDR
- 12.5000
- STANDARD_UOM
- Ware
- QUANTITY_IN_TRANSIT
- 12.5000
- QUANTITY_RESET_DATE
- 2026-01-03
- QUANTITY_UNAVAILABLE
- 12.5000
default
- STATUSR
- AC
- ITEM_IDRPK
- EDGE-WAREHOUSE_-003
- WAREHOUSE_IDRPK
- 1000000005
- QUANTITY_TOTALR
- 14.0000
- QUANTITY_RESERVEDR
- 14.0000
- STANDARD_UOM
- Ware
- QUANTITY_IN_TRANSIT
- 14.0000
- QUANTITY_RESET_DATE
- 2026-01-05
- QUANTITY_UNAVAILABLE
- 14.0000
Rule Validation Summary
- Source Rule Count
- 22
- Governed Rule Count
- 19