ContactPointPhone
The Contact Point Phone data model object (DMO) is a Data Cloud DMO forthe phone number of a party. Provided in both the Sales and Service Data Kits.
Columns
Name | Type | References | Description |
Active From Date | Datetime | The date the phone number is active. | |
Active To Date | Datetime | The date the phone number is inactive. | |
Area Code | Varchar | A phone number’s area code. | |
Best Time To Contact End Time | Datetime | A contact’s preferred date and time to stop receivingcalls. | |
Best Time To Contact Start Time | Datetime | A contact’s preferred date and time to start receiving calls. | |
Best Time to Contact Timezone | Varchar | The preferred timezone for the contact | |
Best Time to Contact Timezone | Varchar | A reference ID for the contact’s preferred time zone. | |
City Name | Varchar | The city related to the phone number. | |
Contact Point Phone ID | Varchar | A unique ID used as the primary key for the contact point phoneDMO. | |
Contact Point Type | Varchar | A reference ID for the type of phone number, for example businessor personal. | |
Country | Varchar | A reference ID for the country related to the phonenumber. | |
Country Name | Varchar | The country related to the phone number. | |
Created Date | Datetime | The record’s creation date. | |
Data Source | Varchar | A reference ID for the system’s logical name that is the sourceof records identified by an external record ID. | |
Data Source Object | Varchar | A reference ID for the logical name of the object where thisrecord originated, whether that is a name of a cloud storage file oranother connector’s external object. | |
Device | Varchar | A unique ID of the device where the phone number isassociated. | |
Extension number | Varchar | An associated phone extension. | |
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 | An indicator if the phone number is used for business use. | |
For Personal Use | Varchar | An indicator if the phone number is used for personal use. | |
Formatted E164 Phone number | Varchar | The number that is formatted according to e164 formatting, forexample, +165012345678. | |
Formatted International Phone number | Varchar | The number that is formatted according to internationalformatting, for example, +16 501-234-5678. | |
Formatted National Phone number | Varchar | The number that is formatted according to 3123 formatting, forexample, 501 234 5678. | |
Internal Organization | Varchar | A reference ID for the business unit or other internalorganization that owns the business account. | |
Is Active | Varchar | Whether the phone number is active. | |
Is Fax Capable | Varchar | Whether the phone number can receive a fax. | |
Is SMS Capable | Varchar | Whether the phone number can send and receive SMS messages. | |
Is Undeliverable | Varchar | Whether the phone number isn’t working. | |
Is Verified | Varchar | Indicates whether the phone number is verified. | |
Is Voice Capable | Varchar | Whether the phone number is voice over internet protocol (VOIP)capable. | |
Last Modified Date | Datetime | The date when a user last modified the record. | |
Party | Varchar | A reference ID for 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 for the associated party role, for example, acustomer, supplier, or competitor. | |
Phone Country Code | Varchar | The phone number’s country code, for example, +1. | |
Preference Rank | Double | The preference rank number for the contact point phone. | |
Postal Code text | Varchar | The contact’s postal code. | |
Primary Flag | Varchar | Whether a phone number is the primary number of the individual oraccount. | |
Primary Phone Type | Varchar | The type of phone number, for example home, business, orfax. | |
Profile First Created Date | Datetime | The profile’s creation date. | |
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. | |
Short Code | Varchar | A number assigned to SMS and MMS messages. | |
State Province text | Varchar | The contact’s state or province. | |
Phone number | Varchar | The contact’s phone number. | |
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 email. |