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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| 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. |