Item Variant

In Scope

Technical: item_variant | ID: D365BC-PRD-ITEM_VARIANT

D365 BC migration object for Item Variant.

See how this object fits into Product Commercial Model

Review the broader sequencing and dependencies for this domain

Migration Details

Complexity
Medium
Sequencing
Master Data
Typical Sources
ERPLegacy

Target Structure

Load Approach
Table
Target Objects
Item Variant

Field Definitions(5)

Rules & Considerations(19)

validation

constraint

Sample Load Data(4)

Example values from field definitions

CodeRPK
Code
Blocked
false
Item No.
Item No.
Description
Description
CUTOVER_WAVE
Item Variant-006
Variant Code
Variant Code
DEPENDENCY_LEVEL
Item Variant-007
EFFECTIVE_TO_DATE
2026-01-13
ITEM_VARIANT_NAME
Item Variant Primary
ITEM_REFERENCE_KEY
STD-ITEM_VARIA-001
EFFECTIVE_FROM_DATE
2026-01-12
LOAD_SEQUENCE_STAGE
Master Data
VARIANT_REFERENCE_KEY
STD-ITEM_VARIA-001
ITEM_VARIANT_SOURCE_ID
SRC-ITEM_VARIA-001
ITEM_VARIANT_DESCRIPTION
Item Variant: Baseline migration row
ITEM_VARIANT_STATUS_CODE
ACTIVE
ITEM_VARIANT_BUSINESS_KEY
BK-ITEM_VARIANT-001
ITEM VARIANT_REFERENCE_KEY
STD-ITEM_VARIA-001

default

CodeRPK
Blocked
Item No.
Description
CUTOVER_WAVE
Item Variant-006
Variant Code
DEPENDENCY_LEVEL
MEDIUM-ALT
EFFECTIVE_TO_DATE
2026-01-14
ITEM_VARIANT_NAME
Item Variant Secondary
ITEM_REFERENCE_KEY
ALT-ITEM_VARIA-002
EFFECTIVE_FROM_DATE
2026-01-13
LOAD_SEQUENCE_STAGE
Master Data
VARIANT_REFERENCE_KEY
ALT-ITEM_VARIA-002
ITEM_VARIANT_SOURCE_ID
LEG-ITEM_VARIA-002
ITEM_VARIANT_DESCRIPTION
Item Variant: Alternate source profile
ITEM_VARIANT_STATUS_CODE
PENDING
ITEM_VARIANT_BUSINESS_KEY
ALT-ITEM_VARIANT-002
ITEM VARIANT_REFERENCE_KEY
ALT-ITEM_VARIA-002

default

CodeRPK
Blocked
Item No.
Description
CUTOVER_WAVE
Item Variant-006
Variant Code
DEPENDENCY_LEVEL
Item Variant-007
EFFECTIVE_TO_DATE
2026-01-15
ITEM_VARIANT_NAME
Item Variant Legacy
ITEM_REFERENCE_KEY
EFFECTIVE_FROM_DATE
2026-01-14
LOAD_SEQUENCE_STAGE
Master Data
VARIANT_REFERENCE_KEY
ITEM_VARIANT_SOURCE_ID
EXT-ITEM_VARIA-003
ITEM_VARIANT_DESCRIPTION
ITEM_VARIANT_STATUS_CODE
HOLD
ITEM_VARIANT_BUSINESS_KEY
EDGE-ITEM_VARIANT-003
ITEM VARIANT_REFERENCE_KEY

Rule Validation Summary

Source Rule Count
18
Governed Rule Count
5