EmailTemplates
Stores reusable email templates in text and HTML formats. This table supports consistent messaging, automated notifications, and campaign execution.
Columns
| Name | Type | ReadOnly | Description |
| Acl_Team_Names | String | True |
The list of team names that are associated with this email template. These names determine which teams have access to view or modify the template within SugarCRM. |
| Acl_Team_Set_Id | String | False |
The unique identifier (Id) for the team set that controls access to this template. This Id is used by SugarCRM security rules to determine role-based availability. |
| Assigned_User_Id | String | False |
The Id of the user who is assigned ownership of this email template. This user is generally responsible for maintaining and updating the template as needed. |
| Assigned_User_Name | String | True |
The display name of the user who is assigned ownership of this email template. This value is helpful for UI display and reporting contexts. |
| Attachments_Collection | String | True |
The collection of attachments that are linked to this email template. These attachments can include files, documents, or images that are inserted into outgoing emails. |
| Base_Module | String | False |
The module in SugarCRM to which this email template is linked. This linkage allows workflow alerts and automated messages to reference records within the specified module. |
| Body | String | False |
The plain text version of the email body. This version is used when the recipient's email client does not support HTML formatting. |
| Body_Html | String | True |
The HTML-formatted version of the email body. This version supports rich text formatting, styling, embedded links, and inline images. |
| Created_By | String | True |
The Id of the user who created this email template. This value identifies the originator of the template record. |
| Created_By_Name | String | True |
The display name of the user who created this email template. This value is commonly used in user-facing pages and administrative reporting. |
| Date_Entered | Datetime | True |
The date and time when this email template was initially created. This timestamp reflects record creation events for audit and history tracking. |
| Date_Modified | Datetime | True |
The date and time when this email template was last updated. This timestamp supports version tracking and administrative review. |
| Deleted | Bool | False |
A Boolean field that returns a value of 'true' when this email template is marked as deleted in SugarCRM. It returns a value of 'false' when the template is active and available for use. |
| Description | String | False |
A detailed explanatory note about the purpose or use of this email template. This field is often used to help administrators and workflow designers understand the intended context. |
| From_Address | String | False |
The email address that appears in the 'From' field when the template is used to generate outgoing email messages. |
| From_Name | String | False |
The name that appears in the 'From' field when this template is used. This value is typically the name of an organization, department, or representative. |
| Has_Variables | Bool | True |
A Boolean field that returns a value of 'true' when the email template contains merge fields or dynamic placeholder variables. It returns a value of 'false' when the content is static and contains no field-driven substitutions. |
| Id [KEY] | String | True |
The unique identifier (Id) of this email template. The system uses this Id to reference and manage the template internally. |
| Modified_By_Name | String | True |
The display name of the user who last modified this email template. This value is useful for change tracking and review. |
| Modified_User_Id | String | True |
The Id of the user who most recently updated this email template. This field provides traceability for editing history. |
| Name | String | False |
The name of the email template. This value is used to identify the template in selection lists, workflow configuration panels, and administrative tools. |
| Published | String | False |
The publishing state of this email template. This value indicates whether the template is finalized for use, in draft form, or reserved for administrative work. |
| Subject | String | False |
The subject line that is inserted into outgoing emails when this template is applied. |
| Tag | String | False |
The tags that are associated with this email template for searching, filtering, and categorization within SugarCRM. |
| Team_Count | String | False |
The number of teams that are associated with this email template. This value is useful when evaluating access scope and collaboration permissions. |
| Team_Id | String | False |
The Id of the primary team that is associated with this email template. The primary team plays a central role in access control. |
| Team_Name | String | False |
The display name of the primary team that is associated with this email template. This value is used in UI contexts and reporting. |
| Team_Set_Id | String | False |
The Id of the team set that is assigned to this email template. The team set defines the full list of teams that may view or edit the template. |
| Text_Only | Bool | False |
A Boolean field that returns a value of 'true' when this template must be sent only in plain text. It returns a value of 'false' when HTML formatting is permitted. |
| Type | String | False |
The type classification of this email template. Template types help categorize templates for use in workflow automation, user notifications, marketing communications, or system alerts. |