Please enable JavaScript to view this site.

Navigation: » No topics above this level «

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

string(30)

Address Encoding

Character set for encoding mail addresses.

attachment1Contents

byte[]

 

Binary contents of the first attachment.

attachment1MimeType

string

 

MIME type of the first attachment.

attachment1Name

string

Attachment #1 File Name

File name of the first attachment.

attachment2Contents

byte[]

 

Binary contents of the second attachment.

attachment2MimeType

string

 

MIME type of the second attachment.

attachment2Name

string

Attachment #2 File Name

File name of the second attachment.

attachment3Contents

byte[]

 

Binary contents of the third attachment.

attachment3MimeType

string

 

MIME type of the third attachment.

attachment3Name

string

Attachment #3 File Name

File name of the third attachment.

bccEmail

string

Blank Carbon Copy Recipient Email Addresses

List of Blank Carbo Copy recipients, separated by ';'.

body

string

Body Text

Body text of the mail.

bodyEncoding

string(30)

 

Character set for encoding mail body.

ccEmail

string

Carbon Copy Recipient Email Addresses

List of email addresses of the recipients of a copy, separated by ';'.

dateEndUtc

datetime

 

Date end (UTC).

dateStartUtc

datetime

 

Date start (UTC).

DispositionNotificationToEmailAddress

string

 

Email address in Disposition-Notification-To header.

enableSsl

boolean

 

Whether to use SSL on SMTP transport.

errorMessageCode

string

Error Message Code

Message code of the error.

errorMessageText

string

Error Message Text

Message text of the error.

failOnError

boolean

 

Fail on error.

fromEmail

string

From Email Address

FROM email address.

fromName

string

From Name

FROM name.

headers

string

Mail Headers

List of headers, per header separated by ';'. The header name and value are separated by a ':'.

HeadersEncoding

string(30)

Headers Encoding

Character set for encoding headers.

id

int64

 

ID.

isBodyHtml

boolean

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

string

Original System Reference

Original system reference.

priority

int32

Priority

Priority of the mail; negative is bulk, 0 is neutral, positive is urgent.

replyToEmail

string

Reply to Email Address

REPLY TO email address.

replyToName

string

Reply to Name

REPLY TO name.

ReturnReceiptToEmailAddress

string

 

Email address in Return-Receipt-To header.

smtpHostAddress

string

SMTP Server Host

Host name or IP-address of the SMTP server to send the mail through.

smtpHostPortNumber

int32

SMTP Server Port

Port number of the SMTP server.

smtpPassword

string

SMTP Server Password

Password for authentication of the user on the SMTP server.

smtpUserName

string

SMTP Server Log On Code

User name for authentication on the SMTP server.

subject

string

Subject

Subject of the mail.

subjectEncoding

string(30)

 

Character set for encoding subject.

successful

boolean

Succesful

Result of the sending was successful.

toEmail

string

Recipient Email Addresses

List of email addresses of the recipients, separated by ';'.

 

22-12-2022 20:54 Version 22.1.101-BETA+3681