Power BI Connector for SugarCRM

Build 25.0.9454

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.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9454