Tableau Connector for Salesforce

Build 25.0.9434

ContactPointPhone

Schema file for ContactPointPhone.

Columns

Name Type ReadOnly References Description
Id [KEY] String True

Unique identifier for the record.

OwnerId String False

ID of the user who owns the record.

OwnerIdType String False

Specifies the type of the 'OwnerId' polymorphic field to use in the statement.

OwnerIdExternalFieldName String False

Specifies the external field name of the 'OwnerId' polymorphic field to use in an INSERT/UPDATE/UPSERT statement

IsDeleted Bool True

Indicates whether the record has been moved to the Recycle Bin.

Name String True

Name of the record.

CreatedDate Datetime True

Date and time when the record was created.

CreatedById String True

User.Id

ID of the user who created the record.

LastModifiedById String True

User.Id

ID of the user who last modified the record.

LastViewedDate Datetime True

Date and time when the record was last viewed in the user interface.

LastReferencedDate Datetime True

Date and time when the record was last referenced.

ParentId String False

ID of the parent object in the hierarchy.

ParentIdType String False

Specifies the type of the 'ParentId' polymorphic field to use in the statement.

ParentIdExternalFieldName String False

Specifies the external field name of the 'ParentId' polymorphic field to use in an INSERT/UPDATE/UPSERT statement

ActiveFromDate Date False

Date associated with ActiveFrom.

ActiveToDate Date False

Date associated with ActiveTo.

BestTimeToContactEndTime Time False

Field containing BestTimeToContactEndTime information.

BestTimeToContactStartTime Time False

Field containing BestTimeToContactStartTime information.

BestTimeToContactTimezone String False

Field containing BestTimeToContactTimezone information.

IsPrimary Bool False

Indicates whether the record has the Primary characteristic.

AreaCode String False

Field containing AreaCode information.

TelephoneNumber String False

Telephone identification number.

ExtensionNumber String False

Extension identification number.

PhoneType String False

Type classification for Phone.

IsSmsCapable Bool False

Indicates whether the record has the SmsCapable characteristic.

FormattedInternationalPhoneNumber String False

FormattedInternationalPhone identification number.

FormattedNationalPhoneNumber String False

FormattedNationalPhone identification number.

IsFaxCapable Bool False

Indicates whether the record has the FaxCapable characteristic.

IsPersonalPhone Bool False

Indicates whether the record has the PersonalPhone characteristic.

IsBusinessPhone Bool False

Indicates whether the record has the BusinessPhone characteristic.

PreferenceRank Int False

Field containing PreferenceRank information.

UsageType String False

Type classification for Usage.

SOQL String False

Specifies the SOQL query to execute against the Salesforce servers. If this pseudo column is set from the WHERE clause it will take precedence over the original query.

ExternalIdColumn String False

Specifies the external Id column to use if performing an insert. If this value is specified, upsert will be used when the INSERT command is called.

FilterScope String False

Optional scope to limit the records returned from queries. This property can take one of these values: Delegated, Everything, Mine, MineAndMyGroups, My_Territory, My_Team_Territory, or Team.

SystemModstamp Datetime True

Date and time when the record was last modified by a user or by an automated process.

LastModifiedDate Datetime True

Date and time when the record was last modified.

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