SSIS Components for FinancialForce

Build 20.0.7656

ActivityHistory

This is a table representing the ActivityHistory entities in FinancialForce.

Columns

Name Type ReadOnly References Description
Id [KEY] String True

Label 'Activity ID' corresponds to this field.

AccountId String True

Label 'Account ID' corresponds to this field.

WhoId String True

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

WhatId String True

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

Subject String True

Label 'Subject' corresponds to this field.

IsTask Boolean True

Label 'Task' corresponds to this field.

ActivityDate String True

Label 'Date' corresponds to this field.

OwnerId String True

Label 'Assigned To ID' corresponds to this field.

Status String True

Label 'Status' corresponds to this field.

Priority String True

Label 'Priority' corresponds to this field.

ActivityType String True

Label 'Type' corresponds to this field.

IsClosed Boolean True

Label 'Closed' corresponds to this field.

IsAllDayEvent Boolean True

Label 'All Day Event' corresponds to this field.

DurationInMinutes Integer True

Label 'Duration' corresponds to this field.

Location String True

Label 'Location' corresponds to this field.

Description String True

Label 'Comments' corresponds to this field.

IsDeleted Boolean True

Label 'Deleted' corresponds to this field.

CreatedDate DateTime True

Label 'Created Date' corresponds to this field.

CreatedById String True

Label 'Created By ID' corresponds to this field.

LastModifiedDate DateTime True

Label 'Last Modified Date' corresponds to this field.

LastModifiedById String True

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

SystemModstamp DateTime True

Label 'System Modstamp' corresponds to this field.

CallDurationInSeconds Integer True

Label 'Call Duration' corresponds to this field.

CallType String True

Label 'Call Type' corresponds to this field.

CallDisposition String True

Label 'Call Result' corresponds to this field.

CallObject String True

Label 'Call Object Identifier' corresponds to this field.

ReminderDateTime DateTime True

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

IsReminderSet 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) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7656