Warehouse (Message Queue)
In ScopeTechnical: WH_MFQUEUE | ID: OR-FND-WH_MFQUEUE-WAREHOUSE_MESSAGE_QUEUE
This table tracks changes in RMS that need to be published to the RIB. It is populated by calls to ADDTOQ.
See how this object fits into Foundation Data
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
- WH_MFQUEUE
Field Definitions(5)
Rules & Considerations(15)
constraint
validation
Sample Load Data(4)
| _scenario | WHR | FAMILYR | SEQ_NORPK | MESSAGE_TYPER | ADDR_KEY | GROUP_ID | PUB_STATUS | TRANSACTION_NUMBER | CUSTOM_MESSAGE_TYPE | TRANSACTION_TIME_STAMP |
|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | 1 | SAMPLE | 1 | 1 | S | 1 | S | 2026-01-01 |
| default | 9003 | Wh Mfqueue-002-ALT | 4 | Wh Mfqueue-002- | 3 | 1000000003 | P | 3 | W | 2026-02-09 |
| default | 9005 | Wh Mfqueue-003-EDGE | 6 | Wh Mfqueue-003- | 5 | 1000000005 | A | 5 | W | 2026-03-12 |
Example values from field definitions
- WHR
- 1
- FAMILYR
- SAMPLE
- SEQ_NORPK
- 1
- MESSAGE_TYPER
- SAMPLE
- ADDR_KEY
- 1
- GROUP_ID
- 1
- PUB_STATUS
- S
- TRANSACTION_NUMBER
- 1
- CUSTOM_MESSAGE_TYPE
- S
- TRANSACTION_TIME_STAMP
- 2026-01-01
default
- WHR
- 9003
- FAMILYR
- Wh Mfqueue-002-ALT
- SEQ_NORPK
- 4
- MESSAGE_TYPER
- Wh Mfqueue-002-
- ADDR_KEY
- 3
- GROUP_ID
- 1000000003
- PUB_STATUS
- P
- TRANSACTION_NUMBER
- 3
- CUSTOM_MESSAGE_TYPE
- W
- TRANSACTION_TIME_STAMP
- 2026-02-09
default
- WHR
- 9005
- FAMILYR
- Wh Mfqueue-003-EDGE
- SEQ_NORPK
- 6
- MESSAGE_TYPER
- Wh Mfqueue-003-
- ADDR_KEY
- 5
- GROUP_ID
- 1000000005
- PUB_STATUS
- A
- TRANSACTION_NUMBER
- 5
- CUSTOM_MESSAGE_TYPE
- W
- TRANSACTION_TIME_STAMP
- 2026-03-12
Rule Validation Summary
- Source Rule Count
- 23
- Governed Rule Count
- 15