Sales Invoice Line

In Scope

Technical: sales_invoice_line | ID: D365BC-HIST-SALES_INVOICE_LINE

D365 BC migration object for Sales Invoice Line.

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: Sales Invoice Line

Field Definitions(32)

Rules & Considerations(17)

Sample Load Data(4)

_scenario	Line No.RPK	Document No.RPK	No.	Amount	Quantity	CUTOVER_WAVE	DEPENDENCY_LEVEL	LINE_REFERENCE_KEY	SALES_INVOICE_NAME	EFFECTIVE_FROM_DATE	LOAD_SEQUENCE_STAGE	SALES_REFERENCE_KEY	INVOICE_REFERENCE_KEY	SALES_INVOICE_SOURCE_ID	SALES_INVOICE_DESCRIPTION	SALES_INVOICE_STATUS_CODE	SALES_INVOICE_BUSINESS_KEY	SALES INVOICE LINE_REFERENCE_KEY
Example values from field definitions	1	Document No.	No.	100.00	100.00	Sales Invoice Line-006	Sales Invoice Line-007	STD-SALES_INVO-001	Sales Invoice Line Primary	2026-01-13	Historical Data	STD-SALES_INVO-001	STD-SALES_INVO-001	SRC-SALES_INVO-001	Sales Invoice Line: Baseline migration row	ACTIVE	BK-SALES_INVOIC-001	STD-SALES_INVO-001

Example values from field definitions

Line No.RPK: 1
Document No.RPK: Document No.
No.: No.
Amount: 100.00
Quantity: 100.00
CUTOVER_WAVE: Sales Invoice Line-006
DEPENDENCY_LEVEL: Sales Invoice Line-007
LINE_REFERENCE_KEY: STD-SALES_INVO-001
SALES_INVOICE_NAME: Sales Invoice Line Primary
EFFECTIVE_FROM_DATE: 2026-01-13
LOAD_SEQUENCE_STAGE: Historical Data
SALES_REFERENCE_KEY: STD-SALES_INVO-001
INVOICE_REFERENCE_KEY: STD-SALES_INVO-001
SALES_INVOICE_SOURCE_ID: SRC-SALES_INVO-001
SALES_INVOICE_DESCRIPTION: Sales Invoice Line: Baseline migration row
SALES_INVOICE_STATUS_CODE: ACTIVE
SALES_INVOICE_BUSINESS_KEY: BK-SALES_INVOIC-001
SALES INVOICE LINE_REFERENCE_KEY: STD-SALES_INVO-001

Rule Validation Summary

Source Rule Count: 17
Governed Rule Count: 2