Customer Addresses
In ScopeTechnical: CustTableAddresses | ID: D365FO-CUS-CUSTTABLEADDRESSES-CUSTOMER_ADDRESSES
See how this object fits into Customers
Review the broader sequencing and dependencies for this domain
Migration Details
- Complexity
- Low
- Sequencing
- Stage 2 - Dependent Master Data
- Typical Sources
- ERPLegacy
Classification
- Object Type
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- CustTableAddresses
Field Definitions(5)
Rules & Considerations(44)
Sample Load Data(4)
| _scenario | ISPRIMARYR | ISPRIVATER | ISPOSTALADDRESSR | ISPRIVATEPOSTALADDRESSR | CITY | ROLES | STATE | COUNTY | STREET | ADDRESS | POSTBOX | VALIDTO | ZIPCODE | LATITUDE | TIMEZONE | LONGITUDE | VALIDFROM | DUNSNUMBER | ISROLEHOME | LOCATIONID | DESCRIPTION | PARTYNUMBER | DISTRICTNAME | STREETNUMBER | ISROLEINVOICE | ISROLEBUSINESS | ISROLEDELIVERY | COUNTRYREGIONID | ISLOCATIONOWNER | BUILDINGCOMPLIMENT | COUNTRYREGIONISOCODE | ATTENTIONTOADDRESSLINE |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 0 | 1 | 0 | Seattle | Invoice,Delivery | WA | King County | 1 Microsoft Way | 123 Main St, New York, NY 10001, USA | P.O. Box 12345 | 2024-12-31 23:59:59 | 98101 | 34.0522 | GMT-08:00 Pacific Time (US & Canada) | -118.2437 | 2020-01-01 00:00:00 | 123456789 | 0 | LOC-0001 | Main Office | C0001 | Midtown East | 42 | 1 | 1 | 1 | USA | 1 | Suite 500 | US | Attn: Order Fulfillment |
| Closed historical record – expired validity, secondary address for former UK customer no longer trading | 0 | 0 | 1 | 0 | TEATTLE | Delivery | XA | Greater London | 27 Brompton Road | 27 Brompton Road, London, SW3 2BB, United Kingdom | 2022-03-31 23:59:59 | 98101 | 51.4994 | GMT Standard Time | -0.1647 | 2015-04-01 00:00:00 | 0 | LOC-UK-HIST | Former London showroom | C0001 | Kensington | 27 | 0 | 0 | 1 | GBR | 0 | 1st Floor | GB | |||
| Minimal new address – only mandatory fields populated for a freshly-created Canadian customer | 1 | — | — | — | Toronto | Business | ON | — | 100 King St W | — | — | 2024123123595903 | 98102 | — | — | — | 2024-06-01 00:00:00 | 123456703 | — | LOC-CA-NEW | — | C0002 | MIDTOWNEAS03 | 03 | — | — | — | CAN | — | — | CA | — |
Example values from field definitions
- ISPRIMARYR
- 1
- ISPRIVATER
- 0
- ISPOSTALADDRESSR
- 1
- ISPRIVATEPOSTALADDRESSR
- 0
- CITY
- Seattle
- ROLES
- Invoice,Delivery
- STATE
- WA
- COUNTY
- King County
- STREET
- 1 Microsoft Way
- ADDRESS
- 123 Main St, New York, NY 10001, USA
- POSTBOX
- P.O. Box 12345
- VALIDTO
- 2024-12-31 23:59:59
- ZIPCODE
- 98101
- LATITUDE
- 34.0522
- TIMEZONE
- GMT-08:00 Pacific Time (US & Canada)
- LONGITUDE
- -118.2437
- VALIDFROM
- 2020-01-01 00:00:00
- DUNSNUMBER
- 123456789
- ISROLEHOME
- 0
- LOCATIONID
- LOC-0001
- DESCRIPTION
- Main Office
- PARTYNUMBER
- C0001
- DISTRICTNAME
- Midtown East
- STREETNUMBER
- 42
- ISROLEINVOICE
- 1
- ISROLEBUSINESS
- 1
- ISROLEDELIVERY
- 1
- COUNTRYREGIONID
- USA
- ISLOCATIONOWNER
- 1
- BUILDINGCOMPLIMENT
- Suite 500
- COUNTRYREGIONISOCODE
- US
- ATTENTIONTOADDRESSLINE
- Attn: Order Fulfillment
Closed historical record – expired validity, secondary address for former UK customer no longer trading
- ISPRIMARYR
- 0
- ISPRIVATER
- 0
- ISPOSTALADDRESSR
- 1
- ISPRIVATEPOSTALADDRESSR
- 0
- CITY
- TEATTLE
- ROLES
- Delivery
- STATE
- XA
- COUNTY
- Greater London
- STREET
- 27 Brompton Road
- ADDRESS
- 27 Brompton Road, London, SW3 2BB, United Kingdom
- POSTBOX
- VALIDTO
- 2022-03-31 23:59:59
- ZIPCODE
- 98101
- LATITUDE
- 51.4994
- TIMEZONE
- GMT Standard Time
- LONGITUDE
- -0.1647
- VALIDFROM
- 2015-04-01 00:00:00
- DUNSNUMBER
- ISROLEHOME
- 0
- LOCATIONID
- LOC-UK-HIST
- DESCRIPTION
- Former London showroom
- PARTYNUMBER
- C0001
- DISTRICTNAME
- Kensington
- STREETNUMBER
- 27
- ISROLEINVOICE
- 0
- ISROLEBUSINESS
- 0
- ISROLEDELIVERY
- 1
- COUNTRYREGIONID
- GBR
- ISLOCATIONOWNER
- 0
- BUILDINGCOMPLIMENT
- 1st Floor
- COUNTRYREGIONISOCODE
- GB
- ATTENTIONTOADDRESSLINE
Minimal new address – only mandatory fields populated for a freshly-created Canadian customer
- ISPRIMARYR
- 1
- ISPRIVATER
- —
- ISPOSTALADDRESSR
- —
- ISPRIVATEPOSTALADDRESSR
- —
- CITY
- Toronto
- ROLES
- Business
- STATE
- ON
- COUNTY
- —
- STREET
- 100 King St W
- ADDRESS
- —
- POSTBOX
- —
- VALIDTO
- 2024123123595903
- ZIPCODE
- 98102
- LATITUDE
- —
- TIMEZONE
- —
- LONGITUDE
- —
- VALIDFROM
- 2024-06-01 00:00:00
- DUNSNUMBER
- 123456703
- ISROLEHOME
- —
- LOCATIONID
- LOC-CA-NEW
- DESCRIPTION
- —
- PARTYNUMBER
- C0002
- DISTRICTNAME
- MIDTOWNEAS03
- STREETNUMBER
- 03
- ISROLEINVOICE
- —
- ISROLEBUSINESS
- —
- ISROLEDELIVERY
- —
- COUNTRYREGIONID
- CAN
- ISLOCATIONOWNER
- —
- BUILDINGCOMPLIMENT
- —
- COUNTRYREGIONISOCODE
- CA
- ATTENTIONTOADDRESSLINE
- —
Rule Validation Summary
- Source Rule Count
- 44
- Governed Rule Count
- 44