Related Item Information
In ScopeTechnical: RELATED_ITEM | ID: OR-STO-RELATED_ITEM-RELATED_ITEM
Stores related item information.
See how this object fits into Store Operations
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
Field Definitions(5)
Rules & Considerations(16)
constraint
validation
Sample Load Data(4)
| _scenario | ITEM_IDRPK | MANDATORY_INDR | RELATIONSHIP_TYPER | RELATIONSHIP_ID_EXTERNALR | END_DATE | EFFECTIVE_DATE | PRIORITY_NUMBER | RELATED_ITEM_ID | RELATIONSHIP_NAME |
|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | S | SAMPLE | 1 | 2026-01-01 | 2026-01-01 | 1 | SAMPLE | SAMPLE |
| default | ALT-RELATED_IT-002 | N | SUBS | 3 | 2026-01-03 | 2026-01-03 | 3 | ALT-RELATED_IT-002 | Related Item Secondary |
| default | EDGE-RELATED_IT-003 | Y | UPSL | 5 | 2026-01-05 | 2026-01-05 | 5 | EDGE-RELATED_IT-003 | Related Item Core |
Example values from field definitions
- ITEM_IDRPK
- SAMPLE
- MANDATORY_INDR
- S
- RELATIONSHIP_TYPER
- SAMPLE
- RELATIONSHIP_ID_EXTERNALR
- 1
- END_DATE
- 2026-01-01
- EFFECTIVE_DATE
- 2026-01-01
- PRIORITY_NUMBER
- 1
- RELATED_ITEM_ID
- SAMPLE
- RELATIONSHIP_NAME
- SAMPLE
default
- ITEM_IDRPK
- ALT-RELATED_IT-002
- MANDATORY_INDR
- N
- RELATIONSHIP_TYPER
- SUBS
- RELATIONSHIP_ID_EXTERNALR
- 3
- END_DATE
- 2026-01-03
- EFFECTIVE_DATE
- 2026-01-03
- PRIORITY_NUMBER
- 3
- RELATED_ITEM_ID
- ALT-RELATED_IT-002
- RELATIONSHIP_NAME
- Related Item Secondary
default
- ITEM_IDRPK
- EDGE-RELATED_IT-003
- MANDATORY_INDR
- Y
- RELATIONSHIP_TYPER
- UPSL
- RELATIONSHIP_ID_EXTERNALR
- 5
- END_DATE
- 2026-01-05
- EFFECTIVE_DATE
- 2026-01-05
- PRIORITY_NUMBER
- 5
- RELATED_ITEM_ID
- EDGE-RELATED_IT-003
- RELATIONSHIP_NAME
- Related Item Core
Rule Validation Summary
- Source Rule Count
- 23
- Governed Rule Count
- 16