Item Category
In ScopeTechnical: item_category | ID: D365BC-PRD-ITEM_CATEGORY
D365 BC migration object for Item Category.
See how this object fits into Product Commercial Model
Review the broader sequencing and dependencies for this domain
Migration Details
- Complexity
- Low
- Sequencing
- Master Data
- Typical Sources
- ERPLegacy
Target Structure
- Load Approach
- Table
- Target Objects
- Item Category
Field Definitions(5)
Rules & Considerations(16)
constraint
validation
Sample Load Data(3)
| _scenario | CodeR | DescriptionR | CUTOVER_WAVE | Parent Category | DEPENDENCY_LEVEL | ITEM_CATEGORY_NAME | ITEM_REFERENCE_KEY | Presentation Order | LOAD_SEQUENCE_STAGE | ITEM_CATEGORY_SOURCE_ID | ITEM_CATEGORY_DESCRIPTION | ITEM_CATEGORY_STATUS_CODE | ITEM_CATEGORY_BUSINESS_KEY | ITEM CATEGORY_REFERENCE_KEY |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | Code | Description | Item Category-006 | Parent Category | Item Category-007 | Item Category Primary | STD-ITEM_CATEG-001 | Presentation Order | Master Data | SRC-ITEM_CATEG-001 | Item Category: Baseline migration row | ACTIVE | BK-ITEM_CATEGOR-001 | STD-ITEM_CATEG-001 |
| default | — | — | Item Category-006 | — | MEDIUM-ALT | Item Category Secondary | ALT-ITEM_CATEG-002 | — | Master Data | LEG-ITEM_CATEG-002 | Item Category: Alternate source profile | PENDING | ALT-ITEM_CATEGOR-002 | ALT-ITEM_CATEG-002 |
| default | — | — | Item Category-006 | — | Item Category-007 | Item Category Legacy | — | — | Master Data | EXT-ITEM_CATEG-003 | — | HOLD | EDGE-ITEM_CATEGOR-003 | — |
Example values from field definitions
- CodeR
- Code
- DescriptionR
- Description
- CUTOVER_WAVE
- Item Category-006
- Parent Category
- Parent Category
- DEPENDENCY_LEVEL
- Item Category-007
- ITEM_CATEGORY_NAME
- Item Category Primary
- ITEM_REFERENCE_KEY
- STD-ITEM_CATEG-001
- Presentation Order
- Presentation Order
- LOAD_SEQUENCE_STAGE
- Master Data
- ITEM_CATEGORY_SOURCE_ID
- SRC-ITEM_CATEG-001
- ITEM_CATEGORY_DESCRIPTION
- Item Category: Baseline migration row
- ITEM_CATEGORY_STATUS_CODE
- ACTIVE
- ITEM_CATEGORY_BUSINESS_KEY
- BK-ITEM_CATEGOR-001
- ITEM CATEGORY_REFERENCE_KEY
- STD-ITEM_CATEG-001
default
- CodeR
- —
- DescriptionR
- —
- CUTOVER_WAVE
- Item Category-006
- Parent Category
- —
- DEPENDENCY_LEVEL
- MEDIUM-ALT
- ITEM_CATEGORY_NAME
- Item Category Secondary
- ITEM_REFERENCE_KEY
- ALT-ITEM_CATEG-002
- Presentation Order
- —
- LOAD_SEQUENCE_STAGE
- Master Data
- ITEM_CATEGORY_SOURCE_ID
- LEG-ITEM_CATEG-002
- ITEM_CATEGORY_DESCRIPTION
- Item Category: Alternate source profile
- ITEM_CATEGORY_STATUS_CODE
- PENDING
- ITEM_CATEGORY_BUSINESS_KEY
- ALT-ITEM_CATEGOR-002
- ITEM CATEGORY_REFERENCE_KEY
- ALT-ITEM_CATEG-002
default
- CodeR
- —
- DescriptionR
- —
- CUTOVER_WAVE
- Item Category-006
- Parent Category
- —
- DEPENDENCY_LEVEL
- Item Category-007
- ITEM_CATEGORY_NAME
- Item Category Legacy
- ITEM_REFERENCE_KEY
- —
- Presentation Order
- —
- LOAD_SEQUENCE_STAGE
- Master Data
- ITEM_CATEGORY_SOURCE_ID
- EXT-ITEM_CATEG-003
- ITEM_CATEGORY_DESCRIPTION
- —
- ITEM_CATEGORY_STATUS_CODE
- HOLD
- ITEM_CATEGORY_BUSINESS_KEY
- EDGE-ITEM_CATEGOR-003
- ITEM CATEGORY_REFERENCE_KEY
- —
Rule Validation Summary
- Source Rule Count
- 16
- Governed Rule Count
- 4