Power BI Connector for Salesforce Data Cloud

Build 24.0.9175

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.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175