SSIS Components for Certinia

Build 24.0.9060

EmailStatus

This is a table representing the EmailStatus entities in FinancialForce.

Columns

Name Type ReadOnly References Description
Id [KEY] String True

Label 'Email Status ID' corresponds to this field.

TaskId String True

Label 'Activity ID' corresponds to this field.

WhoId String True

Label 'Contact/Lead ID' 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.

TimesOpened Integer True

Label '# Times Opened' corresponds to this field.

FirstOpenDate DateTime True

Label 'Date Opened' corresponds to this field.

LastOpenDate DateTime True

Label 'Last Opened' corresponds to this field.

EmailTemplateName String True

Label 'Email Template Name' 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 24.0.9060