Beginning Balance Transactions

In Scope

Technical: beginning_balance_transactions | ID: D365BC-FIN-BEGINNING_BALANCE_TRANSACTIONS

D365 BC migration object for Beginning Balance Transactions.

See how this object fits into Finance Balances

Review the broader sequencing and dependencies for this domain

Migration Details

Complexity: High
Sequencing: Opening Balances
Typical Sources: ERPLegacy

Target Structure

Load Approach: Table
Target Objects: Beginning Balance Transactions

This object has high complexity or dependency level

Review sequencing requirements before loading

Field Definitions(5)

Rules & Considerations(18)

constraint

validation

Sample Load Data(5)

_scenario	Amount	Account No.	CUTOVER_WAVE	Document No.	Posting Date	Bal. Account No.	DEPENDENCY_LEVEL	EFFECTIVE_TO_DATE	SOURCE_ROW_NUMBER	EFFECTIVE_FROM_DATE	LOAD_SEQUENCE_STAGE	BALANCE_REFERENCE_KEY	BEGINNING_BALANCE_NAME	BEGINNING_REFERENCE_KEY	TRANSACTIONS_REFERENCE_KEY	BEGINNING_BALANCE_SOURCE_ID	BEGINNING_BALANCE_CHANGE_HASH	BEGINNING_BALANCE_DESCRIPTION	BEGINNING_BALANCE_STATUS_CODE	BEGINNING_BALANCE_ATTRIBUTE_01	BEGINNING_BALANCE_BUSINESS_KEY	BEGINNING BALANCE TRANSACTIONS_REFERENCE_KEY
Example values from field definitions	100.00	Account No.	Beginning Balance Transactions-006	Document No.	2026-03-20	Bal. Account No.	Beginning Balance Transactions-007	2026-01-14	15	2026-01-13	Opening Balances	STD-BEGINNING_-001	Beginning Balance Transactions Primary	STD-BEGINNING_-001	STD-BEGINNING_-001	SRC-BEGINNING_-001	Beginning Balance Transactions-016	Beginning Balance Transactions: Baseline migration row	ACTIVE	Beginning Balance Transactions-017	BK-BEGINNING_BA-001	STD-BEGINNING_-001
default	—	—	Beginning Balance Transactions-006	—	—	—	MEDIUM-ALT	2026-01-15	16	2026-01-14	Opening Balances	ALT-BEGINNING_-002	Beginning Balance Transactions Secondary	ALT-BEGINNING_-002	ALT-BEGINNING_-002	LEG-BEGINNING_-002	Beginning Balance Transactions-016-ALT	Beginning Balance Transactions: Alternate source profile	PENDING	Beginning Balance Transactions-017-ALT	ALT-BEGINNING_BA-002	ALT-BEGINNING_-002
default	—	—	Beginning Balance Transactions-006	—	—	—	Beginning Balance Transactions-007	2026-01-16	17	2026-01-15	Opening Balances	—	Beginning Balance Transactions Legacy	—	—	EXT-BEGINNING_-003	Beginning Balance Transactions-016-EDGE	—	HOLD	—	EDGE-BEGINNING_BA-003	—

Example values from field definitions

Amount: 100.00
Account No.: Account No.
CUTOVER_WAVE: Beginning Balance Transactions-006
Document No.: Document No.
Posting Date: 2026-03-20
Bal. Account No.: Bal. Account No.
DEPENDENCY_LEVEL: Beginning Balance Transactions-007
EFFECTIVE_TO_DATE: 2026-01-14
SOURCE_ROW_NUMBER: 15
EFFECTIVE_FROM_DATE: 2026-01-13
LOAD_SEQUENCE_STAGE: Opening Balances
BALANCE_REFERENCE_KEY: STD-BEGINNING_-001
BEGINNING_BALANCE_NAME: Beginning Balance Transactions Primary
BEGINNING_REFERENCE_KEY: STD-BEGINNING_-001
TRANSACTIONS_REFERENCE_KEY: STD-BEGINNING_-001
BEGINNING_BALANCE_SOURCE_ID: SRC-BEGINNING_-001
BEGINNING_BALANCE_CHANGE_HASH: Beginning Balance Transactions-016
BEGINNING_BALANCE_DESCRIPTION: Beginning Balance Transactions: Baseline migration row
BEGINNING_BALANCE_STATUS_CODE: ACTIVE
BEGINNING_BALANCE_ATTRIBUTE_01: Beginning Balance Transactions-017
BEGINNING_BALANCE_BUSINESS_KEY: BK-BEGINNING_BA-001
BEGINNING BALANCE TRANSACTIONS_REFERENCE_KEY: STD-BEGINNING_-001

default

Amount: —
Account No.: —
CUTOVER_WAVE: Beginning Balance Transactions-006
Document No.: —
Posting Date: —
Bal. Account No.: —
DEPENDENCY_LEVEL: MEDIUM-ALT
EFFECTIVE_TO_DATE: 2026-01-15
SOURCE_ROW_NUMBER: 16
EFFECTIVE_FROM_DATE: 2026-01-14
LOAD_SEQUENCE_STAGE: Opening Balances
BALANCE_REFERENCE_KEY: ALT-BEGINNING_-002
BEGINNING_BALANCE_NAME: Beginning Balance Transactions Secondary
BEGINNING_REFERENCE_KEY: ALT-BEGINNING_-002
TRANSACTIONS_REFERENCE_KEY: ALT-BEGINNING_-002
BEGINNING_BALANCE_SOURCE_ID: LEG-BEGINNING_-002
BEGINNING_BALANCE_CHANGE_HASH: Beginning Balance Transactions-016-ALT
BEGINNING_BALANCE_DESCRIPTION: Beginning Balance Transactions: Alternate source profile
BEGINNING_BALANCE_STATUS_CODE: PENDING
BEGINNING_BALANCE_ATTRIBUTE_01: Beginning Balance Transactions-017-ALT
BEGINNING_BALANCE_BUSINESS_KEY: ALT-BEGINNING_BA-002
BEGINNING BALANCE TRANSACTIONS_REFERENCE_KEY: ALT-BEGINNING_-002