SSIS Components for Oracle Sales

Build 24.0.9060

ActivityObjectives

Table used to capture the objectives associated to the activity.

Columns

Name Type ReadOnly References Description
ObjectiveId [KEY] Long False

Objective Id

ActivityNumber [KEY] String False

Activities.ActivityNumber

ActivityId Long False

Activities.ActivityId

System generated non-nullable primary key of the Parent Activity.

AttributeCategory String False

null

CompletedFlag Bool False

Completed Flag

ConflictId Long False

Conflict id

CorpCurrencyCode String False

Holds Corporate Currency Code from profile

CreatedBy String False

System attribute to capture the user Id of the activity assignee creator. This is defaulted by the system.

CreationDate Datetime False

System attribute to capture the date and time the activity assignee was created. This is defaulted by the system.

CurcyConvRateType String False

Holds Currency Conversion Rate Type from profile

CurrencyCode String False

Holds currency code of a record

LastUpdateDate Datetime False

System attribute to capture the date and time the activity assignee was last updated. This is defaulted by the system.

LastUpdateLogin String False

System attribute to capture the Id of the user who last updated the activity assignee. This is defaulted by the system.

LastUpdatedBy String False

System attribute to capture the Id of the user who last updated the activity assignee. This is defaulted by the system.

ObjectiveCode String False

Objective Code

ObjectiveFreefmtText String False

Objective Free Format Text

RecurSeriesId Long False

null

ActivityLastUpdateDate Datetime False

The date and time when the opportunity was last updated.

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
Finder String

Input specifying the Finder type.

ContactIDAttr String

The contact ID related to the activities.

AccountIdAttr String

Finds the account ID related to the call reports.

LeadIdAttr String

Finds the lead ID related to the call reports.

OpportunityIdAttr String

Finds the opportunity ID related to the call reports.

ParentActivityIdAttr String

The parent activity ID related to the call reports.

EndDtRFAttr String

The appointment end date.

StartDtRFAttr String

The appointment start date.

DateRange String

The date range within which you want search for appointments.

Bind_CurrentDate String

Finds the date used to locate completed activities.

Bind_RecurSeriesType_BV String

The recurring type code of an appointment.

Bind_TaskActFuncCd_BV String

The activities with a function code of task.

Bind_TaskStatus_BV String

The status of the tasks.

Bind_UserResourceId String

Finds the resource ID of the user.

Bind_Subject String

Open activities owned by a specified user.

Bind_LoggedInUserId_BV String

The ID of the user who is logged into the application.

Bind_TaskStatus_Cancel_BV String

The tasks with a cancelled status.

Bind_TaskPriority_BV String

The priority of the task.

Bind_CurrentUPTZDate String

The date used to locate the Tasks whose due date is before the current date.

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