EmailTemplates
The EmailTemplates table.
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | String | False |
Unique identifier |
| Date_Entered | Datetime | False |
Date record created |
| Date_Modified | Datetime | False |
Date record last modified |
| Modified_User_Id | String | True |
User who last modified record |
| Modified_By_Name | String | True | |
| Created_By | String | True |
User who created record |
| Created_By_Name | String | True | |
| Published | String | False | |
| Name | String | False |
Email template name |
| Description | String | False |
Email template description |
| Subject | String | False |
Email subject to be used in resulting email |
| Body | String | False |
Plain text body to be used in resulting email |
| Body_Html | String | True |
HTML formatted email body to be used in resulting email |
| Deleted | Bool | False |
Record deletion indicator |
| Base_Module | String | False |
In Workflow alert templates, the module to which this template is associated |
| From_Name | String | False | |
| From_Address | String | False | |
| Text_Only | Bool | False |
Should be checked if email template is to be sent in text only |
| Type | String | False |
Type of the email template |
| Attachments_Collection | String | True | |
| Has_Variables | Bool | True | |
| Assigned_User_Id | String | False |
User ID assigned to record |
| Assigned_User_Name | String | True | |
| Team_Id | String | False |
Team ID for the account |
| Team_Set_Id | String | False | |
| Acl_Team_Set_Id | String | False | |
| Team_Count | String | False | |
| Team_Name | String | False | |
| Acl_Team_Names | String | True | |
| Tag | String | False |