| Field |
Type |
Defaults |
Nulls? |
Comments |
| identifier |
numeric (19) |
None |
No |
Unique ID for an entry. |
| logNumber |
numeric (19) |
None |
No |
Audit log identifier. |
| CACertificateBytes |
varbinary (MAX) |
None |
Yes |
The binary form of the trusted CA certificate used for encrypted communication. |
| encSmtpPassword |
nvarchar (4000) |
None |
Yes |
The encrypted password to use when authenticating with the SMTP server. |
| fromAddress |
nvarchar (256) |
None |
Yes |
The from email address used for SMTP negotiations. |
| implicitTrust |
tinyint |
None |
Yes |
Whether or not the certificate presented by the server for encrypted communications is implicitly trust or must be validated. |
| mailboxPort |
int |
None |
Yes |
The mailbox server port. |
| mailboxType |
nvarchar (255) |
None |
Yes |
The type of mailbox account; either IMAP or POP3. |
| replyToAddress |
nvarchar (256) |
None |
Yes |
The reply-to email address. |
| smtpHost |
nvarchar (256) |
None |
Yes |
The SMTP server hostname. |
| smtpPort |
int |
None |
Yes |
The SMTP server port. |
| smtpUsername |
nvarchar (256) |
None |
Yes |
The username to use when authenticating with the SMTP server. |
| useAuthentication |
tinyint |
None |
Yes |
Whether or not to use authentication when communicating with the SMTP server. |
| useEncryption |
tinyint |
None |
Yes |
Whether or not to encrypt communications with the SMTP Server. |
| useMailbox |
tinyint |
None |
Yes |
Whether or not the account mailbox will be monitored for undeliverables. |