---
title: "SMTP (Mail)"
description: "Outgoing Mail Message Queue"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/mail/Mail..SMTP
original: https://documentation.invantive.eu/en/datamodels/mail/Mail..SMTP
updated: 2026-11-01T16:19:26Z
license: https://documentation.invantive.eu/en/
---

# SMTP: Mail Outgoing Mail Message Queue

`insert` `delete`

- Catalog: `Mail`
- Primary Keys: `id`
- Label: Outgoing Mail Message Queue

Can retrieve data and change data using `insert` and `delete`.

## 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 and update.

| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `AddressEncoding` | `varchar2(30)` | Address Encoding | [ ] | fetched only when named | Character set for encoding mail addresses. |
| `DispositionNotificationToEmailAddress` | `varchar2` | Disposition Notification to Email Address | [ ] | fetched only when named | Email address in Disposition-Notification-To header. |
| `HeadersEncoding` | `varchar2(30)` | Headers Encoding | [ ] | fetched only when named | Character set for encoding headers. |
| `ReturnReceiptToEmailAddress` | `varchar2` | Return Receipt To Email Address | [ ] | fetched only when named | Email address in Return-Receipt-To header. |
| `attachment1Contents` | `blob` | Attachment 1 Contents | [ ] | fetched only when named | Binary contents of the first attachment. |
| `attachment1MimeType` | `varchar2` | Attachment 1 MIME Type | [ ] | fetched only when named | MIME type of the first attachment. |
| `attachment1Name` | `varchar2` | Attachment #1 File Name | [ ] | fetched only when named | File name of the first attachment. |
| `attachment2Contents` | `blob` | Attachment 2 Contents | [ ] | fetched only when named | Binary contents of the second attachment. |
| `attachment2MimeType` | `varchar2` | Attachment 2 MIME Type | [ ] | fetched only when named | MIME type of the second attachment. |
| `attachment2Name` | `varchar2` | Attachment #2 File Name | [ ] | fetched only when named | File name of the second attachment. |
| `attachment3Contents` | `blob` | Attachment 3 Contents | [ ] | fetched only when named | Binary contents of the third attachment. |
| `attachment3MimeType` | `varchar2` | Attachment 3 MIME Type | [ ] | fetched only when named | MIME type of the third attachment. |
| `attachment3Name` | `varchar2` | Attachment #3 File Name | [ ] | fetched only when named | File name of the third attachment. |
| `bccEmail` | `varchar2` | Blank Carbon Copy Recipient Email Addresses | [ ] | fetched only when named | List of Blank Carbo Copy recipients, separated by ';'. |
| `body` | `varchar2` | Body Text | [ ] | fetched only when named | Body text of the mail. |
| `bodyEncoding` | `varchar2(30)` | Body Encoding | [ ] | fetched only when named | Character set for encoding mail body. |
| `ccEmail` | `varchar2` | Carbon Copy Recipient Email Addresses | [ ] | fetched only when named | List of email addresses of the recipients of a copy, separated by ';'. |
| `dateEndUtc` | `datetime` | Date End (UTC) | [ ] | fetched only when named | Date end (UTC). |
| `dateStartUtc` | `datetime` | Date Start (UTC) | [ ] | fetched only when named | Date start (UTC). |
| `enableSsl` | `boolean` | SMTP Enable SSL | [ ] | fetched only when named | Whether to use SSL on SMTP transport. |
| `errorMessageCode` | `varchar2` | Error Message Code | [ ] | fetched only when named | Message code of the error. |
| `errorMessageText` | `varchar2` | Error Message Text | [ ] | fetched only when named | Message text of the error. |
| `failOnError` | `boolean` | On Error | [ ] | fetched only when named | Fail on error. |
| `fromEmail` | `varchar2` | From Email Address | [ ] | fetched only when named | FROM email address. |
| `fromName` | `varchar2` | From Name | [ ] | fetched only when named | FROM name. |
| `headers` | `varchar2` | Mail Headers | [ ] | fetched only when named | List of headers, per header separated by ';'. The header name and value are separated by a ':'. |
| `id` | `number` | Mail ID | [x] | fetched only when named | ID. |
| `isBodyHtml` | `varchar2` | Body is HTML Text | [ ] | fetched only when named | True when the contents of the body are formatted as HTML, false when formatted as plain text. |
| `minimumDeliveryDurationMsec` | `int32` | Minimum Delivery Duration (ms) | [ ] | fetched only when named | 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 | [ ] | fetched only when named | Original system reference. |
| `priority` | `number` | Priority | [ ] | fetched only when named | Priority of the mail; negative is bulk, 0 is neutral, positive is urgent. |
| `replyToEmail` | `varchar2` | Reply to Email Address | [ ] | fetched only when named | REPLY TO email address. |
| `replyToName` | `varchar2` | Reply to Name | [ ] | fetched only when named | REPLY TO name. |
| `smtpHostAddress` | `varchar2` | SMTP Server Host | [ ] | fetched only when named | Host name or IP-address of the SMTP server to send the mail through. |
| `smtpHostPortNumber` | `number` | SMTP Server Port | [ ] | fetched only when named | Port number of the SMTP server. |
| `smtpPassword` | `varchar2` | SMTP Server Password | [ ] | fetched only when named | Password for authentication of the user on the SMTP server. |
| `smtpUserName` | `varchar2` | SMTP Server Log On Code | [ ] | fetched only when named | User name for authentication on the SMTP server. |
| `subject` | `varchar2` | Subject | [ ] | fetched only when named | Subject of the mail. |
| `subjectEncoding` | `varchar2(30)` | Subject Encoding | [ ] | fetched only when named | Character set for encoding subject. |
| `successful` | `boolean` | Succesful | [ ] | fetched only when named | Result of the sending was successful. |
| `toEmail` | `varchar2` | Recipient Email Addresses | [x] | fetched only when named | List of email addresses of the recipients, separated by ';'. |



## Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver:

- [Mail](/en/release-notes/drivers?driver=mail)

