Item Location SOH (Message Queue)

In Scope

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

Rules & Considerations(18)

validation

constraint

Sample Load Data(4)

_scenario	FAMILYR	SEQ_NOR	THREAD_NOR	PUB_STATUSR	MESSAGE_TYPER	LOC	ITEM	LOC_TYPE	AVAILABLE_TO_SELL	TRANSACTION_TIME_STAMP
Example values from field definitions	SAMPLE	1	1	S	SAMPLE	1	SAMPLE	S	1.0000	2026-01-01
default	Item Loc SOH Mfqueue-002-ALT	4	4	P	Item Loc SOH Mf	3	Item Loc SOH Mfqueue-002-	w	12.5000	2026-02-09
default	Item Loc SOH Mfqueue-003-EDGE	6	6	A	Item Loc SOH Mf	5	Item Loc SOH Mfqueue-003-	s	14.0000	2026-03-12

Example values from field definitions

FAMILYR: SAMPLE
SEQ_NOR: 1
THREAD_NOR: 1
PUB_STATUSR: S
MESSAGE_TYPER: SAMPLE
LOC: 1
ITEM: SAMPLE
LOC_TYPE: S
AVAILABLE_TO_SELL: 1.0000
TRANSACTION_TIME_STAMP: 2026-01-01

default

FAMILYR: Item Loc SOH Mfqueue-002-ALT
SEQ_NOR: 4
THREAD_NOR: 4
PUB_STATUSR: P
MESSAGE_TYPER: Item Loc SOH Mf
LOC: 3
ITEM: Item Loc SOH Mfqueue-002-
LOC_TYPE: w
AVAILABLE_TO_SELL: 12.5000
TRANSACTION_TIME_STAMP: 2026-02-09

default

FAMILYR: Item Loc SOH Mfqueue-003-EDGE
SEQ_NOR: 6
THREAD_NOR: 6
PUB_STATUSR: A
MESSAGE_TYPER: Item Loc SOH Mf
LOC: 5
ITEM: Item Loc SOH Mfqueue-003-
LOC_TYPE: s
AVAILABLE_TO_SELL: 14.0000
TRANSACTION_TIME_STAMP: 2026-03-12

Rule Validation Summary

Source Rule Count: 44
Governed Rule Count: 18