Item

In Scope

Technical: 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(5)

Rules & Considerations(15)

Sample Load Data(4)

_scenario	BlockedR	DescriptionR	COSTINGMETHODR	Item Category CodeR	Base Unit of MeasureR	NO2	GTIN	TYPE	UNITCOST	VENDORNO	ITEM_NAME	UNITPRICE	CUTOVER_WAVE	VENDORITEMNO	ITEM_SOURCE_ID	LASTDIRECTCOST	LSCATTRIB1CODE	LSCATTRIB2CODE	LSCATTRIB3CODE	LSCATTRIB4CODE	LSCATTRIB5CODE	LSCDIVISIONCODE	DEPENDENCY_LEVEL	ITEM_DESCRIPTION	ITEM_STATUS_CODE	LABELDESCRIPTION	LSCKEYINGINPRICE	PRICEINCLUDESVAT	AUTOMATICEXTTEXTS	EFFECTIVE_TO_DATE	ITEM_ATTRIBUTE_01	ITEM_ATTRIBUTE_02	ITEM_BUSINESS_KEY	ROUNDINGPRECISION	ITEM_REFERENCE_KEY	PURCHUNITOFMEASURE	SALESUNITOFMEASURE	EFFECTIVE_FROM_DATE	GENPRODPOSTINGGROUP	LOAD_SEQUENCE_STAGE	REPLENISHMENTSYSTEM	VATPRODPOSTINGGROUP	LSCRETAILPRODUCTCODE	VATBUSPOSTINGGRPRICE	INVENTORYPOSTINGGROUP
Example values from field definitions	false	Description	FIFO	Item Category Code	Base Unit of Measure	REF-98765	0123456789012	STOCK	20.00	VEND-001	Item Primary	29.99	Item-006	VEN-ITEM-001	SRC-ITEM-001	25.99	SPECIAL	HEAVY_DUTY	NEW	CUSTOM_COLOR	LIGHTWEIGHT	EAST	Item-007	Item: Baseline migration row	ACTIVE	Steel Hammer - 5lb	KEYBOARD	true	Extended Attributes	2026-01-11	Item-012	Item-013	BK-ITEM-001	0.01	STD-ITEM-001	BOX	EA	2026-01-10	IMPORT	Master Data	AUTOMATIC	VAT20PERCENT	R1234	EXEMPT	STOCK
default	—	—	—	—	—	—	—	—	—	—	Item Secondary	—	Item-006	—	LEG-ITEM-002	—	—	—	—	—	—	—	MEDIUM-ALT	Item: Alternate source profile	PENDING	—	—	—	—	2026-01-12	Item-012-ALT	Item-013-ALT	ALT-ITEM-002	—	ALT-ITEM-002	—	—	2026-01-11	—	Master Data	—	—	—	—	—
default	—	—	—	—	—	—	—	—	—	—	Item Legacy	—	Item-006	—	EXT-ITEM-003	—	—	—	—	—	—	—	Item-007	—	HOLD	—	—	—	—	2026-01-13	—	—	EDGE-ITEM-003	—	—	—	—	2026-01-12	—	Master Data	—	—	—	—	—

Example values from field definitions

BlockedR: false
DescriptionR: Description
COSTINGMETHODR: FIFO
Item Category CodeR: Item Category Code
Base Unit of MeasureR: Base Unit of Measure
NO2: REF-98765
GTIN: 0123456789012
TYPE: STOCK
UNITCOST: 20.00
VENDORNO: VEND-001
ITEM_NAME: Item Primary
UNITPRICE: 29.99
CUTOVER_WAVE: Item-006
VENDORITEMNO: VEN-ITEM-001
ITEM_SOURCE_ID: SRC-ITEM-001
LASTDIRECTCOST: 25.99
LSCATTRIB1CODE: SPECIAL
LSCATTRIB2CODE: HEAVY_DUTY
LSCATTRIB3CODE: NEW
LSCATTRIB4CODE: CUSTOM_COLOR
LSCATTRIB5CODE: LIGHTWEIGHT
LSCDIVISIONCODE: EAST
DEPENDENCY_LEVEL: Item-007
ITEM_DESCRIPTION: Item: Baseline migration row
ITEM_STATUS_CODE: ACTIVE
LABELDESCRIPTION: Steel Hammer - 5lb
LSCKEYINGINPRICE: KEYBOARD
PRICEINCLUDESVAT: true
AUTOMATICEXTTEXTS: Extended Attributes
EFFECTIVE_TO_DATE: 2026-01-11
ITEM_ATTRIBUTE_01: Item-012
ITEM_ATTRIBUTE_02: Item-013
ITEM_BUSINESS_KEY: BK-ITEM-001
ROUNDINGPRECISION: 0.01
ITEM_REFERENCE_KEY: STD-ITEM-001
PURCHUNITOFMEASURE: BOX
SALESUNITOFMEASURE: EA
EFFECTIVE_FROM_DATE: 2026-01-10
GENPRODPOSTINGGROUP: IMPORT
LOAD_SEQUENCE_STAGE: Master Data
REPLENISHMENTSYSTEM: AUTOMATIC
VATPRODPOSTINGGROUP: VAT20PERCENT
LSCRETAILPRODUCTCODE: R1234
VATBUSPOSTINGGRPRICE: EXEMPT
INVENTORYPOSTINGGROUP: STOCK

