emailtemplate
Contains email templates used in system-generated communications, facilitating consistent messaging across different processes.
Columns
| Name | Type | References | Description |
| id [KEY] | Integer | The unique internal identifier for the record, used to track and reference it within the system. | |
| addcompanyaddress | Boolean | Indicates whether the company address should be automatically added to the message footer during bulk merges. | |
| addunsubscribelink | Boolean | Indicates whether an unsubscribe link should be automatically included in the message footer during bulk merges, typically used for email marketing. | |
| content | String | The content or body of the message, often containing the main text, HTML, or other elements that make up the message body. | |
| description | String | A detailed description of the record or template, providing context or additional information about its purpose or contents. | |
| isautoconverted | Boolean | Indicates whether the template is automatically converted from another format or system, typically during an import or migration process. | |
| isinactive | Boolean | Indicates whether the record is marked as inactive, meaning it is not currently in use or visible in active processes. | |
| isprivate | Boolean | Indicates whether the template or record is private, restricting access or visibility to only specific users or roles. | |
| mediaitem | String | The media item associated with the record, such as an image, video, or other content used within the template or message. | |
| name | String | The name of the template or record, typically used for identification and referencing in the system. | |
| recordtype | String | The type of record, such as 'Email', 'Template', or other classifications used to categorize and track different record types. | |
| scriptid | String | The unique identifier for the script associated with the record, often used in automation or system integration. | |
| subject | String | The subject line of the message, typically used in email templates or communications to summarize the content. |