EN
Español
English
Português
    ASDK_MAIL_TEMPLATE

    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  
    category_id INT Case category identifier  
    customer_id INT Assigned Client Identifier  
    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  
    registry_type_id INT Identifier of the record type associated with the template  
    service_id INT Related Service Identifier  
    status_id INT Associated state identifier  
    type_id* INT Case Type Identifier  
    urgency_id INT Identifier of the urgency associated with the template  

    Primary Key

    PK_ASDK_MAIL_TEMPLATE
    plte_id

    References

    Column Referenced Table Referenced column Name
    author_id dbo.AFW_USERS user_id FK02_ASDK_MAIL_TEMPLATE
    category_id dbo.ASDK_CATEGORY ctg_index FK06_ASDK_MAIL_TEMPLATE
    customer_id dbo.AFW_USERS user_id FK03_ASDK_MAIL_TEMPLATE
    project_id* dbo.ASMS_PROJECTS proj_id FK01_ASDK_MAIL_TEMPLATE
    service_id dbo.ASDK_SERVICE id FK07_ASDK_MAIL_TEMPLATE
    status_id dbo.ASMS_STATUS stat_id FK04_ASDK_MAIL_TEMPLATE
    type_id* dbo.ASMS_TYPES id FK05_ASDK_MAIL_TEMPLATE