Tableau Connector for Certinia

Build 23.0.8839

OpenActivity

This is a table representing the OpenActivity entities in FinancialForce.

Columns

Name Type ReadOnly References Description
Id [KEY] System.String True

Label 'Activity ID' corresponds to this field.

AccountId System.String True

Label 'Account ID' corresponds to this field.

WhoId System.String True

Label 'Contact/Lead ID' corresponds to this field.

WhatId System.String True

Label 'Opportunity/Account ID' corresponds to this field.

Subject System.String True

Label 'Subject' corresponds to this field.

IsTask System.Boolean True

Label 'Task' corresponds to this field.

ActivityDate System.String True

Label 'Date' corresponds to this field.

OwnerId System.String True

Label 'Assigned To ID' corresponds to this field.

Status System.String True

Label 'Status' corresponds to this field.

Priority System.String True

Label 'Priority' corresponds to this field.

ActivityType System.String True

Label 'Type' corresponds to this field.

IsClosed System.Boolean True

Label 'Closed' corresponds to this field.

IsAllDayEvent System.Boolean True

Label 'All Day Event' corresponds to this field.

DurationInMinutes System.Integer True

Label 'Duration' corresponds to this field.

Location System.String True

Label 'Location' corresponds to this field.

Description System.String True

Label 'Comments' corresponds to this field.

IsDeleted System.Boolean True

Label 'Deleted' corresponds to this field.

CreatedDate System.DateTime True

Label 'Created Date' corresponds to this field.

CreatedById System.String True

Label 'Created By ID' corresponds to this field.

LastModifiedDate System.DateTime True

Label 'Last Modified Date' corresponds to this field.

LastModifiedById System.String True

Label 'Last Modified By ID' corresponds to this field.

SystemModstamp System.DateTime True

Label 'System Modstamp' corresponds to this field.

CallDurationInSeconds System.Integer True

Label 'Call Duration' corresponds to this field.

CallType System.String True

Label 'Call Type' corresponds to this field.

CallDisposition System.String True

Label 'Call Result' corresponds to this field.

CallObject System.String True

Label 'Call Object Identifier' corresponds to this field.

ReminderDateTime System.DateTime True

Label 'Reminder Date/Time' corresponds to this field.

IsReminderSet System.Boolean True

Label 'Reminder Set' corresponds to this field.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
SOQL String

Specifies the Where clause of the SOQL query to execute against the FinancialForce servers. If this pseudo column is set from the WHERE clause it will take precendence over any other input.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839