Task
Represents user tasks, such as follow-ups and reminders, that track activities within Salesforce.
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
Unique identifier for the task record. | |
| WhoId | String | False |
Identifier of the contact or lead related to this task. | |
| WhatId | String | False |
Identifier of the related object, such as an opportunity, account, or custom object. | |
| Subject | String | False |
Brief description or title of the task, typically indicating its purpose. | |
| ActivityDate | Datetime | False |
Due date for the task; does not include a time component. | |
| Status | String | False |
Current status of the task, such as Not Started, Completed, or In Progress. | |
| Priority | String | False |
Priority level of the task, such as High, Normal, or Low. | |
| OwnerId | String | False |
User.Id |
Identifier of the user or queue to whom the task is assigned. |
| Description | String | False |
Detailed notes or instructions related to the task. | |
| IsDeleted | Boolean | True |
Indicates whether the task has been deleted from the system. | |
| AccountId | String | True |
Account.Id |
Identifier of the account associated with the task, typically inferred from the related contact. |
| IsClosed | Boolean | True |
Indicates whether the task has been marked as completed or closed. | |
| CreatedDate | Datetime | True |
Date and time when the task was created. | |
| CreatedById | String | True |
User.Id |
Identifier of the user who created the task. |
| LastModifiedDate | Datetime | True |
Date and time when the task was last modified. | |
| LastModifiedById | String | True |
User.Id |
Identifier of the user who last updated the task. |
| SystemModstamp | Datetime | True |
System-generated timestamp indicating the most recent change to the task. | |
| IsArchived | Boolean | True |
Indicates whether the task has been archived as part of a historical activity process. | |
| CallDurationInSeconds | Int | False |
Length of the associated call, in seconds, if the task is a logged call. | |
| CallType | String | False |
Type of call, such as Inbound or Outbound, if the task represents a call. | |
| CallDisposition | String | False |
Outcome or result of the call, such as Left Voicemail or Completed. | |
| CallObject | String | False |
Identifier for the telephony system object associated with the call task. | |
| ReminderDateTime | Datetime | False |
Date and time when a reminder notification should be sent for this task. | |
| IsReminderSet | Boolean | False |
Indicates whether a reminder is set for this task. | |
| RecurrenceActivityId | String | True |
Task.Id |
Identifier of the master task record for a recurring task series. |
| IsRecurrence | Boolean | False |
Indicates whether the task is part of a recurring task series. | |
| RecurrenceStartDateOnly | Datetime | False |
Start date of the recurring task series. | |
| RecurrenceEndDateOnly | Datetime | False |
End date of the recurring task series. | |
| RecurrenceTimeZoneSidKey | String | False |
Time zone used to schedule the recurring task series. | |
| RecurrenceType | String | False |
Pattern of recurrence, such as Daily, Weekly, or Monthly. | |
| RecurrenceInterval | Int | False |
Frequency of the recurrence, such as every 2 days or every 3 weeks. | |
| RecurrenceDayOfWeekMask | Int | False |
Bitmask representing the days of the week on which the task recurs. | |
| RecurrenceDayOfMonth | Int | False |
Specific day of the month on which the task recurs, if applicable. | |
| RecurrenceInstance | String | False |
Instance of the recurrence, such as First, Second, or Last (used for monthly patterns). | |
| RecurrenceMonthOfYear | String | False |
Month of the year in which the task recurs, used for annual recurrence patterns. |