Emails
The Emails table.
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | String | False |
Unique identifier |
| Date_Entered | Datetime | False |
Date record created |
| Date_Modified | Datetime | False |
Date record last modified |
| Assigned_User_Id | String | False |
User ID that last modified record |
| Assigned_User_Name | String | True | |
| Modified_User_Id | String | True |
User ID that last modified record |
| Modified_By_Name | String | True | |
| Created_By | String | True |
User name who created record |
| Created_By_Name | String | True | |
| Deleted | Bool | False |
Record deletion indicator |
| From_Addr_Name | String | False | |
| Reply_To_Addr | String | False | |
| To_Addrs_Names | String | False | |
| Cc_Addrs_Names | String | False | |
| Bcc_Addrs_Names | String | False | |
| Raw_Source | String | False | |
| Description_Html | String | True | |
| Description | String | False | |
| Date_Sent | Datetime | False | |
| Message_Id | String | False |
ID of the email item obtained from the email transport system |
| Message_Uid | String | False |
UID of the email item obtained from the email transport system |
| Name | String | False |
The subject of the email |
| Type | String | False |
Type of email (ex: draft) |
| Status | String | False | |
| Flagged | Bool | False |
flagged status |
| Reply_To_Status | Bool | False |
If you reply to an email then reply to status of original email is set |
| Intent | String | False |
Target of action used in Inbound Email assignment |
| Mailbox_Id | String | False | |
| Mailbox_Name | String | True | |
| State | String | False |
An email is either a draft or archived |
| Reply_To_Id | String | False |
Identifier of email record that this email was a reply to |
| Parent_Name | String | True | |
| Parent_Type | String | True |
Identifier of Sugar module to which this email is associated |
| Parent_Id | String | False |
ID of Sugar object referenced by parent_type |
| Direction | String | False |
Email direction is one of Unknown, Outbound, Inbound, Internal |
| Attachments_Collection | String | True | |
| Total_Attachments | Int | True | |
| Outbound_Email_Id | String | False |
The configuration used to send an email, only used for emails sent using SugarCRM |
| From_Collection | String | True | |
| To_Collection | String | True | |
| Cc_Collection | String | True | |
| Bcc_Collection | String | True | |
| Sync_Key | String | True | |
| My_Favorite | Bool | False |
Favorite for the user |
| Following | Bool | False |
Is user following this record |
| Tag | String | False | |
| Team_Id | String | False |
Team ID for the account |
| Team_Set_Id | String | False | |
| Acl_Team_Set_Id | String | False | |
| Team_Count | String | False | |
| Team_Name | String | False | |
| Acl_Team_Names | String | True |