Related Item Head
In ScopeTechnical: RELATED_ITEM_HEAD | ID: OR-MFCS-RELATED_ITEM_HEAD
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
Target Structure
- Load Approach
- Table
- Target Objects
- RELATED_ITEM_HEAD
Field Definitions(9)
Rules & Considerations(30)
Sample Load Data(4)
| _scenario | ITEMR | CREATE_IDR | MANDATORY_INDR | LAST_UPDATE_IDR | CREATE_DATETIMER | RELATIONSHIP_IDRPK | RELATIONSHIP_NAMER | RELATIONSHIP_TYPER | LAST_UPDATE_DATETIMER |
|---|---|---|---|---|---|---|---|---|---|
| default | Related Item Head-001 | RETAIL_C TX | Related Item Head-001 | RETAIL_C TX | 2026-01-01 | 1000000001 | Related Item Head Primary | Related Item Head-001 | 2026-01-01 |
default
- ITEMR
- Related Item Head-001
- CREATE_IDR
- RETAIL_C TX
- MANDATORY_INDR
- Related Item Head-001
- LAST_UPDATE_IDR
- RETAIL_C TX
- CREATE_DATETIMER
- 2026-01-01
- RELATIONSHIP_IDRPK
- 1000000001
- RELATIONSHIP_NAMER
- Related Item Head Primary
- RELATIONSHIP_TYPER
- Related Item Head-001
- LAST_UPDATE_DATETIMER
- 2026-01-01