Sales Invoice Header

In Scope

Technical: sales_invoice_header | ID: D365BC-HIST-SALES_INVOICE_HEADER

D365 BC migration object for Sales Invoice Header.

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 Header

Field Definitions(5)

Rules & Considerations(16)

constraint

validation

Sample Load Data(4)

_scenario	No.RPK	Amount	Order No.	CUTOVER_WAVE	Posting Date	DEPENDENCY_LEVEL	SALES_INVOICE_NAME	EFFECTIVE_FROM_DATE	LOAD_SEQUENCE_STAGE	SALES_REFERENCE_KEY	HEADER_REFERENCE_KEY	Sell-to Customer No.	INVOICE_REFERENCE_KEY	SALES_INVOICE_SOURCE_ID	SALES_INVOICE_DESCRIPTION	SALES_INVOICE_STATUS_CODE	SALES_INVOICE_BUSINESS_KEY	SALES INVOICE HEADER_REFERENCE_KEY
Example values from field definitions	No.	100.00	Order No.	Sales Invoice Header-006	2026-03-20	Sales Invoice Header-007	Sales Invoice Header Primary	2026-01-13	Historical Data	STD-SALES_INVO-001	STD-SALES_INVO-001	Sell-to Customer No.	STD-SALES_INVO-001	SRC-SALES_INVO-001	Sales Invoice Header: Baseline migration row	ACTIVE	BK-SALES_INVOIC-001	STD-SALES_INVO-001
default	—	—	—	Sales Invoice Header-006	—	MEDIUM-ALT	Sales Invoice Header Secondary	2026-01-14	Historical Data	ALT-SALES_INVO-002	ALT-SALES_INVO-002	—	ALT-SALES_INVO-002	LEG-SALES_INVO-002	Sales Invoice Header: Alternate source profile	PENDING	ALT-SALES_INVOIC-002	ALT-SALES_INVO-002
default	—	—	—	Sales Invoice Header-006	—	Sales Invoice Header-007	Sales Invoice Header Legacy	2026-01-15	Historical Data	—	—	—	—	EXT-SALES_INVO-003	—	HOLD	EDGE-SALES_INVOIC-003	—

Example values from field definitions

No.RPK: No.
Amount: 100.00
Order No.: Order No.
CUTOVER_WAVE: Sales Invoice Header-006
Posting Date: 2026-03-20
DEPENDENCY_LEVEL: Sales Invoice Header-007
SALES_INVOICE_NAME: Sales Invoice Header Primary
EFFECTIVE_FROM_DATE: 2026-01-13
LOAD_SEQUENCE_STAGE: Historical Data
SALES_REFERENCE_KEY: STD-SALES_INVO-001
HEADER_REFERENCE_KEY: STD-SALES_INVO-001
Sell-to Customer No.: Sell-to Customer No.
INVOICE_REFERENCE_KEY: STD-SALES_INVO-001
SALES_INVOICE_SOURCE_ID: SRC-SALES_INVO-001
SALES_INVOICE_DESCRIPTION: Sales Invoice Header: Baseline migration row
SALES_INVOICE_STATUS_CODE: ACTIVE
SALES_INVOICE_BUSINESS_KEY: BK-SALES_INVOIC-001
SALES INVOICE HEADER_REFERENCE_KEY: STD-SALES_INVO-001

default

No.RPK: —
Amount: —
Order No.: —
CUTOVER_WAVE: Sales Invoice Header-006
Posting Date: —
DEPENDENCY_LEVEL: MEDIUM-ALT
SALES_INVOICE_NAME: Sales Invoice Header Secondary
EFFECTIVE_FROM_DATE: 2026-01-14
LOAD_SEQUENCE_STAGE: Historical Data
SALES_REFERENCE_KEY: ALT-SALES_INVO-002
HEADER_REFERENCE_KEY: ALT-SALES_INVO-002
Sell-to Customer No.: —
INVOICE_REFERENCE_KEY: ALT-SALES_INVO-002
SALES_INVOICE_SOURCE_ID: LEG-SALES_INVO-002
SALES_INVOICE_DESCRIPTION: Sales Invoice Header: Alternate source profile
SALES_INVOICE_STATUS_CODE: PENDING
SALES_INVOICE_BUSINESS_KEY: ALT-SALES_INVOIC-002
SALES INVOICE HEADER_REFERENCE_KEY: ALT-SALES_INVO-002

default

No.RPK: —
Amount: —
Order No.: —
CUTOVER_WAVE: Sales Invoice Header-006
Posting Date: —
DEPENDENCY_LEVEL: Sales Invoice Header-007
SALES_INVOICE_NAME: Sales Invoice Header Legacy
EFFECTIVE_FROM_DATE: 2026-01-15
LOAD_SEQUENCE_STAGE: Historical Data
SALES_REFERENCE_KEY: —
HEADER_REFERENCE_KEY: —
Sell-to Customer No.: —
INVOICE_REFERENCE_KEY: —
SALES_INVOICE_SOURCE_ID: EXT-SALES_INVO-003
SALES_INVOICE_DESCRIPTION: —
SALES_INVOICE_STATUS_CODE: HOLD
SALES_INVOICE_BUSINESS_KEY: EDGE-SALES_INVOIC-003
SALES INVOICE HEADER_REFERENCE_KEY: —

Rule Validation Summary

Source Rule Count: 16
Governed Rule Count: 1