Contains the settings to connect with an email account
Data model
Fields
| Field | Type | Description |
|---|---|---|
| cnf_delete_mails* | BIT | Indicates whether the email should be deleted when downloaded |
| cnf_folder | NVARCHAR (100) | Email Folder |
| cnf_id* | INT | Unique identifier for mail settings |
| cnf_name | NVARCHAR (160) | Name of mail settings |
| cnf_pass | NVARCHAR (510) | Email user password |
| cnf_port | INT | Connection port |
| cnf_save_pdf | BIT | Determines if the email is saved as a PDF file |
| cnf_schedule_id | INT | Identifier of the associated connection schedule, reference the table AFW_SCHEDULER.sche_id |
| cnf_script | INT | Identifier of the associated mail template, reference the table ASDK_MAIL_TEMPLATE.plte_id |
| cnf_server | NVARCHAR (120) | Name of the mail server |
| cnf_ssl | INT | Connection security type identifier, (Not secure = 0, Implicit = 1, Explicit = 2) |
| cnf_state* | BIT | Indicates if the setting is active, (Active=1, Inactive=0) |
| cnf_type_email | INT | Identifier of the incoming mail protocol type, (1 =POP3, 2=IMAP) |
| cnf_user | NVARCHAR (160) | Email User |
| last_execution | DATETIME | Date of the last time the scheduling activity was run |
| setting_oauth | NVARCHAR (MAX) | OAuth Mail Configuration for Inbound Servers |
Primary Key
| PK_ASDK_MAIL_CONFIG |
|---|
| cnf_id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| cnf_schedule_id | Bod. AFW_SCHEDULER | sche_id | FK03_ASDK_MAIL_CONFIG |
| cnf_script | dbo.ASDK_MAIL_TEMPLATE | plte_id | FK02_ASDK_MAIL_CONFIG |