# SMTP: Mail Outgoing Mail Message Queue - Catalog: `Mail` - Primary Keys: `id` - Label: Outgoing Mail Message Queue - Retrieve: True ## Table Columns The columns of the table `SMTP` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `AddressEncoding` | `varchar2`(30) | Address Encoding | ☐ | Character set for encoding mail addresses. | | `attachment1Contents` | `blob` | Attachment 1 Contents | ☐ | Binary contents of the first attachment. | | `attachment1MimeType` | `varchar2` | Attachment 1 MIME Type | ☐ | MIME type of the first attachment. | | `attachment1Name` | `varchar2` | Attachment #1 File Name | ☐ | File name of the first attachment. | | `attachment2Contents` | `blob` | Attachment 2 Contents | ☐ | Binary contents of the second attachment. | | `attachment2MimeType` | `varchar2` | Attachment 2 MIME Type | ☐ | MIME type of the second attachment. | | `attachment2Name` | `varchar2` | Attachment #2 File Name | ☐ | File name of the second attachment. | | `attachment3Contents` | `blob` | Attachment 3 Contents | ☐ | Binary contents of the third attachment. | | `attachment3MimeType` | `varchar2` | Attachment 3 MIME Type | ☐ | MIME type of the third attachment. | | `attachment3Name` | `varchar2` | Attachment #3 File Name | ☐ | File name of the third attachment. | | `bccEmail` | `varchar2` | Blank Carbon Copy Recipient Email Addresses | ☐ | List of Blank Carbo Copy recipients, separated by ';'. | | `body` | `varchar2` | Body Text | ☐ | Body text of the mail. | | `bodyEncoding` | `varchar2`(30) | Body Encoding | ☐ | Character set for encoding mail body. | | `ccEmail` | `varchar2` | Carbon Copy Recipient Email Addresses | ☐ | List of email addresses of the recipients of a copy, separated by ';'. | | `dateEndUtc` | `datetime` | Date End (UTC) | ☐ | Date end (UTC). | | `dateStartUtc` | `datetime` | Date Start (UTC) | ☐ | Date start (UTC). | | `DispositionNotificationToEmailAddress` | `varchar2` | Disposition Notification to Email Address | ☐ | Email address in Disposition-Notification-To header. | | `enableSsl` | `boolean` | SMTP Enable SSL | ☐ | Whether to use SSL on SMTP transport. | | `errorMessageCode` | `varchar2` | Error Message Code | ☐ | Message code of the error. | | `errorMessageText` | `varchar2` | Error Message Text | ☐ | Message text of the error. | | `failOnError` | `boolean` | On Error | ☐ | Fail on error. | | `fromEmail` | `varchar2` | From Email Address | ☐ | FROM email address. | | `fromName` | `varchar2` | From Name | ☐ | FROM name. | | `headers` | `varchar2` | Mail Headers | ☐ | List of headers, per header separated by ';'. The header name and value are separated by a ':'. | | `HeadersEncoding` | `varchar2`(30) | Headers Encoding | ☐ | Character set for encoding headers. | | `id` | `number` | Mail ID | ☑ | ID. | | `isBodyHtml` | `varchar2` | Body is HTML Text | ☐ | True when the contents of the body are formatted as HTML, false when formatted as plain text. | | `minimumDeliveryDurationMsec` | `int32` | Minimum Delivery Duration (ms) | ☐ | Minimum deliver duration in milliseconds for the SMTP send plus inserted sleep when SMTP send finished earlier than the minimum. | | `origSystemReference` | `varchar2` | Original System Reference | ☐ | Original system reference. | | `priority` | `number` | Priority | ☐ | Priority of the mail; negative is bulk, 0 is neutral, positive is urgent. | | `replyToEmail` | `varchar2` | Reply to Email Address | ☐ | REPLY TO email address. | | `replyToName` | `varchar2` | Reply to Name | ☐ | REPLY TO name. | | `ReturnReceiptToEmailAddress` | `varchar2` | Return Receipt To Email Address | ☐ | Email address in Return-Receipt-To header. | | `smtpHostAddress` | `varchar2` | SMTP Server Host | ☐ | Host name or IP-address of the SMTP server to send the mail through. | | `smtpHostPortNumber` | `number` | SMTP Server Port | ☐ | Port number of the SMTP server. | | `smtpPassword` | `varchar2` | SMTP Server Password | ☐ | Password for authentication of the user on the SMTP server. | | `smtpUserName` | `varchar2` | SMTP Server Log On Code | ☐ | User name for authentication on the SMTP server. | | `subject` | `varchar2` | Subject | ☐ | Subject of the mail. | | `subjectEncoding` | `varchar2`(30) | Subject Encoding | ☐ | Character set for encoding subject. | | `successful` | `boolean` | Succesful | ☐ | Result of the sending was successful. | | `toEmail` | `varchar2` | Recipient Email Addresses | ☑ | List of email addresses of the recipients, separated by ';'. |