Brand Mfqueue

In Scope

Technical: BRAND_MFQUEUE | ID: OR-SUP-BRAND_MFQUEUE-BRAND_MFQUEUE

Stores brand publication messages in sequence until they are published.

See how this object fits into Supplier 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: BRAND_MFQUEUE

Field Definitions(5)

Rules & Considerations(14)

validation

constraint

Sample Load Data(4)

_scenario	FAMILYR	SEQ_NORPK	BRAND_NAMER	PUB_STATUSR	MESSAGE_TYPER	THREAD_NO	TRANSACTION_NUMBER	CUSTOM_MESSAGE_TYPE	TRANSACTION_TIME_STAMP
Example values from field definitions	SAMPLE	1	SAMPLE	S	SAMPLE	1	1	S	2026-01-01
Closed historical record indicating a previously processed brand message	Brand Management	2	TAMPLE	C	TypeB	2	1002		2022-10-01
Minimal data scenario for a brand that is new with no associated transactions yet	Brand Management	3	SCMPLE	U	TypeA	—	1002	—	—

Example values from field definitions

FAMILYR: SAMPLE
SEQ_NORPK: 1
BRAND_NAMER: SAMPLE
PUB_STATUSR: S
MESSAGE_TYPER: SAMPLE
THREAD_NO: 1
TRANSACTION_NUMBER: 1
CUSTOM_MESSAGE_TYPE: S
TRANSACTION_TIME_STAMP: 2026-01-01

Closed historical record indicating a previously processed brand message

FAMILYR: Brand Management
SEQ_NORPK: 2
BRAND_NAMER: TAMPLE
PUB_STATUSR: C
MESSAGE_TYPER: TypeB
THREAD_NO: 2
TRANSACTION_NUMBER: 1002
CUSTOM_MESSAGE_TYPE
TRANSACTION_TIME_STAMP: 2022-10-01

Minimal data scenario for a brand that is new with no associated transactions yet

FAMILYR: Brand Management
SEQ_NORPK: 3
BRAND_NAMER: SCMPLE
PUB_STATUSR: U
MESSAGE_TYPER: TypeA
THREAD_NO: —
TRANSACTION_NUMBER: 1002
CUSTOM_MESSAGE_TYPE: —
TRANSACTION_TIME_STAMP: —

Rule Validation Summary

Source Rule Count: 20
Governed Rule Count: 14