Customer

In Scope

Technical: customer | ID: D365BC-CORE-CUSTOMER

D365 BC migration object for Customer.

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: Customer

Field Definitions(5)

Rules & Considerations(15)

Sample Load Data(4)

_scenario	CITY	Name	EMAIL	COUNTY	ADDRESS	Blocked	CONTACT	Column1	PHONENO	ADDRESS2	POSTCODE	BDMCODEKPSD	Search Name	CURRENCYCODE	CUTOVER_WAVE	FORMATREGION	LANGUAGECODE	CUSTOMER_NAME	Credit Rating	CREDITLIMITLCY	PRINTSTATEMENTS	SALESPERSONCODE	COMBINESHIPMENTS	DEPENDENCY_LEVEL	PAYMENTTERMSCODE	APPLICATIONMETHOD	EFFECTIVE_TO_DATE	PAYMENTMETHODCODE	REMINDERTERMSCODE	SHIPPINGAGENTCODE	VATREGISTRATIONNO	CUSTOMER_SOURCE_ID	GENBUSPOSTINGGROUP	SHIPMENTMETHODCODE	VATBUSPOSTINGGROUP	Country/Region Code	EFFECTIVE_FROM_DATE	LOAD_SEQUENCE_STAGE	CUSTOMERPOSTINGGROUP	CUSTOMER_DESCRIPTION	CUSTOMER_STATUS_CODE	CUSTOMER_ATTRIBUTE_01	CUSTOMER_ATTRIBUTE_02	CUSTOMER_BUSINESS_KEY	CUSTOMER_REFERENCE_KEY	MAPTOINTEGRATIONCODEKPSD	SHIPPINGAGENTSERVICECODE	Business Development Manager Code
Example values from field definitions	NYC	Name	info@acmecorp.com	New York County	123 Main St	false	John Doe	CUST	+1-555-555-5555	Suite 200	10001	ABC123	Search Name	USD	Customer-006	US-NY	EN	Customer Primary	A	5000.00	YES	SP1	true	Customer-007	NET	ONLINE	2026-01-11	CREDIT	30D	AGENT001	VAT123456789	SRC-CUSTOMER-001	BUSGROUP	UPS	VAT1	Country/Region Code	2026-01-10	Master Data	GEN	Customer: Baseline migration row	ACTIVE	Customer-012	Customer-013	BK-CUSTOMER-001	STD-CUSTOMER-001	INTEGRATE01	SERVICE001	111
default	—	—	—	—	—	—	—	—	—	—	—	—	—	—	Customer-006	—	—	Customer Secondary	—	—	—	—	—	MEDIUM-ALT	—	—	2026-01-12	—	—	—	—	LEG-CUSTOMER-002	—	—	—	—	2026-01-11	Master Data	—	Customer: Alternate source profile	PENDING	Customer-012-ALT	Customer-013-ALT	ALT-CUSTOMER-002	ALT-CUSTOMER-002	—	—	—
default	—	—	—	—	—	—	—	—	—	—	—	—	—	—	Customer-006	—	—	Customer Legacy	—	—	—	—	—	Customer-007	—	—	2026-01-13	—	—	—	—	EXT-CUSTOMER-003	—	—	—	—	2026-01-12	Master Data	—	—	HOLD	—	—	EDGE-CUSTOMER-003	—	—	—	—

Example values from field definitions

CITY: NYC
Name: Name
EMAIL: info@acmecorp.com
COUNTY: New York County
ADDRESS: 123 Main St
Blocked: false
CONTACT: John Doe
Column1: CUST
PHONENO: +1-555-555-5555
ADDRESS2: Suite 200
POSTCODE: 10001
BDMCODEKPSD: ABC123
Search Name: Search Name
CURRENCYCODE: USD
CUTOVER_WAVE: Customer-006
FORMATREGION: US-NY
LANGUAGECODE: EN
CUSTOMER_NAME: Customer Primary
Credit Rating: A
CREDITLIMITLCY: 5000.00
PRINTSTATEMENTS: YES
SALESPERSONCODE: SP1
COMBINESHIPMENTS: true
DEPENDENCY_LEVEL: Customer-007
PAYMENTTERMSCODE: NET
APPLICATIONMETHOD: ONLINE
EFFECTIVE_TO_DATE: 2026-01-11
PAYMENTMETHODCODE: CREDIT
REMINDERTERMSCODE: 30D
SHIPPINGAGENTCODE: AGENT001
VATREGISTRATIONNO: VAT123456789
CUSTOMER_SOURCE_ID: SRC-CUSTOMER-001
GENBUSPOSTINGGROUP: BUSGROUP
SHIPMENTMETHODCODE: UPS
VATBUSPOSTINGGROUP: VAT1
Country/Region Code: Country/Region Code
EFFECTIVE_FROM_DATE: 2026-01-10
LOAD_SEQUENCE_STAGE: Master Data
CUSTOMERPOSTINGGROUP: GEN
CUSTOMER_DESCRIPTION: Customer: Baseline migration row
CUSTOMER_STATUS_CODE: ACTIVE
CUSTOMER_ATTRIBUTE_01: Customer-012
CUSTOMER_ATTRIBUTE_02: Customer-013
CUSTOMER_BUSINESS_KEY: BK-CUSTOMER-001
CUSTOMER_REFERENCE_KEY: STD-CUSTOMER-001
MAPTOINTEGRATIONCODEKPSD: INTEGRATE01
SHIPPINGAGENTSERVICECODE: SERVICE001
Business Development Manager Code: 111

