invantive documentation
Invantive Support ForumsLog In / Sign Up

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 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 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: