OUT_EMAIL
The table OUT_EMAIL is the main table for the e-mail out service. Records inserted into this table will be sent out. The table contains the specifics of the outgoing email like subject, from, reply to and body.
Column | Required (not Null) | Type | Values | Comments | |
gKey | Yes | Uniqueidentifier | gKey need to exist in EVENT_MASTER | ||
jKey | Yes | Uniqueidentifier | The jKey is used to link the OUT_EMAIL with OUT_EMAIL_RECEPIENT. See the database overview for more information. | ||
ReplyTo | Varchar(255) | The E-mail account which will be suggested when recipient reply. If left blank (null) the default reply to value (see information on Admin Console) will be used. If default value is blank (null) the From field is used (see below). | |||
Subject | Yes | Nvarchar (255) | E-mail subject | ||
Body | Nvarchar (max) | E-Mail body text. You may omit e-mail body in case you are using a reporting server report as provider of content. See the Attachment section under EVENT_CONTENT | |||
“Msg_Id | Varchar (255) | Used internally by Boomerang to track e-mail reply’s | |||
Key1 | Yes | Uniqueidentifier | Used internally by Boomerang to track e-mail reply’s | ||
Key2 | Yes | Uniqueidentifier | Used internally by Boomerang to track e-mail reply’s | ||
Key3 | Yes | Uniqueidentifier | Used internally by Boomerang to track e-mail reply’s | ||
Processed_On | Datetime | Updated by Boomerang indicating when e-mail message was sent. | |||
IncludeKey | Yes | Integer | 0 = No key to be included in message. 1 = Include key. 2 = Include key at end of message |
Default 1. For more details on the incomming and responce tracking see IN_EMAIL | |
From | Varchar(255) | This is the display name and e-mail address that will be visible to the recipient(s) of the e-mail and should be formatted like this:
If left blank (null) the default From value (see information on Admin Console) will be used. |
|||
XPriority | Integer | 1 = Highest 2 = High 3 = Normal 4 = Low 5 = Lowest |
E-mail priority settings.Default value is 3 |