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(17)

Rules & Considerations(17)

Sample Load Data(4)

_scenario	Entry No.RPK	Item No.	Quantity	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	1	Item No.	100.00	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

Example values from field definitions

Entry No.RPK: 1
Item No.: Item No.
Quantity: 100.00
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

Rule Validation Summary

Source Rule Count: 17
Governed Rule Count: 2

Item Ledger Entry | historical data analytics | D365 Bc