Contains the mail templates for the creation of the case via mail
Data model
Fields
| Field |
Type |
Description |
|
| author_id |
INT |
Identifier of the user who created the template, reference the table AFW_USERS.user_id |
|
| category_id |
INT |
Case category identifier, reference table ASDK_CATEGORY.ctg_index |
|
| customer_id |
INT |
Assigned client ID, reference table AFW_USERS.user_id |
|
| delimiter_signature |
NVARCHAR (MAX) |
Store segments of corporate signatures, separated by |
, to skip them in automatic categorization |
| description |
NVARCHAR (MAX) |
Email Message Template |
|
| effective_percentage |
INT |
Represents the percentage of effectiveness that must be met to continue automatic categorization |
|
| enable_auto_categorization |
BIT |
Determine whether to turn on auto-categorization |
|
| extract_additional_field |
BIT |
Represents whether the extraction of the additional fields is to be performed |
|
| extract_additional_list |
BIT |
Represents whether the extraction of additional fields of the list type is to be performed |
|
| plte_created |
DATETIME |
Date the template was created |
|
| plte_id* |
INT |
Unique mail template identifier |
|
| plte_name* |
NVARCHAR (200) |
Mail template name |
|
| project_id* |
INT |
Associated project ID, reference table ASMS_PROJECTS.proj_id |
|
| registry_type_id |
INT |
Identifier of the record type associated with the template, reference the table AFW_CATALOG_CODE.code_id |
|
| service_id |
INT |
Related service ID, reference table ASDK_SERVICE.id |
|
| status_id |
INT |
Associated state identifier, reference the ASMS_STATUS.stat_id table |
|
| type_id* |
INT |
Case type identifier, reference table ASMS_TYPES.id |
|
| urgency_id |
INT |
Identifier of the urgency associated with the template |
|
Primary Key
| PK_ASDK_MAIL_TEMPLATE |
| plte_id |
References
