ContactPointAddress
The Contact Point Address data model object (DMO) is a Data CloudDMObased on the mailing address of a party. Provided in both the Sales and Service DataKits.
Columns
Name | Type | References | Description |
Active From Date | Datetime | The date from which the contact’s address is active. | |
Active To Date | Datetime | The date the contact’s address becomes inactive. | |
Address | Varchar | A reference ID for the contact’s address. | |
Address Line 1 | Varchar | The first line of the address, including the street name andnumber. | |
Address Line 2 | Varchar | The second line of an address, for example, a suitenumber. | |
Address Line 3 | Varchar | The third line of an address. | |
Address Line 4 | Varchar | The fourth line of an address. | |
Best Time To Contact End Time | Datetime | A contact’s preferred date and time to stop receivingcommunication. | |
Best Time To Contact Start Time | Datetime | A contact’s preferred date and time to start receivingcommunication. | |
Best Time to Contact Timezone | Varchar | A reference ID to the contact’s preferred time zone. | |
City | Varchar | The reference ID of a city, town, or village. | |
City Name | Varchar | The name of a city, town, or village. | |
Contact Point Address ID | Varchar | A unique ID used as the primary key for the contact point addressDMO. | |
Contact Point Type | Varchar | A reference ID to the contact type. | |
Country | Varchar | The reference ID of the country where the address is located. | |
Country Name | Varchar | The country where the address is located. | |
Country Region | Varchar | A reference ID for the country or region where the address islocated. | |
Created Date | Datetime | The record’s creation date. | |
Data Source | Varchar | A reference ID for the logical name of a system that is thesource of records identified byanexternal record ID. | |
Data Source Object | Varchar | A reference ID for the logical name of the object where thisrecord came from, for example, a name of a cloud storage file oranother connector’s external object. | |
External Record ID | Varchar | A reference ID for an external data source system. | |
External Source ID | Varchar | A reference ID for the system in which the external record ID wasassigned. | |
For Business Use | Varchar | Whether the address is for business use. | |
For Personal Use | Varchar | Whether the address is for personal use. | |
Geo Accuracy | Double | Additional information about an address’ latitude andlongitude. | |
Geocode Accuracy Type | Double | The geographic code accuracy type for the contact point. | |
Geo Latitude | Double | The address’ geographical latitude. | |
Geo Longitude | Double | The address’ geographical longitude. | |
Internal Organization | Varchar | A reference ID for the business unit or other internalorganization that owns the business account. | |
Is Active | Varchar | Whether the address is active. | |
Is Undeliverable | Varchar | Whether the address is undeliverable. | |
Is Used For Billing | Varchar | Whether the address is the contact’s billing address. | |
Is Used For Mailing | Varchar | Whether the contact point address can be used formailing. | |
Is Used For Shipping | Varchar | Whether the address is the contact’s shipping address. | |
Last Modified Date | Datetime | The date when a user last modified the record. | |
Party | Varchar | A reference ID to the parent party, for example, an individual,business, or affiliation group. This ID is the same as the oneused in the individual object. | |
Party Role | Varchar | A reference ID to the associated party role, for example, acustomer, supplier, or competitor. | |
Physical Location | Varchar | A reference ID to the physical location of the address. | |
Postal Code | Varchar | The reference ID for the postal code. | |
Postal Code text | Varchar | The contact’s postal code. | |
Preference Rank | Double | The preference rank number for the contact point address. | |
Primary Contact Phone | Varchar | A reference ID for the primary phone number for thisaddress. | |
Primary Flag | Varchar | Indicates whether the address is the primary address of theindividual or account. | |
Profile First Created Date | Datetime | The date the profile was created. | |
Profile Last Updated Date | Datetime | The date the profile was last updated. | |
Profile Occurrence Count | Double | The number of occurrences of the profile for the contact pointaddress. | |
State Province | Varchar | The reference ID for the state or province where the address islocated. | |
State Province Name | Varchar | The state or province where the address is located. | |
Timezone Code | Varchar | A single-character code indicating the time zone’s relationshipto Greenwich Mean Time (GMT). | |
Usage Type | Varchar | The usage type for the contact point address. |