Item (Message Queue)

In Scope

Technical: 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(31)

Rules & Considerations(36)

validation

constraint

Sample Load Data(4)

Example values from field definitions

ITEMR
SAMPLE
FAMILYR
SAMPLE
SEQ_NORPK
1
THREAD_NOR
1
PUB_STATUSR
S
APPROVE_INDR
S
MESSAGE_TYPER
SAMPLE
UOM
SAMP
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
UDA_VALUE
1
COUNTRY_ID
SAM
DIM_OBJECT
SAMPLE
IMAGE_NAME
SAMPLE
VAT_REGION
1
ACTIVE_DATE
2026-01-01
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

Rule Validation Summary

Source Rule Count
58
Governed Rule Count
36