Item
In ScopeTechnical: item | ID: D365BC-CORE-ITEM
D365 BC migration object for Item.
See how this object fits into Core Master Data
Review the broader sequencing and dependencies for this domain
Migration Details
- Complexity
- Medium
- Sequencing
- Master Data
- Typical Sources
- ERPLegacyLegacy ERPNAVAXSpreadsheet
Classification
- Information Type
- Master Data
Target Structure
- Load Approach
- Table
- Target Objects
- Item
Field Definitions(54)
Rules & Considerations(15)
Sample Load Data(4)
| _scenario | NO2R | GTINR | TYPER | BlockedR | UNITCOSTR | VENDORNOR | UNITPRICER | DescriptionR | VENDORITEMNOR | COSTINGMETHODR | LASTDIRECTCOSTR | LSCATTRIB1CODER | LSCATTRIB2CODER | LSCATTRIB3CODER | LSCATTRIB4CODER | LSCATTRIB5CODER | LSCDIVISIONCODER | LSCKEYINGINPRICER | PRICEINCLUDESVATR | AUTOMATICEXTTEXTSR | ROUNDINGPRECISIONR | Item Category CodeR | PURCHUNITOFMEASURER | SALESUNITOFMEASURER | GENPRODPOSTINGGROUPR | REPLENISHMENTSYSTEMR | VATPRODPOSTINGGROUPR | Base Unit of MeasureR | LSCRETAILPRODUCTCODER | VATBUSPOSTINGGRPRICER | INVENTORYPOSTINGGROUPR | ITEM_NAME | CUTOVER_WAVE | ITEM_SOURCE_ID | DEPENDENCY_LEVEL | ITEM_DESCRIPTION | ITEM_STATUS_CODE | LABELDESCRIPTION | EFFECTIVE_TO_DATE | ITEM_ATTRIBUTE_01 | ITEM_ATTRIBUTE_02 | ITEM_BUSINESS_KEY | ITEM_REFERENCE_KEY | EFFECTIVE_FROM_DATE | LOAD_SEQUENCE_STAGE |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | REF-98765 | 0123456789012 | STOCK | false | 20.00 | VEND-001 | 29.99 | Description | VEN-ITEM-001 | FIFO | 25.99 | SPECIAL | HEAVY_DUTY | NEW | CUSTOM_COLOR | LIGHTWEIGHT | EAST | KEYBOARD | true | Extended Attributes | 0.01 | Item Category Code | BOX | EA | IMPORT | AUTOMATIC | VAT20PERCENT | Base Unit of Measure | R1234 | EXEMPT | STOCK | Item Primary | Item-006 | SRC-ITEM-001 | Item-007 | Item: Baseline migration row | ACTIVE | Steel Hammer - 5lb | 2026-01-11 | Item-012 | Item-013 | BK-ITEM-001 | STD-ITEM-001 | 2026-01-10 | Master Data |
Example values from field definitions
- NO2R
- REF-98765
- GTINR
- 0123456789012
- TYPER
- STOCK
- BlockedR
- false
- UNITCOSTR
- 20.00
- VENDORNOR
- VEND-001
- UNITPRICER
- 29.99
- DescriptionR
- Description
- VENDORITEMNOR
- VEN-ITEM-001
- COSTINGMETHODR
- FIFO
- LASTDIRECTCOSTR
- 25.99
- LSCATTRIB1CODER
- SPECIAL
- LSCATTRIB2CODER
- HEAVY_DUTY
- LSCATTRIB3CODER
- NEW
- LSCATTRIB4CODER
- CUSTOM_COLOR
- LSCATTRIB5CODER
- LIGHTWEIGHT
- LSCDIVISIONCODER
- EAST
- LSCKEYINGINPRICER
- KEYBOARD
- PRICEINCLUDESVATR
- true
- AUTOMATICEXTTEXTSR
- Extended Attributes
- ROUNDINGPRECISIONR
- 0.01
- Item Category CodeR
- Item Category Code
- PURCHUNITOFMEASURER
- BOX
- SALESUNITOFMEASURER
- EA
- GENPRODPOSTINGGROUPR
- IMPORT
- REPLENISHMENTSYSTEMR
- AUTOMATIC
- VATPRODPOSTINGGROUPR
- VAT20PERCENT
- Base Unit of MeasureR
- Base Unit of Measure
- LSCRETAILPRODUCTCODER
- R1234
- VATBUSPOSTINGGRPRICER
- EXEMPT
- INVENTORYPOSTINGGROUPR
- STOCK
- ITEM_NAME
- Item Primary
- CUTOVER_WAVE
- Item-006
- ITEM_SOURCE_ID
- SRC-ITEM-001
- DEPENDENCY_LEVEL
- Item-007
- ITEM_DESCRIPTION
- Item: Baseline migration row
- ITEM_STATUS_CODE
- ACTIVE
- LABELDESCRIPTION
- Steel Hammer - 5lb
- EFFECTIVE_TO_DATE
- 2026-01-11
- ITEM_ATTRIBUTE_01
- Item-012
- ITEM_ATTRIBUTE_02
- Item-013
- ITEM_BUSINESS_KEY
- BK-ITEM-001
- ITEM_REFERENCE_KEY
- STD-ITEM-001
- EFFECTIVE_FROM_DATE
- 2026-01-10
- LOAD_SEQUENCE_STAGE
- Master Data
Rule Validation Summary
- Source Rule Count
- 15
- Governed Rule Count
- 15