Sales Line

In Scope

Technical: sales_line | ID: D365BC-OPEN-SALES_LINE

D365 BC migration object for Sales Line.

See how this object fits into Open Transactions Cutover

Review the broader sequencing and dependencies for this domain

Migration Details

Complexity: High
Sequencing: Open Transactions
Typical Sources: ERPLegacy

Target Structure

Load Approach: Table
Target Objects: Sales Line

This object has high complexity or dependency level

Review sequencing requirements before loading

Field Definitions(5)

Rules & Considerations(21)

validation

constraint

Sample Load Data(5)

_scenario	Document No.RPK	Document TypeRPK	No.	Line No.	Quantity	Unit Price	CUTOVER_WAVE	SALES_LINE_NAME	DEPENDENCY_LEVEL	EFFECTIVE_TO_DATE	SOURCE_ROW_NUMBER	LINE_REFERENCE_KEY	EFFECTIVE_FROM_DATE	LOAD_SEQUENCE_STAGE	SALES_REFERENCE_KEY	SALES_LINE_SOURCE_ID	SALES_LINE_CHANGE_HASH	SALES_LINE_DESCRIPTION	SALES_LINE_STATUS_CODE	SALES_LINE_ATTRIBUTE_01	SALES_LINE_ATTRIBUTE_02	SALES_LINE_BUSINESS_KEY	SALES LINE_REFERENCE_KEY
Example values from field definitions	Document No.	Document Type	No.	1	100.00	100.00	Sales Line-006	Sales Line Primary	Sales Line-007	2026-01-13	14	STD-SALES_LINE-001	2026-01-12	Open Transactions	STD-SALES_LINE-001	SRC-SALES_LINE-001	Sales Line-015	Sales Line: Baseline migration row	ACTIVE	Sales Line-016	Sales Line-017	BK-SALES_LINE-001	STD-SALES_LINE-001
default	—	—	—	—	—	—	Sales Line-006	Sales Line Secondary	MEDIUM-ALT	2026-01-14	15	ALT-SALES_LINE-002	2026-01-13	Open Transactions	ALT-SALES_LINE-002	LEG-SALES_LINE-002	Sales Line-015-ALT	Sales Line: Alternate source profile	PENDING	Sales Line-016-ALT	Sales Line-017-ALT	ALT-SALES_LINE-002	ALT-SALES_LINE-002
default	—	—	—	—	—	—	Sales Line-006	Sales Line Legacy	Sales Line-007	2026-01-15	16	—	2026-01-14	Open Transactions	—	EXT-SALES_LINE-003	Sales Line-015-EDGE	—	HOLD	—	—	EDGE-SALES_LINE-003	—

Example values from field definitions

Document No.RPK: Document No.
Document TypeRPK: Document Type
No.: No.
Line No.: 1
Quantity: 100.00
Unit Price: 100.00
CUTOVER_WAVE: Sales Line-006
SALES_LINE_NAME: Sales Line Primary
DEPENDENCY_LEVEL: Sales Line-007
EFFECTIVE_TO_DATE: 2026-01-13
SOURCE_ROW_NUMBER: 14
LINE_REFERENCE_KEY: STD-SALES_LINE-001
EFFECTIVE_FROM_DATE: 2026-01-12
LOAD_SEQUENCE_STAGE: Open Transactions
SALES_REFERENCE_KEY: STD-SALES_LINE-001
SALES_LINE_SOURCE_ID: SRC-SALES_LINE-001
SALES_LINE_CHANGE_HASH: Sales Line-015
SALES_LINE_DESCRIPTION: Sales Line: Baseline migration row
SALES_LINE_STATUS_CODE: ACTIVE
SALES_LINE_ATTRIBUTE_01: Sales Line-016
SALES_LINE_ATTRIBUTE_02: Sales Line-017
SALES_LINE_BUSINESS_KEY: BK-SALES_LINE-001
SALES LINE_REFERENCE_KEY: STD-SALES_LINE-001

default

Document No.RPK: —
Document TypeRPK: —
No.: —
Line No.: —
Quantity: —
Unit Price: —
CUTOVER_WAVE: Sales Line-006
SALES_LINE_NAME: Sales Line Secondary
DEPENDENCY_LEVEL: MEDIUM-ALT
EFFECTIVE_TO_DATE: 2026-01-14
SOURCE_ROW_NUMBER: 15
LINE_REFERENCE_KEY: ALT-SALES_LINE-002
EFFECTIVE_FROM_DATE: 2026-01-13
LOAD_SEQUENCE_STAGE: Open Transactions
SALES_REFERENCE_KEY: ALT-SALES_LINE-002
SALES_LINE_SOURCE_ID: LEG-SALES_LINE-002
SALES_LINE_CHANGE_HASH: Sales Line-015-ALT
SALES_LINE_DESCRIPTION: Sales Line: Alternate source profile
SALES_LINE_STATUS_CODE: PENDING
SALES_LINE_ATTRIBUTE_01: Sales Line-016-ALT
SALES_LINE_ATTRIBUTE_02: Sales Line-017-ALT
SALES_LINE_BUSINESS_KEY: ALT-SALES_LINE-002
SALES LINE_REFERENCE_KEY: ALT-SALES_LINE-002

default

Document No.RPK: —
Document TypeRPK: —
No.: —
Line No.: —
Quantity: —
Unit Price: —
CUTOVER_WAVE: Sales Line-006
SALES_LINE_NAME: Sales Line Legacy
DEPENDENCY_LEVEL: Sales Line-007
EFFECTIVE_TO_DATE: 2026-01-15
SOURCE_ROW_NUMBER: 16
LINE_REFERENCE_KEY: —
EFFECTIVE_FROM_DATE: 2026-01-14
LOAD_SEQUENCE_STAGE: Open Transactions
SALES_REFERENCE_KEY: —
SALES_LINE_SOURCE_ID: EXT-SALES_LINE-003
SALES_LINE_CHANGE_HASH: Sales Line-015-EDGE
SALES_LINE_DESCRIPTION: —
SALES_LINE_STATUS_CODE: HOLD
SALES_LINE_ATTRIBUTE_01: —
SALES_LINE_ATTRIBUTE_02: —
SALES_LINE_BUSINESS_KEY: EDGE-SALES_LINE-003
SALES LINE_REFERENCE_KEY: —

Rule Validation Summary

Source Rule Count: 21
Governed Rule Count: 6