Emails
Stores inbound, outbound, and archived email message data. This table supports messaging history, communication audit, and engagement timelines.
Columns
| Name | Type | ReadOnly | Description |
| Acl_Team_Names | String | True |
A list of team names that are associated with the email record for access and visibility control. |
| Acl_Team_Set_Id | String | False |
The identifier (Id) of the team set that governs access to the email record. |
| Assigned_User_Id | String | False |
The Id of the user who is currently assigned responsibility for the email record. |
| Assigned_User_Name | String | True |
The display name of the user who is currently assigned responsibility for the email record. |
| Attachments_Collection | String | True |
A serialized or encoded collection of attachment metadata that is associated with the email message. |
| Bcc_Addrs_Names | String | False |
A display-formatted list of recipient names that are included in the blind carbon copy ('Bcc') field. |
| Bcc_Collection | String | True |
A structured collection of address entries used for the 'Cc' field. |
| Cc_Addrs_Names | String | False |
A display-formatted list of recipient names that are included in the carbon copy ('Cc') field. |
| Cc_Collection | String | True |
A structured collection of address entries used for the 'Cc' field. |
| Created_By | String | True |
The Id of the user who originally created the email record. |
| Created_By_Name | String | True |
The display name of the user who originally created the email record. |
| Date_Entered | Datetime | True |
The date and time when the email record was created in the system. |
| Date_Modified | Datetime | True |
The date and time when the email record was last modified. |
| Date_Sent | Datetime | False |
The date and time when the email message was sent, if it is applicable. |
| Deleted | Bool | False |
A Boolean field that returns a value of 'true' when the email record is flagged as deleted. It returns a value of 'false' when the email record is active. |
| Description | String | False |
The plaintext body content of the email message. |
| Description_Html | String | True |
The HTML-formatted body content of the email message. |
| Direction | String | False |
The direction of the email relative to the CRM workflow (for example, 'Inbound', 'Outbound', 'Internal', or 'Unknown'). |
| Flagged | Bool | False |
A Boolean field that returns a value of 'true' when the email is marked as flagged for review or attention. It returns a value of 'false' when no follow-up or flag is applied. |
| Following | Bool | False |
A Boolean field that returns a value of 'true' when the current user is following the record to receive updates. It returns a value of 'false' when the user is not following the record. |
| From_Addr_Name | String | False |
The display-formatted sender name that is extracted from the 'From' address field. |
| From_Collection | String | True |
A structured collection containing sender address metadata that is used to compose or display the 'From' field. |
| Id [KEY] | String | True |
The unique Id of the email record. |
| Intent | String | False |
A functional indicator that describes the purpose of the email in inbound routing or automation flows (for example, 'routing', 'archival', or 'case assignment'). |
| Mailbox_Id | String | False |
The Id of the mailbox configuration that is used to route or retrieve this email message. |
| Mailbox_Name | String | True |
The display name of the mailbox that is used to route or retrieve the email. |
| Message_Id | String | False |
The message iId that is assigned by the email transport system (for example, an SMTP Message-ID header). |
| Message_Uid | String | False |
The unique message Id that is assigned by the mailbox server during retrieval (for example, 'IMAP UID'). |
| Modified_By_Name | String | True |
The display name of the user who last modified the email record. |
| Modified_User_Id | String | True |
The Id of the user who last modified the email record. |
| My_Favorite | Bool | False |
A Boolean field that returns a value of 'true' when the record is marked as a favorite of the current user. It returns a value of 'false' when it is not marked as a favorite. |
| Name | String | False |
The subject line of the email message. |
| Outbound_Email_Id | String | False |
The Id)of the outbound email configuration that is used to send the message when it is sent from within the CRM application. |
| Parent_Id | String | False |
The Id of the parent record to which the email is linked (for example, a Contact, Account, Lead, or Case). |
| Parent_Name | String | True |
The display name of the parent record that is associated with the email. |
| Parent_Type | String | True |
The module or record type of the parent to which the email is associated (for example, 'Contacts', 'Accounts', or 'Leads'). |
| Raw_Source | String | False |
The raw source content or MIME-formatted representation of the email, if it is available. |
| Reply_To_Addr | String | False |
The reply-to address specified for the email message, if it is different from the sender. |
| Reply_To_Id | String | False |
The Id of the prior email message to which the current message is a reply. |
| Reply_To_Status | Bool | False |
A Boolean field that returns a value of 'true' when this email has triggered a reply state on its linked message. It returns a value of 'false' when no reply linkage is applied. |
| State | String | False |
Indicates whether the email record is in a draft or archived state. |
| Status | String | False |
An application-level status value that is used to reflect processing or handling state for workflows or integrations. |
| Sync_Key | String | True |
A system-generated synchronization key that is used to align the record with external systems. |
| Tag | String | False |
A collection of user-assigned tags that is used for organization, filtering, and classification. |
| Team_Count | String | False |
The number of teams that are associated with the email record for access control. |
| Team_Id | String | False |
The Id of the primary team that is associated with the email record. |
| Team_Name | String | False |
The display name of the primary team that is associated with the email record. |
| Team_Set_Id | String | False |
The Id of the full team set that governs collaborative access to the record. |
| To_Addrs_Names | String | False |
A display-formatted list of recipient names that are included in the 'To' field. |
| To_Collection | String | True |
A structured collection of address entries that are used for the 'To' recipient list. |
| Total_Attachments | Int | True |
The total number of attachments that are associated with the email message. |
| Type | String | False |
The type of email record (for example, 'draft', 'archived', or 'imported'). |