ODBC Driver for Salesforce Data Cloud

Build 24.0.9175

ContactPointEmail

The Contact Point Email DMO is a Data Cloud data model object for theemail address of a party. Provided in both the Sales and Service Data Kits.

Columns

Name Type References Description
Active From Date Datetime The date the email address is active.
Active To Date Datetime The date the email address is inactive.
Best Time To Contact End Time Datetime A contact’s preferred date and time to stop receivingemails.
Best Time To Contact Start Time Datetime A contact’s preferred date and time to startreceiving emails.
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.
Contact Point Email Id Varchar A unique ID used as the primary key for the contact point emailDMO.
Contact Point Type Varchar A reference ID for the type of email, for example business orpersonal.
Created Date Datetime The date when the record was created.
Data Source Varchar A reference ID for the logical name for a system that is thesource of records identified by external record ID.
Data Source Object Varchar A reference ID for the logical name of the object where thisrecord came from, whether that is a name of a cloud storage file oranother connector’s external object.
Email Address Varchar The contact’s full email address.
Email Domain Varchar The domain of an email address, for example salesforce.com orgmail.com.
Email Latest Bounce Date Time Datetime The date of the most recent email bounce.
Email Latest Bounce Reason text Varchar The reason the email bounced, for example the mailbox wasfull.
Email Mail Box Varchar The specific unique mailbox found before the domain, for examplejanedoe@.
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 email address is used for business use.
For Personal Use Varchar An indicator if the email address is used for personal use.
Internal Organization Varchar A reference ID to the business unit or other internalorganization that owns the business account.
Is Active Varchar An indicator if the email address is active.
Is Undeliverable Varchar An indicator if the email address is undeliverable.
Is Verified Varchar Indicates whether the email address is verified.
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.
Party Role Varchar A reference ID to the associated party role, for example, acustomer, supplier, or competitor.
Preference Rank Double The preference rank number for the contact point email.
Primary Flag Varchar An indicator if the email address is the primary email address ofthe individual 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
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.
Verified Varchar An indicator if this contact point email is verified.

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