Join Wintertainment 2021 to share your stories, have fun, earn community badges, and more!

EmailTemplates Table

Applies to QAComplete 12.94 SaaS, last modified on December 06, 2021

Description

The table stores the created e-mail templates.

Columns

The table contains the following columns:

EmailTemplateId  :  int, primary key, allows null: no

The unique numeric identifier of the item.

DeptId  :  int, allows null: no

The ID of the department that owns the template.

DateCreated  :  datetime, allows null: no

The date and time when the item was created.

The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.

DateUpdated  :  datetime, allows null: no

The date and time when the item was last updated.

The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.

EmailBody  :  text (max 2,147,483,647 chars), allows null: no

The content of the email message created with the template.

This column corresponds to a field that can be available for rich editing.

EmailSubject  :  varchar (max 255 chars), allows null: no

The subject of the email message created with the template.

FormName  :  varchar (max 30 chars), allows null: no

The name of the module that contains the template.

IsPublic  :  char (max 1 char), allows null: no

Indicates whether the template is public.

TemplateName  :  varchar (max 100 chars), allows null: no

The name of the template.

UpdateUserId  :  int, allows null: no

The ID of the user who last updated the item.

See Also

EmailTemplates View
Crossmodules

Highlight search results