Power BI Connector for Salesforce Data Cloud

Build 24.0.9175

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.

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