EmailMessage
Schema file for EmailMessage.
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
Unique identifier for the record. | |
| ParentId | String | False |
Case.Id |
ID of the parent object in the hierarchy. |
| ActivityId | String | False |
Task.Id |
ID of the Activity associated with this record. |
| CreatedById | String | True |
User.Id |
ID of the user who created the record. |
| CreatedDate | Datetime | True |
Date and time when the record was created. | |
| LastModifiedById | String | True |
User.Id |
ID of the user who last modified the record. |
| TextBody | String | False |
Field containing TextBody information. | |
| HtmlBody | String | False |
Field containing HtmlBody information. | |
| Headers | String | False |
Field containing Headers information. | |
| Subject | String | False |
Subject or title of the activity. | |
| Name | String | True |
Name of the record. | |
| FromName | String | False |
Field containing FromName information. | |
| FromAddress | String | False |
Field containing FromAddress information. | |
| ValidatedFromAddress | String | False |
Field containing ValidatedFromAddress information. | |
| ToAddress | String | False |
Field containing ToAddress information. | |
| CcAddress | String | False |
Field containing CcAddress information. | |
| BccAddress | String | False |
Field containing BccAddress information. | |
| Incoming | Bool | False |
Field containing Incoming information. | |
| HasAttachment | Bool | True |
Indicates whether the record has Attachment. | |
| Status | String | False |
Status of the record. | |
| MessageDate | Datetime | False |
Date associated with Message. | |
| IsDeleted | Bool | True |
Indicates whether the record has been moved to the Recycle Bin. | |
| ReplyToEmailMessageId | String | False |
EmailMessage.Id |
ID of the ReplyToEmailMessage associated with this record. |
| IsExternallyVisible | Bool | True |
Indicates whether the record has the ExternallyVisible characteristic. | |
| MessageIdentifier | String | False |
Field containing MessageIdentifier information. | |
| ThreadIdentifier | String | False |
Field containing ThreadIdentifier information. | |
| ClientThreadIdentifier | String | False |
Field containing ClientThreadIdentifier information. | |
| FromId | String | False |
ID of the From associated with this record. | |
| IsClientManaged | Bool | False |
Indicates whether the record has the ClientManaged characteristic. | |
| AttachmentIds | String | False |
Field containing AttachmentIds information. | |
| RelatedToId | String | False |
ID of the RelatedTo associated with this record. | |
| RelatedToIdType | String | False |
Specifies the type of the 'RelatedToId' polymorphic field to use in the statement. | |
| RelatedToIdExternalFieldName | String | False |
Specifies the external field name of the 'RelatedToId' polymorphic field to use in an INSERT/UPDATE/UPSERT statement | |
| IsTracked | Bool | False |
Indicates whether the record has the Tracked characteristic. | |
| IsOpened | Bool | True |
Indicates whether the record has the Opened characteristic. | |
| FirstOpenedDate | Datetime | False |
Date associated with FirstOpened. | |
| LastOpenedDate | Datetime | False |
Date associated with LastOpened. | |
| IsBounced | Bool | False |
Indicates whether the record has the Bounced characteristic. | |
| EmailTemplateId | String | False |
ID of the EmailTemplate associated with this record. | |
| AutomationType | String | False |
Type classification for Automation. | |
| Source | String | False |
Field containing Source information. | |
| SOQL | String | False |
Specifies the SOQL query to execute against the Salesforce servers. If this pseudo column is set from the WHERE clause it will take precedence over the original query. | |
| ExternalIdColumn | String | False |
Specifies the external Id column to use if performing an insert. If this value is specified, upsert will be used when the INSERT command is called. | |
| FilterScope | String | False |
Optional scope to limit the records returned from queries. This property can take one of these values: Delegated, Everything, Mine, MineAndMyGroups, My_Territory, My_Team_Territory, or Team. | |
| SystemModstamp | Datetime | True |
Date and time when the record was last modified by a user or by an automated process. | |
| LastModifiedDate | Datetime | True |
Date and time when the record was last modified. |