default

BlockedR: —
DescriptionR: —
COSTINGMETHODR: —
Item Category CodeR: —
Base Unit of MeasureR: —
NO2: —
GTIN: —
TYPE: —
UNITCOST: —
VENDORNO: —
ITEM_NAME: Item Secondary
UNITPRICE: —
CUTOVER_WAVE: Item-006
VENDORITEMNO: —
ITEM_SOURCE_ID: LEG-ITEM-002
LASTDIRECTCOST: —
LSCATTRIB1CODE: —
LSCATTRIB2CODE: —
LSCATTRIB3CODE: —
LSCATTRIB4CODE: —
LSCATTRIB5CODE: —
LSCDIVISIONCODE: —
DEPENDENCY_LEVEL: MEDIUM-ALT
ITEM_DESCRIPTION: Item: Alternate source profile
ITEM_STATUS_CODE: PENDING
LABELDESCRIPTION: —
LSCKEYINGINPRICE: —
PRICEINCLUDESVAT: —
AUTOMATICEXTTEXTS: —
EFFECTIVE_TO_DATE: 2026-01-12
ITEM_ATTRIBUTE_01: Item-012-ALT
ITEM_ATTRIBUTE_02: Item-013-ALT
ITEM_BUSINESS_KEY: ALT-ITEM-002
ROUNDINGPRECISION: —
ITEM_REFERENCE_KEY: ALT-ITEM-002
PURCHUNITOFMEASURE: —
SALESUNITOFMEASURE: —
EFFECTIVE_FROM_DATE: 2026-01-11
GENPRODPOSTINGGROUP: —
LOAD_SEQUENCE_STAGE: Master Data
REPLENISHMENTSYSTEM: —
VATPRODPOSTINGGROUP: —
LSCRETAILPRODUCTCODE: —
VATBUSPOSTINGGRPRICE: —
INVENTORYPOSTINGGROUP: —

default

BlockedR: —
DescriptionR: —
COSTINGMETHODR: —
Item Category CodeR: —
Base Unit of MeasureR: —
NO2: —
GTIN: —
TYPE: —
UNITCOST: —
VENDORNO: —
ITEM_NAME: Item Legacy
UNITPRICE: —
CUTOVER_WAVE: Item-006
VENDORITEMNO: —
ITEM_SOURCE_ID: EXT-ITEM-003
LASTDIRECTCOST: —
LSCATTRIB1CODE: —
LSCATTRIB2CODE: —
LSCATTRIB3CODE: —
LSCATTRIB4CODE: —
LSCATTRIB5CODE: —
LSCDIVISIONCODE: —
DEPENDENCY_LEVEL: Item-007
ITEM_DESCRIPTION: —
ITEM_STATUS_CODE: HOLD
LABELDESCRIPTION: —
LSCKEYINGINPRICE: —
PRICEINCLUDESVAT: —
AUTOMATICEXTTEXTS: —
EFFECTIVE_TO_DATE: 2026-01-13
ITEM_ATTRIBUTE_01: —
ITEM_ATTRIBUTE_02: —
ITEM_BUSINESS_KEY: EDGE-ITEM-003
ROUNDINGPRECISION: —
ITEM_REFERENCE_KEY: —
PURCHUNITOFMEASURE: —
SALESUNITOFMEASURE: —
EFFECTIVE_FROM_DATE: 2026-01-12
GENPRODPOSTINGGROUP: —
LOAD_SEQUENCE_STAGE: Master Data
REPLENISHMENTSYSTEM: —
VATPRODPOSTINGGROUP: —
LSCRETAILPRODUCTCODE: —
VATBUSPOSTINGGRPRICE: —
INVENTORYPOSTINGGROUP: —

Rule Validation Summary

Source Rule Count: 15
Governed Rule Count: 15

All objects