Messages
The Messages table.
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | String | False |
Unique identifier |
| Name | String | False | |
| Date_Entered | Datetime | True |
Date record created |
| Date_Modified | Datetime | True |
Date record last modified |
| Modified_User_Id | String | True |
User who last modified record |
| Modified_By_Name | String | True | |
| Created_By | String | True |
User who created record |
| Created_By_Name | String | True | |
| Description | String | False |
Full text of the note |
| Deleted | Bool | False |
Record deletion indicator |
| Date_Start | Datetime | False | |
| Date_End | Datetime | False | |
| Parent_Type | String | True |
Sugar module the Message is associated with |
| Parent_Id | String | False |
The ID of the Sugar item specified in parent_type |
| Invitees | String | True | |
| Accept_Status | String | False | |
| Accept_Status_Users | String | False | |
| Invitee_Lead_Id | String | True | |
| Invitee_Lead_Name | String | True | |
| Invitee_Contact_Id | String | True | |
| Invitee_Contact_Name | String | True | |
| Contact_Id | String | False | |
| Parent_Name | String | True | |
| Contact_Name | String | True | |
| Status | String | False | |
| Direction | String | False | |
| Channel_Type | String | False | |
| Conversation_Link | String | False | |
| Conversation | String | True | |
| Aws_Contact_Id | String | True |
The AWS Connect Contact ID |
| Following | Bool | False |
Is user following this record |
| My_Favorite | Bool | False |
Favorite for the user |
| Tag | String | False | |
| Commentlog | String | True | |
| Locked_Fields | String | True | |
| Sync_Key | String | True | |
| Assigned_User_Id | String | False |
User ID assigned to record |
| Assigned_User_Name | String | True | |
| 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 | |
| Aws_Comprehend_Data | String | False |
Raw data from the aws comprehend service |
| Sentiment | String | False |
The sentiment string value (e.g POSITIVE, NEGATIVE, NEUTRAL, MIXED) |