default

CITY: —
Name: —
EMAIL: —
COUNTY: —
ADDRESS: —
Blocked: —
CONTACT: —
Column1: —
PHONENO: —
ADDRESS2: —
POSTCODE: —
BDMCODEKPSD: —
Search Name: —
CURRENCYCODE: —
CUTOVER_WAVE: Customer-006
FORMATREGION: —
LANGUAGECODE: —
CUSTOMER_NAME: Customer Secondary
Credit Rating: —
CREDITLIMITLCY: —
PRINTSTATEMENTS: —
SALESPERSONCODE: —
COMBINESHIPMENTS: —
DEPENDENCY_LEVEL: MEDIUM-ALT
PAYMENTTERMSCODE: —
APPLICATIONMETHOD: —
EFFECTIVE_TO_DATE: 2026-01-12
PAYMENTMETHODCODE: —
REMINDERTERMSCODE: —
SHIPPINGAGENTCODE: —
VATREGISTRATIONNO: —
CUSTOMER_SOURCE_ID: LEG-CUSTOMER-002
GENBUSPOSTINGGROUP: —
SHIPMENTMETHODCODE: —
VATBUSPOSTINGGROUP: —
Country/Region Code: —
EFFECTIVE_FROM_DATE: 2026-01-11
LOAD_SEQUENCE_STAGE: Master Data
CUSTOMERPOSTINGGROUP: —
CUSTOMER_DESCRIPTION: Customer: Alternate source profile
CUSTOMER_STATUS_CODE: PENDING
CUSTOMER_ATTRIBUTE_01: Customer-012-ALT
CUSTOMER_ATTRIBUTE_02: Customer-013-ALT
CUSTOMER_BUSINESS_KEY: ALT-CUSTOMER-002
CUSTOMER_REFERENCE_KEY: ALT-CUSTOMER-002
MAPTOINTEGRATIONCODEKPSD: —
SHIPPINGAGENTSERVICECODE: —
Business Development Manager Code: —

default

CITY: —
Name: —
EMAIL: —
COUNTY: —
ADDRESS: —
Blocked: —
CONTACT: —
Column1: —
PHONENO: —
ADDRESS2: —
POSTCODE: —
BDMCODEKPSD: —
Search Name: —
CURRENCYCODE: —
CUTOVER_WAVE: Customer-006
FORMATREGION: —
LANGUAGECODE: —
CUSTOMER_NAME: Customer Legacy
Credit Rating: —
CREDITLIMITLCY: —
PRINTSTATEMENTS: —
SALESPERSONCODE: —
COMBINESHIPMENTS: —
DEPENDENCY_LEVEL: Customer-007
PAYMENTTERMSCODE: —
APPLICATIONMETHOD: —
EFFECTIVE_TO_DATE: 2026-01-13
PAYMENTMETHODCODE: —
REMINDERTERMSCODE: —
SHIPPINGAGENTCODE: —
VATREGISTRATIONNO: —
CUSTOMER_SOURCE_ID: EXT-CUSTOMER-003
GENBUSPOSTINGGROUP: —
SHIPMENTMETHODCODE: —
VATBUSPOSTINGGROUP: —
Country/Region Code: —
EFFECTIVE_FROM_DATE: 2026-01-12
LOAD_SEQUENCE_STAGE: Master Data
CUSTOMERPOSTINGGROUP: —
CUSTOMER_DESCRIPTION: —
CUSTOMER_STATUS_CODE: HOLD
CUSTOMER_ATTRIBUTE_01: —
CUSTOMER_ATTRIBUTE_02: —
CUSTOMER_BUSINESS_KEY: EDGE-CUSTOMER-003
CUSTOMER_REFERENCE_KEY: —
MAPTOINTEGRATIONCODEKPSD: —
SHIPPINGAGENTSERVICECODE: —
Business Development Manager Code: —

Rule Validation Summary

Source Rule Count: 15
Governed Rule Count: 15

All objects