Item (Message Queue)
In ScopeTechnical: ITEM_MFQUEUE | ID: OR-ITM-ITEM_MFQUEUE-ITEM_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 Item 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_MFQUEUE
Field Definitions(5)
Rules & Considerations(36)
validation
constraint
Sample Load Data(4)
| _scenario | ITEMR | SEQ_NORPK | UOM | FAMILY | UDA_ID | GROUP_ID | PHASE_ID | REF_ITEM | SUPPLIER | UDA_DATE | UDA_TEXT | VAT_TYPE | PACK_COMP | SEASON_ID | THREAD_NO | UDA_VALUE | COUNTRY_ID | DIM_OBJECT | IMAGE_NAME | PUB_STATUS | VAT_REGION | ACTIVE_DATE | APPROVE_IND | MESSAGE_TYPE | RELATED_ITEM | TICKET_TYPE_ID | RELATIONSHIP_ID | ITEM_SEASON_SEQ_NO | TRANSACTION_NUMBER | CUSTOM_MESSAGE_TYPE | TRANSACTION_TIME_STAMP |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | 1 | SAMP | SAMPLE | 1 | 1 | 1 | SAMPLE | 1 | 2026-01-01 | SAMPLE | S | SAMPLE | 1 | 1 | 1 | SAM | SAMPLE | SAMPLE | S | 1 | 2026-01-01 | S | SAMPLE | SAMPLE | SAMP | 1 | 1 | 1 | S | 2026-01-01 |
| default | Item Mfqueue-002-ALT | 4 | Item | Item Mfqueue-002-ALT | 100003 | 1000000003 | 100003 | Item Mfqueue-002-ALT | 3 | 2026-01-03 | Item Mfqueue-002-ALT | I | Item Mfqueue-002-ALT | 100003 | 4 | 3 | ALT | Item M | Item Mfqueue Secondary | P | 203 | 2026-01-03 | N | Item Mfqueue-00 | Item Mfqueue-002-ALT | ALT- | 1000000003 | 4 | 3 | I | 2026-02-09 |
| default | Item Mfqueue-003-EDGE | 6 | Item | Item Mfqueue-003-EDGE | 100005 | 1000000005 | 100005 | Item Mfqueue-003-EDGE | 5 | 2026-01-05 | Item Mfqueue-003-EDGE | I | Item Mfqueue-003-EDGE | 100005 | 6 | 5 | EDG | Item M | Item Mfqueue Core | A | 205 | 2026-01-05 | N | Item Mfqueue-00 | Item Mfqueue-003-EDGE | EDGE | 1000000005 | 6 | 5 | I | 2026-03-12 |
Example values from field definitions
- ITEMR
- SAMPLE
- SEQ_NORPK
- 1
- UOM
- SAMP
- FAMILY
- SAMPLE
- UDA_ID
- 1
- GROUP_ID
- 1
- PHASE_ID
- 1
- REF_ITEM
- SAMPLE
- SUPPLIER
- 1
- UDA_DATE
- 2026-01-01
- UDA_TEXT
- SAMPLE
- VAT_TYPE
- S
- PACK_COMP
- SAMPLE
- SEASON_ID
- 1
- THREAD_NO
- 1
- UDA_VALUE
- 1
- COUNTRY_ID
- SAM
- DIM_OBJECT
- SAMPLE
- IMAGE_NAME
- SAMPLE
- PUB_STATUS
- S
- VAT_REGION
- 1
- ACTIVE_DATE
- 2026-01-01
- APPROVE_IND
- S
- MESSAGE_TYPE
- SAMPLE
- RELATED_ITEM
- SAMPLE
- TICKET_TYPE_ID
- SAMP
- RELATIONSHIP_ID
- 1
- ITEM_SEASON_SEQ_NO
- 1
- TRANSACTION_NUMBER
- 1
- CUSTOM_MESSAGE_TYPE
- S
- TRANSACTION_TIME_STAMP
- 2026-01-01
default
- ITEMR
- Item Mfqueue-002-ALT
- SEQ_NORPK
- 4
- UOM
- Item
- FAMILY
- Item Mfqueue-002-ALT
- UDA_ID
- 100003
- GROUP_ID
- 1000000003
- PHASE_ID
- 100003
- REF_ITEM
- Item Mfqueue-002-ALT
- SUPPLIER
- 3
- UDA_DATE
- 2026-01-03
- UDA_TEXT
- Item Mfqueue-002-ALT
- VAT_TYPE
- I
- PACK_COMP
- Item Mfqueue-002-ALT
- SEASON_ID
- 100003
- THREAD_NO
- 4
- UDA_VALUE
- 3
- COUNTRY_ID
- ALT
- DIM_OBJECT
- Item M
- IMAGE_NAME
- Item Mfqueue Secondary
- PUB_STATUS
- P
- VAT_REGION
- 203
- ACTIVE_DATE
- 2026-01-03
- APPROVE_IND
- N
- MESSAGE_TYPE
- Item Mfqueue-00
- RELATED_ITEM
- Item Mfqueue-002-ALT
- TICKET_TYPE_ID
- ALT-
- RELATIONSHIP_ID
- 1000000003
- ITEM_SEASON_SEQ_NO
- 4
- TRANSACTION_NUMBER
- 3
- CUSTOM_MESSAGE_TYPE
- I
- TRANSACTION_TIME_STAMP
- 2026-02-09
default
- ITEMR
- Item Mfqueue-003-EDGE
- SEQ_NORPK
- 6
- UOM
- Item
- FAMILY
- Item Mfqueue-003-EDGE
- UDA_ID
- 100005
- GROUP_ID
- 1000000005
- PHASE_ID
- 100005
- REF_ITEM
- Item Mfqueue-003-EDGE
- SUPPLIER
- 5
- UDA_DATE
- 2026-01-05
- UDA_TEXT
- Item Mfqueue-003-EDGE
- VAT_TYPE
- I
- PACK_COMP
- Item Mfqueue-003-EDGE
- SEASON_ID
- 100005
- THREAD_NO
- 6
- UDA_VALUE
- 5
- COUNTRY_ID
- EDG
- DIM_OBJECT
- Item M
- IMAGE_NAME
- Item Mfqueue Core
- PUB_STATUS
- A
- VAT_REGION
- 205
- ACTIVE_DATE
- 2026-01-05
- APPROVE_IND
- N
- MESSAGE_TYPE
- Item Mfqueue-00
- RELATED_ITEM
- Item Mfqueue-003-EDGE
- TICKET_TYPE_ID
- EDGE
- RELATIONSHIP_ID
- 1000000005
- ITEM_SEASON_SEQ_NO
- 6
- TRANSACTION_NUMBER
- 5
- CUSTOM_MESSAGE_TYPE
- I
- TRANSACTION_TIME_STAMP
- 2026-03-12
Rule Validation Summary
- Source Rule Count
- 58
- Governed Rule Count
- 36