Related Item Detail

In Scope

Technical: RELATED_ITEM_DETAIL | ID: OR-ITM-RELATED_ITEM_DETAIL-RELATED_ITEM_DETAIL

Stores the related items to a main_item in related_item_head. This table will contain one row for each related item for a given main-item and relationship type (Cross Sell, Up Sell,...

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_DETAIL

Field Definitions(5)

Rules & Considerations(15)

validation

constraint

Sample Load Data(4)

_scenario	RELATED_ITEMRPK	RELATIONSHIP_IDRPK	END_DATE	PRIORITY	CREATE_ID	START_DATE	LAST_UPDATE_ID	CREATE_DATETIME	LAST_UPDATE_DATETIME
Example values from field definitions	SAMPLE	1	2026-01-01	1	SAMPLE	2026-01-01	SAMPLE	2026-01-01	2026-01-01
default	Related Item Detail-002-A	1000000003	2026-01-03	3	APP_USER_ID	2026-01-03	APP_USER_ID	2026-01-03	2026-01-03
default	Related Item Detail-003-E	1000000005	2026-01-05	5	USERENV	2026-01-05	USERENV	2026-01-05	2026-01-05

Example values from field definitions

RELATED_ITEMRPK: SAMPLE
RELATIONSHIP_IDRPK: 1
END_DATE: 2026-01-01
PRIORITY: 1
CREATE_ID: SAMPLE
START_DATE: 2026-01-01
LAST_UPDATE_ID: SAMPLE
CREATE_DATETIME: 2026-01-01
LAST_UPDATE_DATETIME: 2026-01-01

default

RELATED_ITEMRPK: Related Item Detail-002-A
RELATIONSHIP_IDRPK: 1000000003
END_DATE: 2026-01-03
PRIORITY: 3
CREATE_ID: APP_USER_ID
START_DATE: 2026-01-03
LAST_UPDATE_ID: APP_USER_ID
CREATE_DATETIME: 2026-01-03
LAST_UPDATE_DATETIME: 2026-01-03