Messages
Stores records that represent message conversations and threaded communication. This table supports collaborative discussions and contextual communication history linked to CRM records.
Columns
| Name | Type | ReadOnly | Description |
| Accept_Status | String | False |
The acceptance status of the message for the current user. This value indicates the participation response state in the communication. |
| Accept_Status_Users | String | False |
A list of users and their associated acceptance status for the message. This field is used to track message delivery engagement across multiple participants. |
| Acl_Team_Names | String | True |
The display names of the access control teams that govern visibility for this message. This field supports role- and team-based record access control. |
| Acl_Team_Set_Id | String | False |
The Identifier (Id) of the access control team set that is associated with this message. This Id enables multi-team sharing configurations. |
| Assigned_User_Id | String | False |
The Id of the user who is assigned to the message. This assignment determines ownership and responsibility. |
| Assigned_User_Name | String | True |
The display name of the user who is assigned to the message. |
| Aws_Comprehend_Data | String | False |
Raw sentiment or classification data returned from the Amazon Web Services (AWS) Comprehend service. This field captures automated conversation analysis metadata. |
| Aws_Contact_Id | String | True |
The Id of the AWS Connect contact that is linked to this message. This value supports synchronization with call center events and conversation logs. |
| Channel_Type | String | False |
The channel through which the message was communicated (for example, SMS, email, and internal chat). |
| Commentlog | String | True |
A reference to the associated comment log entries. These entries store discussion history and collaboration notes. |
| Contact_Id | String | False |
The Id of the contact associated with the message when the message involves a known contact entity. |
| Contact_Name | String | True |
The display name of the contact associated with the message. |
| Conversation | String | True |
The conversation thread identifier that is used to group related messages into a continuous discussion sequence. |
| Conversation_Link | String | False |
A hyperlink or external reference to the full conversation thread. This link supports cross-system navigation. |
| Created_By | String | True |
The Id of the user who created the message record. This value supports authorship tracking. |
| Created_By_Name | String | True |
The display name of the user who created the message record. |
| Date_End | Datetime | False |
The date and time when the message conversation ended or was last active. |
| Date_Entered | Datetime | True |
The date and time when the message record was created. |
| Date_Modified | Datetime | True |
The date and time when the message record was last modified. |
| Date_Start | Datetime | False |
The date and time when the message conversation began. |
| Deleted | Bool | False |
A Boolean field that returns a value of 'true' when the message is marked for deletion. It returns a value of 'false' when the message remains active. This field supports soft-delete retention and recovery workflows. |
| Description | String | False |
A detailed narrative or descriptive text that is associated with the message. This field is often used to store summary details or conversation context. |
| Direction | String | False |
Indicates whether the message direction is inbound or outbound. This field supports routing, reporting, and workflow branching. |
| Following | Bool | False |
A Boolean field that returns a value of 'true' when the current user is following the message. It returns a value of 'false' when the message is not being followed. This feature enables activity monitoring and notifications. |
| Id [KEY] | String | True |
The unique Id of the message record. |
| Invitee_Contact_Id | String | True |
The Id of the contact who was invited to participate in the conversation. |
| Invitee_Contact_Name | String | True |
The display name of the invited contact. |
| Invitee_Lead_Id | String | True |
The Id of the lead who was invited to participate in the conversation. |
| Invitee_Lead_Name | String | True |
The display name of the invited lead. |
| Invitees | String | True |
A list of records representing individuals who are invited to participate in the message conversation. This field can reference contacts, leads, or users. |
| Locked_Fields | String | True |
A system-managed list of fields that are restricted from modification. This field is used to maintain record integrity. |
| Modified_By_Name | String | True |
The display name of the user who last modified the message record. |
| Modified_User_Id | String | True |
The Id of the user who last modified the message record. |
| My_Favorite | Bool | False |
A Boolean field that returns a value of 'true' when the current user marks the message as a favorite. It returns a value of 'false' when it is not marked as a favorite. This feature supports personalized record prioritization. |
| Name | String | False |
The name or subject of the message as it is displayed in lists and record views. |
| Parent_Id | String | False |
The Id of the SugarCRM record that is referenced by the Parent_Type field. This value establishes contextual linkage to another CRM entity such as an account, case, or opportunity. |
| Parent_Name | String | True |
The display name of the parent record referenced by the Parent_Id field. |
| Parent_Type | String | True |
The module name of the parent record that this message is associated with. This value determines the context relationship type. |
| Sentiment | String | False |
A sentiment classification value that is derived from conversation analysis (for example, 'POSITIVE', 'NEGATIVE', 'NEUTRAL', and 'MIXED'. |
| Status | String | False |
The message status value that indicates the processing, delivery, or follow-up state. |
| Sync_Key | String | True |
An internal synchronization key that is used to reconcile message records across integrated systems or replication operations. |
| Tag | String | False |
Tags that are assigned to the message record. Tags support categorization, search, and filtering. |
| Team_Count | String | False |
The count of teams that have access to the message through the team security model. |
| Team_Id | String | False |
The Id of the primary team that is associated with the message. This assignment controls core record-level access. |
| Team_Name | String | False |
The display name of the team that is associated with the message. |
| Team_Set_Id | String | False |
The Id of the team set that is assigned to the message. Team sets support shared access among multiple teams. |