pmse_Emails_Templates
Stores email templates that are used by Advanced Workflow processes. This table supports automated messaging and process-driven communication.
Columns
| Name | Type | ReadOnly | Description |
| Acl_Team_Names | String | True |
The list of team names that are associated with this process email template for access control and visibility. |
| Acl_Team_Set_Id | String | False |
The identifier (Id) of the access control team set that is assigned to this record. The team set determines which users and teams can view and access the template. |
| Assigned_User_Id | String | False |
The Id of the user who is assigned to this process email template record. |
| Assigned_User_Name | String | True |
The display name of the user who is assigned to this process email template. |
| Base_Module | String | False |
The SugarCRM module to which this process email template applies. The module context determines what record data can be merged into the template at runtime. |
| Body | String | False |
The plain-text body content of the email template. This version is used when emails are sent without HTML formatting. |
| Body_Html | String | True |
The HTML-formatted body content of the email template. This version supports styling, layout, and dynamic merge fields. |
| Commentlog | String | True |
A reference to comment log entries that are associated with this record. Comment logs capture collaboration notes and activity history. |
| Created_By | String | True |
The Id of the user who created the email template record. |
| Created_By_Name | String | True |
The display name of the user who created the email template record. |
| Date_Entered | Datetime | True |
The date and time when the email template record was created. |
| Date_Modified | Datetime | True |
The date and time when the email template record was last modified. |
| Deleted | Bool | False |
A Boolean field that returns a value of 'true' when the record is flagged as deleted. It returns a value of 'false' when the record remains active. This field supports soft-delete behavior. |
| Description | String | False |
A text description of the email template. This field is typically used to summarize the template's purpose or usage context. |
| Following | Bool | False |
A Boolean field that returns a value of 'true' when the current user is following the record. It returns a value of 'false' when the record is not followed. |
| From_Address | String | False |
The email address that appears in the 'From' field when emails are generated from this template. |
| From_Name | String | False |
The display name that appears as the sender name when the template is used to generate an email. |
| Id [KEY] | String | True |
The unique Id of the process email template record. |
| Modified_By_Name | String | True |
The display name of the user who last modified the email template. |
| Modified_User_Id | String | True |
The Id of the user who last modified the email template. |
| My_Favorite | Bool | False |
A Boolean field that returns a value of 'true' when the email template is marked as a favorite by the current user. It returns a value of 'false' when it is not marked as a favorite. |
| Name | String | False |
The name of the process email template. This value identifies the template in lists, selections, and workflow configuration panels. |
| Published | String | False |
A flag that indicates whether the template is published and available for runtime use. |
| Subject | String | False |
The subject line text that will appear on emails generated from this template. |
| Sync_Key | String | True |
An internal synchronization key that is used to track and reconcile templates across systems and connectors. |
| Tag | String | False |
Tags that are assigned to the template. Tags support categorization, quick filtering, and search. |
| Team_Count | String | False |
The number of teams that are assigned to this record. |
| Team_Id | String | False |
The Id of the primary team that is associated with this template. |
| Team_Name | String | False |
The display name of the primary team that is associated with this template. |
| Team_Set_Id | String | False |
The Id of the complete set of teams that grant access to this email template for sharing and visibility. |
| Text_Only | String | True |
A flag that indicates whether the template should be sent as plain text only. When this flag is enabled, HTML formatting is ignored. |
| Type | String | False |
The type of process email template (for example, 'workflow notification', 'automation messaging', or 'operational alert'). |