Task
This is a table representing the Task entities in Dynamics CRM.
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | String | False |
Unique identifier of the task. |
| ActivityId | String | False |
Unique identifier of the task. |
| ActivityTypeCode | String | True |
Type of activity. |
| ActualDurationMinutes | Integer | False |
Actual duration of the task in minutes. |
| ActualEnd | Datetime | False |
Actual end time of the task. |
| ActualStart | Datetime | False |
Actual start time of the task. |
| Category | String | False |
Category of the task. |
| CreatedBy_Id | String | True |
Unique identifier of the user who created the task. |
| CreatedBy_LogicalName | String | True | |
| CreatedBy_Name | String | True | |
| CreatedOn | Datetime | True |
Date and time when the task was created. |
| CreatedOnBehalfBy_Id | String | True |
Unique identifier of the delegate user who created the task. |
| CreatedOnBehalfBy_LogicalName | String | True | |
| CreatedOnBehalfBy_Name | String | True | |
| Description | String | False |
Description of the task. |
| ExchangeRate | Double | True |
Exchange rate for the currency associated with the task with respect to the base currency. |
| ImportSequenceNumber | Integer | False |
Unique identifier of the data import or data migration that created this record. |
| IsBilled | Boolean | False |
Information which specifies whether the task was billed as part of resolving a case. |
| IsRegularActivity | Boolean | True |
Information regarding whether the activity is a regular activity type or event type. |
| IsWorkflowCreated | Boolean | False |
Information which specifies if the task was created from a workflow rule. |
| ModifiedBy_Id | String | True |
Unique identifier of the user who last modified the task. |
| ModifiedBy_LogicalName | String | True | |
| ModifiedBy_Name | String | True | |
| ModifiedOn | Datetime | True |
Date and time when the task was last modified. |
| ModifiedOnBehalfBy_Id | String | True |
Unique identifier of the delegate user who last modified the task. |
| ModifiedOnBehalfBy_LogicalName | String | True | |
| ModifiedOnBehalfBy_Name | String | True | |
| OverriddenCreatedOn | Datetime | False |
Date and time that the record was migrated. |
| OwnerId_Id | String | False |
Unique identifier of the user or team who owns the task. |
| OwnerId_LogicalName | String | False | |
| OwnerId_Name | String | False | |
| OwningBusinessUnit_Id | String | True |
Unique identifier of the business unit that owns the task. |
| OwningBusinessUnit_LogicalName | String | True | |
| OwningBusinessUnit_Name | String | True | |
| OwningTeam_Id | String | True |
Unique identifier of the team that owns the task. |
| OwningTeam_LogicalName | String | True | |
| OwningTeam_Name | String | True | |
| OwningUser_Id | String | True |
Unique identifier of the user that owns the task. |
| OwningUser_LogicalName | String | True | |
| OwningUser_Name | String | True | |
| PercentComplete | Integer | False |
How much of the task has been completed, given in a percentage. |
| PriorityCode | String | False |
Priority of the task. |
| RegardingObjectId_Id | String | False |
Unique identifier of the object with which the task is associated. |
| RegardingObjectId_LogicalName | String | False | |
| RegardingObjectId_Name | String | False | |
| ScheduledDurationMinutes | Integer | True |
Scheduled duration of the task, specified in minutes. |
| ScheduledEnd | Datetime | False |
Scheduled end time of the task. |
| ScheduledStart | Datetime | False |
Scheduled start time of the task. |
| ServiceId_Id | String | False |
Unique identifier for an associated service. |
| ServiceId_LogicalName | String | False | |
| ServiceId_Name | String | False | |
| StateCode | String | True |
Status of the task. |
| StatusCode | String | False |
Reason for the status of the task. |
| Subcategory | String | False |
Sub category of the task. |
| Subject | String | False |
Subject associated with the task. |
| TimeZoneRuleVersionNumber | Integer | False |
For internal use only. |
| TransactionCurrencyId_Id | String | False |
Unique identifier of the currency associated with the task. |
| TransactionCurrencyId_LogicalName | String | False | |
| TransactionCurrencyId_Name | String | False | |
| UTCConversionTimeZoneCode | Integer | False |
Time zone code that was in use when the record was created. |