Item Ledger Entry

In Scope

Technical: item_ledger_entry | ID: D365BC-HIST-ITEM_LEDGER_ENTRY

D365 BC migration object for Item Ledger Entry.

See how this object fits into Historical Data Analytics

Review the broader sequencing and dependencies for this domain

Migration Details

Complexity: Medium
Sequencing: Historical Data
Typical Sources: ERPLegacy

Target Structure

Load Approach: Table
Target Objects: Item Ledger Entry

Field Definitions(5)

Rules & Considerations(17)

constraint

validation

Sample Load Data(4)

_scenario	Item No.	Quantity	Entry No.	CUTOVER_WAVE	Posting Date	Location Code	DEPENDENCY_LEVEL	ITEM_LEDGER_NAME	ITEM_REFERENCE_KEY	EFFECTIVE_FROM_DATE	ENTRY_REFERENCE_KEY	LOAD_SEQUENCE_STAGE	LEDGER_REFERENCE_KEY	ITEM_LEDGER_SOURCE_ID	ITEM_LEDGER_DESCRIPTION	ITEM_LEDGER_STATUS_CODE	ITEM_LEDGER_BUSINESS_KEY	ITEM LEDGER ENTRY_REFERENCE_KEY
Example values from field definitions	Item No.	100.00	1	Item Ledger Entry-006	2026-03-20	Location Code	Item Ledger Entry-007	Item Ledger Entry Primary	STD-ITEM_LEDGE-001	2026-01-13	STD-ITEM_LEDGE-001	Historical Data	STD-ITEM_LEDGE-001	SRC-ITEM_LEDGE-001	Item Ledger Entry: Baseline migration row	ACTIVE	BK-ITEM_LEDGER-001	STD-ITEM_LEDGE-001
default	—	—	—	Item Ledger Entry-006	—	—	MEDIUM-ALT	Item Ledger Entry Secondary	ALT-ITEM_LEDGE-002	2026-01-14	ALT-ITEM_LEDGE-002	Historical Data	ALT-ITEM_LEDGE-002	LEG-ITEM_LEDGE-002	Item Ledger Entry: Alternate source profile	PENDING	ALT-ITEM_LEDGER-002	ALT-ITEM_LEDGE-002
default	—	—	—	Item Ledger Entry-006	—	—	Item Ledger Entry-007	Item Ledger Entry Legacy	—	2026-01-15	—	Historical Data	—	EXT-ITEM_LEDGE-003	—	HOLD	EDGE-ITEM_LEDGER-003	—

Example values from field definitions

Item No.: Item No.
Quantity: 100.00
Entry No.: 1
CUTOVER_WAVE: Item Ledger Entry-006
Posting Date: 2026-03-20
Location Code: Location Code
DEPENDENCY_LEVEL: Item Ledger Entry-007
ITEM_LEDGER_NAME: Item Ledger Entry Primary
ITEM_REFERENCE_KEY: STD-ITEM_LEDGE-001
EFFECTIVE_FROM_DATE: 2026-01-13
ENTRY_REFERENCE_KEY: STD-ITEM_LEDGE-001
LOAD_SEQUENCE_STAGE: Historical Data
LEDGER_REFERENCE_KEY: STD-ITEM_LEDGE-001
ITEM_LEDGER_SOURCE_ID: SRC-ITEM_LEDGE-001
ITEM_LEDGER_DESCRIPTION: Item Ledger Entry: Baseline migration row
ITEM_LEDGER_STATUS_CODE: ACTIVE
ITEM_LEDGER_BUSINESS_KEY: BK-ITEM_LEDGER-001
ITEM LEDGER ENTRY_REFERENCE_KEY: STD-ITEM_LEDGE-001

default

Item No.: —
Quantity: —
Entry No.: —
CUTOVER_WAVE: Item Ledger Entry-006
Posting Date: —
Location Code: —
DEPENDENCY_LEVEL: MEDIUM-ALT
ITEM_LEDGER_NAME: Item Ledger Entry Secondary
ITEM_REFERENCE_KEY: ALT-ITEM_LEDGE-002
EFFECTIVE_FROM_DATE: 2026-01-14
ENTRY_REFERENCE_KEY: ALT-ITEM_LEDGE-002
LOAD_SEQUENCE_STAGE: Historical Data
LEDGER_REFERENCE_KEY: ALT-ITEM_LEDGE-002
ITEM_LEDGER_SOURCE_ID: LEG-ITEM_LEDGE-002
ITEM_LEDGER_DESCRIPTION: Item Ledger Entry: Alternate source profile
ITEM_LEDGER_STATUS_CODE: PENDING
ITEM_LEDGER_BUSINESS_KEY: ALT-ITEM_LEDGER-002
ITEM LEDGER ENTRY_REFERENCE_KEY: ALT-ITEM_LEDGE-002

default

Item No.: —
Quantity: —
Entry No.: —
CUTOVER_WAVE: Item Ledger Entry-006
Posting Date: —
Location Code: —
DEPENDENCY_LEVEL: Item Ledger Entry-007
ITEM_LEDGER_NAME: Item Ledger Entry Legacy
ITEM_REFERENCE_KEY: —
EFFECTIVE_FROM_DATE: 2026-01-15
ENTRY_REFERENCE_KEY: —
LOAD_SEQUENCE_STAGE: Historical Data
LEDGER_REFERENCE_KEY: —
ITEM_LEDGER_SOURCE_ID: EXT-ITEM_LEDGE-003
ITEM_LEDGER_DESCRIPTION: —
ITEM_LEDGER_STATUS_CODE: HOLD
ITEM_LEDGER_BUSINESS_KEY: EDGE-ITEM_LEDGER-003
ITEM LEDGER ENTRY_REFERENCE_KEY: —

Rule Validation Summary

Source Rule Count: 17
Governed Rule Count: 2