Related Item Header

In Scope

Technical: RELATED_ITEM_HEAD | ID: OR-ITM-RELATED_ITEM_HEAD-RELATED_ITEM_HEADER

This is the header table for related items functionality. This table will contain one row for each item and relationship type (Cross Sell, Sub Sell, Substitute etc).

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: RELATED_ITEM_HEAD

Field Definitions(5)

Rules & Considerations(17)

validation

constraint

Sample Load Data(4)

_scenario	ITEMR	MANDATORY_INDR	RELATIONSHIP_IDRPK	RELATIONSHIP_NAMER	RELATIONSHIP_TYPER	CREATE_ID	LAST_UPDATE_ID	CREATE_DATETIME	LAST_UPDATE_DATETIME
Example values from field definitions	SAMPLE	S	1	SAMPLE	SAMPLE	SAMPLE	SAMPLE	2026-01-01	2026-01-01
default	Related Item Head-002-ALT	R	1000000003	Related Item Head Secondary	Relate	APP_USER_ID	APP_USER_ID	2026-01-03	2026-01-03
default	Related Item Head-003-EDG	R	1000000005	Related Item Head Core	Relate	USERENV	USERENV	2026-01-05	2026-01-05

Example values from field definitions

ITEMR: SAMPLE
MANDATORY_INDR: S
RELATIONSHIP_IDRPK: 1
RELATIONSHIP_NAMER: SAMPLE
RELATIONSHIP_TYPER: SAMPLE
CREATE_ID: SAMPLE
LAST_UPDATE_ID: SAMPLE
CREATE_DATETIME: 2026-01-01
LAST_UPDATE_DATETIME: 2026-01-01

default

ITEMR: Related Item Head-002-ALT
MANDATORY_INDR: R
RELATIONSHIP_IDRPK: 1000000003
RELATIONSHIP_NAMER: Related Item Head Secondary
RELATIONSHIP_TYPER: Relate
CREATE_ID: APP_USER_ID
LAST_UPDATE_ID: APP_USER_ID
CREATE_DATETIME: 2026-01-03
LAST_UPDATE_DATETIME: 2026-01-03