Related Item Detail

In Scope

Technical: RELATED_ITEM_DETAIL | ID: OR-MFCS-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, Substitute etc).

See how this object fits into Item Management

Review the broader sequencing and dependencies for this domain

Migration Details

Complexity
Medium
Stage
Stage 2
Cutover Wave
Dependency Level

Dependencies

No dependencies

Target Structure

Load API
Table
Target Objects
RELATED_ITEM_DETAIL

Implementation Considerations

Use Cases

Initial load, rehearsal loads, cutover

Sequencing

Load during Master Data to establish foundational reference data before dependent setup or transactional loads. Load once prerequisite cross-domain reference data is available so RELATED_ITEM_DETAIL can be established cleanly. Sequence this object with its item management peers so MFCS processing can consume it without synthetic defaults. (Inferred from vendor object description, current scope dependencies, and Oracle Retail MFCS documentation.)

Cutover

Load during Stage 2 / .

Data Governance

Requires business ownership and source-to-target crosswalk governance.

Field Definitions (9)

Typical Source Systems

ERPLegacy

Notes

Load during Master Data to establish foundational reference data before dependent setup or transactional loads. Load once prerequisite cross-domain reference data is available so RELATED_ITEM_DETAIL can be established cleanly. Sequence this object with its item management peers so MFCS processing can consume it without synthetic defaults. (Inferred from vendor object description, current scope dependencies, and Oracle Retail MFCS documentation.)