Customers
In ScopeTechnical: CustTable | ID: D365FO-CUS-CUSTTABLE-CUSTOMERS
See how this object fits into Customers
Review the broader sequencing and dependencies for this domain
Migration Details
- Complexity
- Medium
- Sequencing
- Stage 2 - Dependent Master Data
- Typical Sources
- ERPLegacy
Classification
- Object Type
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- CustTable
Field Definitions(5)
Sample Load Data(4)
| _scenario | ADDRESSCITYR | ADDRESSSTREETR | ADDRESSZIPCODER | ADDRESSCOUNTRYREGIONIDR | VATNUM | BLOCKED | LANGUAGEID | CREDITLIMIT | PARTYNUMBER | WAREHOUSEID | ADDRESSSTATE | CURRENCYCODE | CUSTOMERTYPE | FEDERALTAXID | PAYMENTTERMS | CUSTOMERGROUP | PAYMENTMETHOD | SALESTAXGROUP | DELIVERYMODEID | FREIGHTTERMSID | ISPUBLICSECTOR | CUSTOMERACCOUNT | DELIVERYTERMSID | ORGANIZATIONNAME | ADDRESSDESCRIPTION | PRIMARYCONTACTEMAIL | PRIMARYCONTACTPHONE | NUMBERSEQUENCEGROUPID | CREDITMANAGEMENTBLOCKED | DEFAULTDIMENSIONDISPLAYVALUE | PERSONLASTNAME | PERSONFIRSTNAME | TAXEXEMPTNUMBER | CREDITMANAGEMENTRISKGROUPID |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | Seattle | 123 Main Street | 98101 | USA | — | No | en-us | 100000.0 | P-000001 | WH100 | WA | USD | Organization | 11-2222222 | NET30 | CORPORATE | BANK | US-WA | TRUCK | COLLECT | No | US-001 | FOB | Contoso Inc. | Headquarters | sales@contoso.com | +1 (206) 555-1234 | CUST_NSG | None | Department-Sales:CostCenter-CC001 | — | — | — | — |
| Individual Customer with Special Terms | Berlin | Hauptstr. 10 | 10115 | DEU | DE987654321 | No | de | 5000 | P-000002 | WH200 | — | EUR | Person | — | CASH | INDIVIDUAL | CREDITCARD | EU-DE | PICKUP | PREPAID | No | EU-P002 | EXW | — | Home Address | anna.schmidt@email.com | +49 (30) 123-45678 | — | None | — | Schmidt | Anna | — | MEDIUM |
| Blocked Customer | Los Angeles | 456 Oak Ave | 90001 | USA | — | All | en-us | 0 | P-000003 | WH100 | CA | USD | Organization | 33-4444444 | NET30 | RETAIL | CHECK | US-CA | PARCEL | COLLECT | No | US-BL03 | FOB | Acme Corp. | Previous Address | info@acmecorp.com | +1 (213) 987-6543 | — | All | — | — | — | — | — |
Example values from field definitions
- ADDRESSCITYR
- Seattle
- ADDRESSSTREETR
- 123 Main Street
- ADDRESSZIPCODER
- 98101
- ADDRESSCOUNTRYREGIONIDR
- USA
- VATNUM
- —
- BLOCKED
- No
- LANGUAGEID
- en-us
- CREDITLIMIT
- 100000.0
- PARTYNUMBER
- P-000001
- WAREHOUSEID
- WH100
- ADDRESSSTATE
- WA
- CURRENCYCODE
- USD
- CUSTOMERTYPE
- Organization
- FEDERALTAXID
- 11-2222222
- PAYMENTTERMS
- NET30
- CUSTOMERGROUP
- CORPORATE
- PAYMENTMETHOD
- BANK
- SALESTAXGROUP
- US-WA
- DELIVERYMODEID
- TRUCK
- FREIGHTTERMSID
- COLLECT
- ISPUBLICSECTOR
- No
- CUSTOMERACCOUNT
- US-001
- DELIVERYTERMSID
- FOB
- ORGANIZATIONNAME
- Contoso Inc.
- ADDRESSDESCRIPTION
- Headquarters
- PRIMARYCONTACTEMAIL
- sales@contoso.com
- PRIMARYCONTACTPHONE
- +1 (206) 555-1234
- NUMBERSEQUENCEGROUPID
- CUST_NSG
- CREDITMANAGEMENTBLOCKED
- None
- DEFAULTDIMENSIONDISPLAYVALUE
- Department-Sales:CostCenter-CC001
- PERSONLASTNAME
- —
- PERSONFIRSTNAME
- —
- TAXEXEMPTNUMBER
- —
- CREDITMANAGEMENTRISKGROUPID
- —
Individual Customer with Special Terms
- ADDRESSCITYR
- Berlin
- ADDRESSSTREETR
- Hauptstr. 10
- ADDRESSZIPCODER
- 10115
- ADDRESSCOUNTRYREGIONIDR
- DEU
- VATNUM
- DE987654321
- BLOCKED
- No
- LANGUAGEID
- de
- CREDITLIMIT
- 5000
- PARTYNUMBER
- P-000002
- WAREHOUSEID
- WH200
- ADDRESSSTATE
- —
- CURRENCYCODE
- EUR
- CUSTOMERTYPE
- Person
- FEDERALTAXID
- —
- PAYMENTTERMS
- CASH
- CUSTOMERGROUP
- INDIVIDUAL
- PAYMENTMETHOD
- CREDITCARD
- SALESTAXGROUP
- EU-DE
- DELIVERYMODEID
- PICKUP
- FREIGHTTERMSID
- PREPAID
- ISPUBLICSECTOR
- No
- CUSTOMERACCOUNT
- EU-P002
- DELIVERYTERMSID
- EXW
- ORGANIZATIONNAME
- —
- ADDRESSDESCRIPTION
- Home Address
- PRIMARYCONTACTEMAIL
- anna.schmidt@email.com
- PRIMARYCONTACTPHONE
- +49 (30) 123-45678
- NUMBERSEQUENCEGROUPID
- —
- CREDITMANAGEMENTBLOCKED
- None
- DEFAULTDIMENSIONDISPLAYVALUE
- —
- PERSONLASTNAME
- Schmidt
- PERSONFIRSTNAME
- Anna
- TAXEXEMPTNUMBER
- —
- CREDITMANAGEMENTRISKGROUPID
- MEDIUM
Blocked Customer
- ADDRESSCITYR
- Los Angeles
- ADDRESSSTREETR
- 456 Oak Ave
- ADDRESSZIPCODER
- 90001
- ADDRESSCOUNTRYREGIONIDR
- USA
- VATNUM
- —
- BLOCKED
- All
- LANGUAGEID
- en-us
- CREDITLIMIT
- 0
- PARTYNUMBER
- P-000003
- WAREHOUSEID
- WH100
- ADDRESSSTATE
- CA
- CURRENCYCODE
- USD
- CUSTOMERTYPE
- Organization
- FEDERALTAXID
- 33-4444444
- PAYMENTTERMS
- NET30
- CUSTOMERGROUP
- RETAIL
- PAYMENTMETHOD
- CHECK
- SALESTAXGROUP
- US-CA
- DELIVERYMODEID
- PARCEL
- FREIGHTTERMSID
- COLLECT
- ISPUBLICSECTOR
- No
- CUSTOMERACCOUNT
- US-BL03
- DELIVERYTERMSID
- FOB
- ORGANIZATIONNAME
- Acme Corp.
- ADDRESSDESCRIPTION
- Previous Address
- PRIMARYCONTACTEMAIL
- info@acmecorp.com
- PRIMARYCONTACTPHONE
- +1 (213) 987-6543
- NUMBERSEQUENCEGROUPID
- —
- CREDITMANAGEMENTBLOCKED
- All
- DEFAULTDIMENSIONDISPLAYVALUE
- —
- PERSONLASTNAME
- —
- PERSONFIRSTNAME
- —
- TAXEXEMPTNUMBER
- —
- CREDITMANAGEMENTRISKGROUPID
- —
Rule Validation Summary
- Source Rule Count
- 197
- Governed Rule Count
- 197