EmailTemplates

Create, update, delete, and query the EmailTemplates module in SugarCRM.

Columns

Name	Type	ReadOnly	Description
Team_Id	String	False	The Id of the primary team.
Team_Set_Id	String	False	The Id of the team set.
Team_Count	String	False	The count of the team set.
Team_Name	String	False	The name of the primary team.
Id [KEY]	String	False	The unique identifier of the email template.
Date_Entered	Datetime	False	The date the record was created.
Date_Modified	Datetime	False	The date the record was last modified.
Modified_User_Id	String	False	The Id of the user who last modified the record.
Created_By	String	False	The Id of the user who created the record.
Published	String	False	The published status of the record.
Name	String	False	The name of the email template.
Description	String	False	The description for the email template.
Subject	String	False	The subject of the resulting email.
Body	String	False	Plaintext body of the resulting email.
Body_Html	String	False	The HTML-formatted body of the resulting email.
Deleted	Bool	False	The record deletion indicator.
Assigned_User_Id	String	False	The Id of the user assigned to the record.
Assigned_User_Name	String	False	The username of the user assigned to the record.
Base_Module	String	False	In Workflow alert templates, the module to which this template is associated.
From_Name	String	False	The from name of the resulting email.
From_Address	String	False	The from address of the resulting email.
Text_Only	Bool	False	Whether the email template is to be sent in text only.
Type	String	False	The type of the email template.