Customer Contacts
In ScopeTechnical: customer_contacts | ID: D365BC-CORE-CUSTOMER_CONTACTS
D365 BC migration object for Customer Contacts.
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
- ERPLegacyLegacy CRMSpreadsheetSales & Marketing Automation
Classification
- Information Type
- Master Data
Target Structure
- Load Approach
- Table
- Target Objects
- Contact
Field Definitions(5)
Rules & Considerations(16)
Sample Load Data(4)
| _scenario | NameR | City | Type | County | Address | Surname | Address 2 | Home Page | Post Code | First Name | No. Series | Middle Name | Search Name | CUTOVER_WAVE | Company Name | Search Email | Salutation Code | DEPENDENCY_LEVEL | Salesperson Code | EFFECTIVE_TO_DATE | Correspondence Type | EFFECTIVE_FROM_DATE | LOAD_SEQUENCE_STAGE | CONTACT_REFERENCE_KEY | CONTACTS_REFERENCE_KEY | CUSTOMER_CONTACTS_NAME | CUSTOMER_REFERENCE_KEY | Contact Business Relation | CUSTOMER_CONTACTS_SOURCE_ID | CUSTOMER_CONTACTS_DESCRIPTION | CUSTOMER_CONTACTS_STATUS_CODE | CUSTOMER_CONTACTS_BUSINESS_KEY | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | Name | Boston | Person | Middlesex County | 123 Main Street | Smith | Suite 200 | https://www.acmecorp.com | 02101 | John | CON0 | A. | SMITHJOHN | Customer Contacts-006 | Acme Corporation | john.smith | MR | Customer Contacts-007 | 15 | 2026-01-13 | 2026-01-12 | Master Data | STD-CUSTOMER_C-001 | STD-CUSTOMER_C-001 | Customer Contacts Primary | STD-CUSTOMER_C-001 | CUSTOMER | SRC-CUSTOMER_C-001 | Customer Contacts: Baseline migration row | ACTIVE | BK-CUSTOMER_CON-001 | ||
| default | — | — | — | — | — | — | — | — | — | — | — | — | — | — | Customer Contacts-006 | — | — | — | MEDIUM-ALT | — | 2026-01-14 | — | 2026-01-13 | Master Data | ALT-CUSTOMER_C-002 | ALT-CUSTOMER_C-002 | Customer Contacts Secondary | ALT-CUSTOMER_C-002 | — | LEG-CUSTOMER_C-002 | Customer Contacts: Alternate source profile | PENDING | ALT-CUSTOMER_CON-002 |
| default | — | — | — | — | — | — | — | — | — | — | — | — | — | — | Customer Contacts-006 | — | — | — | Customer Contacts-007 | — | 2026-01-15 | — | 2026-01-14 | Master Data | — | — | Customer Contacts Legacy | — | — | EXT-CUSTOMER_C-003 | — | HOLD | EDGE-CUSTOMER_CON-003 |
Example values from field definitions
- NameR
- Name
- City
- Boston
- Type
- Person
- County
- Middlesex County
- Address
- 123 Main Street
- Surname
- Smith
- Address 2
- Suite 200
- Home Page
- https://www.acmecorp.com
- Post Code
- 02101
- First Name
- John
- No. Series
- CON0
- Middle Name
- A.
- Search Name
- SMITHJOHN
- CUTOVER_WAVE
- Customer Contacts-006
- Company Name
- Acme Corporation
- Search Email
- john.smith
- Salutation Code
- MR
- DEPENDENCY_LEVEL
- Customer Contacts-007
- Salesperson Code
- 15
- EFFECTIVE_TO_DATE
- 2026-01-13
- Correspondence Type
- EFFECTIVE_FROM_DATE
- 2026-01-12
- LOAD_SEQUENCE_STAGE
- Master Data
- CONTACT_REFERENCE_KEY
- STD-CUSTOMER_C-001
- CONTACTS_REFERENCE_KEY
- STD-CUSTOMER_C-001
- CUSTOMER_CONTACTS_NAME
- Customer Contacts Primary
- CUSTOMER_REFERENCE_KEY
- STD-CUSTOMER_C-001
- Contact Business Relation
- CUSTOMER
- CUSTOMER_CONTACTS_SOURCE_ID
- SRC-CUSTOMER_C-001
- CUSTOMER_CONTACTS_DESCRIPTION
- Customer Contacts: Baseline migration row
- CUSTOMER_CONTACTS_STATUS_CODE
- ACTIVE
- CUSTOMER_CONTACTS_BUSINESS_KEY
- BK-CUSTOMER_CON-001
default
- NameR
- —
- City
- —
- Type
- —
- County
- —
- —
- Address
- —
- Surname
- —
- Address 2
- —
- Home Page
- —
- Post Code
- —
- First Name
- —
- No. Series
- —
- Middle Name
- —
- Search Name
- —
- CUTOVER_WAVE
- Customer Contacts-006
- Company Name
- —
- Search Email
- —
- Salutation Code
- —
- DEPENDENCY_LEVEL
- MEDIUM-ALT
- Salesperson Code
- —
- EFFECTIVE_TO_DATE
- 2026-01-14
- Correspondence Type
- —
- EFFECTIVE_FROM_DATE
- 2026-01-13
- LOAD_SEQUENCE_STAGE
- Master Data
- CONTACT_REFERENCE_KEY
- ALT-CUSTOMER_C-002
- CONTACTS_REFERENCE_KEY
- ALT-CUSTOMER_C-002
- CUSTOMER_CONTACTS_NAME
- Customer Contacts Secondary
- CUSTOMER_REFERENCE_KEY
- ALT-CUSTOMER_C-002
- Contact Business Relation
- —
- CUSTOMER_CONTACTS_SOURCE_ID
- LEG-CUSTOMER_C-002
- CUSTOMER_CONTACTS_DESCRIPTION
- Customer Contacts: Alternate source profile
- CUSTOMER_CONTACTS_STATUS_CODE
- PENDING
- CUSTOMER_CONTACTS_BUSINESS_KEY
- ALT-CUSTOMER_CON-002
default
- NameR
- —
- City
- —
- Type
- —
- County
- —
- —
- Address
- —
- Surname
- —
- Address 2
- —
- Home Page
- —
- Post Code
- —
- First Name
- —
- No. Series
- —
- Middle Name
- —
- Search Name
- —
- CUTOVER_WAVE
- Customer Contacts-006
- Company Name
- —
- Search Email
- —
- Salutation Code
- —
- DEPENDENCY_LEVEL
- Customer Contacts-007
- Salesperson Code
- —
- EFFECTIVE_TO_DATE
- 2026-01-15
- Correspondence Type
- —
- EFFECTIVE_FROM_DATE
- 2026-01-14
- LOAD_SEQUENCE_STAGE
- Master Data
- CONTACT_REFERENCE_KEY
- —
- CONTACTS_REFERENCE_KEY
- —
- CUSTOMER_CONTACTS_NAME
- Customer Contacts Legacy
- CUSTOMER_REFERENCE_KEY
- —
- Contact Business Relation
- —
- CUSTOMER_CONTACTS_SOURCE_ID
- EXT-CUSTOMER_C-003
- CUSTOMER_CONTACTS_DESCRIPTION
- —
- CUSTOMER_CONTACTS_STATUS_CODE
- HOLD
- CUSTOMER_CONTACTS_BUSINESS_KEY
- EDGE-CUSTOMER_CON-003
Rule Validation Summary
- Source Rule Count
- 16
- Governed Rule Count
- 16