Item Location SOH (Message Queue)
In ScopeTechnical: ITEM_LOC_SOH_MFQUEUE | ID: OR-INV-ITEM_LOC_SOH_MFQUEUE-ITEM_LOCATION_SOH_MESSAGE_QUEUE
This is a staging table for Item Location SOH messages. It contains snapshots of columns on the item_loc_soh table.
See how this object fits into Inventory Management
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
- ITEM_LOC_SOH_MFQUEUE
Field Definitions(10)
Rules & Considerations(18)
validation
constraint
Sample Load Data(4)
| _scenario | LOCR | ITEMR | FAMILYR | SEQ_NOR | LOC_TYPER | THREAD_NOR | PUB_STATUSR | MESSAGE_TYPER | AVAILABLE_TO_SELLR | TRANSACTION_TIME_STAMP |
|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | SAMPLE | 1 | S | 1 | S | SAMPLE | 1.0000 | 2026-01-01 |
Example values from field definitions
- LOCR
- 1
- ITEMR
- SAMPLE
- FAMILYR
- SAMPLE
- SEQ_NOR
- 1
- LOC_TYPER
- S
- THREAD_NOR
- 1
- PUB_STATUSR
- S
- MESSAGE_TYPER
- SAMPLE
- AVAILABLE_TO_SELLR
- 1.0000
- TRANSACTION_TIME_STAMP
- 2026-01-01
Rule Validation Summary
- Source Rule Count
- 44
- Governed Rule Count
- 18