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. |