Open Vendor Documents

In Scope

Technical: open_vendor_documents | ID: D365BC-FIN-OPEN_VENDOR_DOCUMENTS

D365 BC migration object for Open Vendor Documents.

See how this object fits into Finance Balances

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: Open Vendor Documents

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	Entry No.RPK	Amount	Vendor No.	CUTOVER_WAVE	Document No.	Posting Date	DEPENDENCY_LEVEL	OPEN_VENDOR_NAME	EFFECTIVE_TO_DATE	SOURCE_ROW_NUMBER	OPEN_REFERENCE_KEY	EFFECTIVE_FROM_DATE	LOAD_SEQUENCE_STAGE	VENDOR_REFERENCE_KEY	OPEN_VENDOR_SOURCE_ID	DOCUMENTS_REFERENCE_KEY	OPEN_VENDOR_CHANGE_HASH	OPEN_VENDOR_DESCRIPTION	OPEN_VENDOR_STATUS_CODE	OPEN_VENDOR_ATTRIBUTE_01	OPEN_VENDOR_BUSINESS_KEY	OPEN VENDOR DOCUMENTS_REFERENCE_KEY
Example values from field definitions	1	100.00	Vendor No.	Open Vendor Documents-006	Document No.	2026-03-20	Open Vendor Documents-007	Open Vendor Documents Primary	2026-01-14	15	STD-OPEN_VENDO-001	2026-01-13	Open Transactions	STD-OPEN_VENDO-001	SRC-OPEN_VENDO-001	STD-OPEN_VENDO-001	Open Vendor Documents-016	Open Vendor Documents: Baseline migration row	ACTIVE	Open Vendor Documents-017	BK-OPEN_VENDOR-001	STD-OPEN_VENDO-001
default	—	—	—	Open Vendor Documents-006	—	—	MEDIUM-ALT	Open Vendor Documents Secondary	2026-01-15	16	ALT-OPEN_VENDO-002	2026-01-14	Open Transactions	ALT-OPEN_VENDO-002	LEG-OPEN_VENDO-002	ALT-OPEN_VENDO-002	Open Vendor Documents-016-ALT	Open Vendor Documents: Alternate source profile	PENDING	Open Vendor Documents-017-ALT	ALT-OPEN_VENDOR-002	ALT-OPEN_VENDO-002
default	—	—	—	Open Vendor Documents-006	—	—	Open Vendor Documents-007	Open Vendor Documents Legacy	2026-01-16	17	—	2026-01-15	Open Transactions	—	EXT-OPEN_VENDO-003	—	Open Vendor Documents-016-EDGE	—	HOLD	—	EDGE-OPEN_VENDOR-003	—

Example values from field definitions

Entry No.RPK: 1
Amount: 100.00
Vendor No.: Vendor No.
CUTOVER_WAVE: Open Vendor Documents-006
Document No.: Document No.
Posting Date: 2026-03-20
DEPENDENCY_LEVEL: Open Vendor Documents-007
OPEN_VENDOR_NAME: Open Vendor Documents Primary
EFFECTIVE_TO_DATE: 2026-01-14
SOURCE_ROW_NUMBER: 15
OPEN_REFERENCE_KEY: STD-OPEN_VENDO-001
EFFECTIVE_FROM_DATE: 2026-01-13
LOAD_SEQUENCE_STAGE: Open Transactions
VENDOR_REFERENCE_KEY: STD-OPEN_VENDO-001
OPEN_VENDOR_SOURCE_ID: SRC-OPEN_VENDO-001
DOCUMENTS_REFERENCE_KEY: STD-OPEN_VENDO-001
OPEN_VENDOR_CHANGE_HASH: Open Vendor Documents-016
OPEN_VENDOR_DESCRIPTION: Open Vendor Documents: Baseline migration row
OPEN_VENDOR_STATUS_CODE: ACTIVE
OPEN_VENDOR_ATTRIBUTE_01: Open Vendor Documents-017
OPEN_VENDOR_BUSINESS_KEY: BK-OPEN_VENDOR-001
OPEN VENDOR DOCUMENTS_REFERENCE_KEY: STD-OPEN_VENDO-001

default

Entry No.RPK: —
Amount: —
Vendor No.: —
CUTOVER_WAVE: Open Vendor Documents-006
Document No.: —
Posting Date: —
DEPENDENCY_LEVEL: MEDIUM-ALT
OPEN_VENDOR_NAME: Open Vendor Documents Secondary
EFFECTIVE_TO_DATE: 2026-01-15
SOURCE_ROW_NUMBER: 16
OPEN_REFERENCE_KEY: ALT-OPEN_VENDO-002
EFFECTIVE_FROM_DATE: 2026-01-14
LOAD_SEQUENCE_STAGE: Open Transactions
VENDOR_REFERENCE_KEY: ALT-OPEN_VENDO-002
OPEN_VENDOR_SOURCE_ID: LEG-OPEN_VENDO-002
DOCUMENTS_REFERENCE_KEY: ALT-OPEN_VENDO-002
OPEN_VENDOR_CHANGE_HASH: Open Vendor Documents-016-ALT
OPEN_VENDOR_DESCRIPTION: Open Vendor Documents: Alternate source profile
OPEN_VENDOR_STATUS_CODE: PENDING
OPEN_VENDOR_ATTRIBUTE_01: Open Vendor Documents-017-ALT
OPEN_VENDOR_BUSINESS_KEY: ALT-OPEN_VENDOR-002
OPEN VENDOR DOCUMENTS_REFERENCE_KEY: ALT-OPEN_VENDO-002

default

Entry No.RPK: —
Amount: —
Vendor No.: —
CUTOVER_WAVE: Open Vendor Documents-006
Document No.: —
Posting Date: —
DEPENDENCY_LEVEL: Open Vendor Documents-007
OPEN_VENDOR_NAME: Open Vendor Documents Legacy
EFFECTIVE_TO_DATE: 2026-01-16
SOURCE_ROW_NUMBER: 17
OPEN_REFERENCE_KEY: —
EFFECTIVE_FROM_DATE: 2026-01-15
LOAD_SEQUENCE_STAGE: Open Transactions
VENDOR_REFERENCE_KEY: —
OPEN_VENDOR_SOURCE_ID: EXT-OPEN_VENDO-003
DOCUMENTS_REFERENCE_KEY: —
OPEN_VENDOR_CHANGE_HASH: Open Vendor Documents-016-EDGE
OPEN_VENDOR_DESCRIPTION: —
OPEN_VENDOR_STATUS_CODE: HOLD
OPEN_VENDOR_ATTRIBUTE_01: —
OPEN_VENDOR_BUSINESS_KEY: EDGE-OPEN_VENDOR-003
OPEN VENDOR DOCUMENTS_REFERENCE_KEY: —

Rule Validation Summary

Source Rule Count: 34
Governed Rule Count: 2