Vendor

In Scope

Technical: vendor | ID: D365BC-CORE-VENDOR

D365 BC migration object for Vendor.

See how this object fits into Core Master Data

Review the broader sequencing and dependencies for this domain

Migration Details

Complexity: Medium
Sequencing: Master Data
Typical Sources: ERPLegacy

Classification

Information Type: Master Data

Target Structure

Load Approach: Table
Target Objects: Vendor

Field Definitions(5)

Rules & Considerations(15)

Sample Load Data(4)

_scenario	CITY	Name	EMAIL	COUNTY	ADDRESS	Blocked	COUNTRY	ADDRESS2	POSTCODE	Search Name	VENDOR_NAME	CURRENCYCODE	CUTOVER_WAVE	FORMATREGION	LANGUAGECODE	ICPARTNERCODE	OVERRECEIPTCODE	DEPENDENCY_LEVEL	PAYMENTTERMSCODE	VENDOR_SOURCE_ID	APPLICATIONMETHOD	EFFECTIVE_TO_DATE	PAYMENTMETHODCODE	VATREGISTRATIONNO	GENBUSPOSTINGGROUP	PRICESINCLUDINGVAT	VATBUSPOSTINGGROUP	VENDORPOSTINGGROUP	VENDOR_DESCRIPTION	VENDOR_STATUS_CODE	Country/Region Code	EFFECTIVE_FROM_DATE	LOAD_SEQUENCE_STAGE	VENDOR_ATTRIBUTE_01	VENDOR_ATTRIBUTE_02	VENDOR_BUSINESS_KEY	VENDOR_REFERENCE_KEY
Example values from field definitions	Chicago	Name	accounts.payable@global-supplies.com	Cook County	123 Industrial Park Drive	false	United States	Building 5, Suite 200	60601	Search Name	Vendor Primary	USD	Vendor-006	en-US	EN	IC001	5%	Vendor-007	NET30	SRC-VENDOR-001	Apply to Oldest	2026-01-11	Bank Transfer	US123456789	DOMESTIC	True	VAT-REG	Accounts Payable	Vendor: Baseline migration row	ACTIVE	Country/Region Code	2026-01-10	Master Data	Vendor-012	Vendor-013	BK-VENDOR-001	STD-VENDOR-001
default	—	—	—	—	—	—	—	—	—	—	Vendor Secondary	—	Vendor-006	—	—	—	—	MEDIUM-ALT	—	LEG-VENDOR-002	—	2026-01-12	—	—	—	—	—	—	Vendor: Alternate source profile	PENDING	—	2026-01-11	Master Data	Vendor-012-ALT	Vendor-013-ALT	ALT-VENDOR-002	ALT-VENDOR-002
default	—	—	—	—	—	—	—	—	—	—	Vendor Legacy	—	Vendor-006	—	—	—	—	Vendor-007	—	EXT-VENDOR-003	—	2026-01-13	—	—	—	—	—	—	—	HOLD	—	2026-01-12	Master Data	—	—	EDGE-VENDOR-003	—

Example values from field definitions

CITY: Chicago
Name: Name
EMAIL: accounts.payable@global-supplies.com
COUNTY: Cook County
ADDRESS: 123 Industrial Park Drive
Blocked: false
COUNTRY: United States
ADDRESS2: Building 5, Suite 200
POSTCODE: 60601
Search Name: Search Name
VENDOR_NAME: Vendor Primary
CURRENCYCODE: USD
CUTOVER_WAVE: Vendor-006
FORMATREGION: en-US
LANGUAGECODE: EN
ICPARTNERCODE: IC001
OVERRECEIPTCODE: 5%
DEPENDENCY_LEVEL: Vendor-007
PAYMENTTERMSCODE: NET30
VENDOR_SOURCE_ID: SRC-VENDOR-001
APPLICATIONMETHOD: Apply to Oldest
EFFECTIVE_TO_DATE: 2026-01-11
PAYMENTMETHODCODE: Bank Transfer
VATREGISTRATIONNO: US123456789
GENBUSPOSTINGGROUP: DOMESTIC
PRICESINCLUDINGVAT: True
VATBUSPOSTINGGROUP: VAT-REG
VENDORPOSTINGGROUP: Accounts Payable
VENDOR_DESCRIPTION: Vendor: Baseline migration row
VENDOR_STATUS_CODE: ACTIVE
Country/Region Code: Country/Region Code
EFFECTIVE_FROM_DATE: 2026-01-10
LOAD_SEQUENCE_STAGE: Master Data
VENDOR_ATTRIBUTE_01: Vendor-012
VENDOR_ATTRIBUTE_02: Vendor-013
VENDOR_BUSINESS_KEY: BK-VENDOR-001
VENDOR_REFERENCE_KEY: STD-VENDOR-001

default

CITY: —
Name: —
EMAIL: —
COUNTY: —
ADDRESS: —
Blocked: —
COUNTRY: —
ADDRESS2: —
POSTCODE: —
Search Name: —
VENDOR_NAME: Vendor Secondary
CURRENCYCODE: —
CUTOVER_WAVE: Vendor-006
FORMATREGION: —
LANGUAGECODE: —
ICPARTNERCODE: —
OVERRECEIPTCODE: —
DEPENDENCY_LEVEL: MEDIUM-ALT
PAYMENTTERMSCODE: —
VENDOR_SOURCE_ID: LEG-VENDOR-002
APPLICATIONMETHOD: —
EFFECTIVE_TO_DATE: 2026-01-12
PAYMENTMETHODCODE: —
VATREGISTRATIONNO: —
GENBUSPOSTINGGROUP: —
PRICESINCLUDINGVAT: —
VATBUSPOSTINGGROUP: —
VENDORPOSTINGGROUP: —
VENDOR_DESCRIPTION: Vendor: Alternate source profile
VENDOR_STATUS_CODE: PENDING
Country/Region Code: —
EFFECTIVE_FROM_DATE: 2026-01-11
LOAD_SEQUENCE_STAGE: Master Data
VENDOR_ATTRIBUTE_01: Vendor-012-ALT
VENDOR_ATTRIBUTE_02: Vendor-013-ALT
VENDOR_BUSINESS_KEY: ALT-VENDOR-002
VENDOR_REFERENCE_KEY: ALT-VENDOR-002

default

Rule Validation Summary

Source Rule Count: 15
Governed Rule Count: 15