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(65)

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

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

Rule Validation Summary

Source Rule Count: 15
Governed Rule Count: 15

Customer | core master data | D365 Bc