Store (Message Queue)
In ScopeTechnical: STORE_MFQUEUE | ID: OR-FND-STORE_MFQUEUE-STORE_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
- STORE_MFQUEUE
Field Definitions(5)
Rules & Considerations(16)
constraint
validation
Sample Load Data(4)
| _scenario | STORER | FAMILYR | SEQ_NORPK | MESSAGE_TYPER | DAY_NO | 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 | 1 | S | 1 | S | 2026-01-01 |
| default | 1003 | Store Mfqueue-002-ALT | 4 | Store Mfqueue-0 | 2 | 3 | 1000000003 | P | 3 | S | 2026-02-09 |
| default | 1005 | Store Mfqueue-003-EDGE | 6 | Store Mfqueue-0 | 3 | 5 | 1000000005 | A | 5 | S | 2026-03-12 |
Example values from field definitions
- STORER
- 1
- FAMILYR
- SAMPLE
- SEQ_NORPK
- 1
- MESSAGE_TYPER
- SAMPLE
- DAY_NO
- 1
- ADDR_KEY
- 1
- GROUP_ID
- 1
- PUB_STATUS
- S
- TRANSACTION_NUMBER
- 1
- CUSTOM_MESSAGE_TYPE
- S
- TRANSACTION_TIME_STAMP
- 2026-01-01
default
- STORER
- 1003
- FAMILYR
- Store Mfqueue-002-ALT
- SEQ_NORPK
- 4
- MESSAGE_TYPER
- Store Mfqueue-0
- DAY_NO
- 2
- ADDR_KEY
- 3
- GROUP_ID
- 1000000003
- PUB_STATUS
- P
- TRANSACTION_NUMBER
- 3
- CUSTOM_MESSAGE_TYPE
- S
- TRANSACTION_TIME_STAMP
- 2026-02-09
default
- STORER
- 1005
- FAMILYR
- Store Mfqueue-003-EDGE
- SEQ_NORPK
- 6
- MESSAGE_TYPER
- Store Mfqueue-0
- DAY_NO
- 3
- ADDR_KEY
- 5
- GROUP_ID
- 1000000005
- PUB_STATUS
- A
- TRANSACTION_NUMBER
- 5
- CUSTOM_MESSAGE_TYPE
- S
- TRANSACTION_TIME_STAMP
- 2026-03-12
Rule Validation Summary
- Source Rule Count
- 25
- Governed Rule Count
- 16