|
Field Name
|
Description
|
Version Added
|
|
AutoApDate_
|
Date/time at which time this message is automatically approved (smalldatetime, NULL)
|
|
|
Body_
|
The body of the message (text, NULL)
|
|
|
ByEmail_
|
Was this current entry created by email, or by some other means, such as a script or web interface (bool)
|
|
|
DeliverBefore_
|
After this time the message should not be delivered. (smalldatetime, NULL)
|
|
|
DetectHTML_
|
Should this message detect HTML use. (bool)
|
9.2
|
|
DocID_
|
DocID_ of content that this inmail message uses. Reserved for future use. (int, NULL)
|
9.2
|
|
DocType_
|
DocType_ of content that this inmail message uses. (varchar(20), NULL)
|
9.2
|
|
GuiState_
|
Details about the state of the edit control in the GUI. (text, null)
|
|
|
HdrAll_
|
The complete message header (text, NULL)
|
|
|
HdrDate_
|
The 'date:' header (varchar(100), NULL)
|
|
|
HdrFrom_
|
The 'from:' header (varchar(200), NULL)
|
|
|
HdrFromSpc_
|
The 'from ' header (varchar(200), NULL)
|
|
|
HdrSubject_
|
The 'subject:' header (varchar(2001000), NULL)
|
|
|
HdrTo_
|
The 'to:' header (varchar(200), NULL)
|
|
|
IsAutoApprove_
|
Whether or not this message will be auto-approved at a specific date/time. (bool, NOT NULL).
|
Added in 8.1.
|
|
List_
|
The list that this message belongs to (varchar(60), NOT NULL)
|
|
| MailStreamID_ |
The MailStream associated with this Mailing (int, NULL) |
10.0 |
|
MaxRecips_
|
For a list posting, the maximum number of recipients allowed to get this message. ListManager will remove
any members over this limit. If this field is not set, then there is no max. (int, NOT NULL)
|
|
|
MemberID_
|
MemberID of the user who contributed this moderated message (int, NOT NULL)
|
|
|
MessageID_
|
Unique message ID (int, Identity, NOT NULL)
|
|
|
ModHdrDate_
|
If set, this moderated message should have its Date: header rewritten to be the date/time it is approved,
removing the original Date: header stamp (char(1), NOT NULL)
|
|
|
PurgeMess_
|
For a list posting, indicates that the posting should remove recipients who have received the following
archived Message IDs. A space-separated list of IDs. (text, NULL)
|
|
|
ReSubmit_
|
If set, means that when the message is approved, it should be resubmitted for automatic approval after
so many hours (smallint, NOT NULL)
|
|
|
Status_
|
Status of the message: new, processed (varchar(20), NOT NULL)
|
|
|
SplitPartID_
|
The ID of the SplitTest this record is for. NULL or 0 if this record is not part of a splittest. (int,
NULL)
|
|
|
SplitTestID_
|
The ID of the SplitTest this record is for. NULL or 0 if this record is not part of a splittest. (int,
NULL)
|
|
|
SubsetID_
|
The ID of the subset used to create this message. NULL or 0 if no subset was used. (int, NULL)
|
|
|
SuppressionList_
|
List of email addresses (CRLF delimited) not to send this mailing. (text, NULL)
|
Added in 8.8
|
|
SuppressionListCount_
|
Count of email addresses not to send this mailing. (int, NOT NULL).
|
Added in 8.8.
|
|
SynchronizeAfter_
|
If SynchronizeFirst_ is true, this is the oldest allowed date/time of the last synchronization. (datetime,
NULL)
|
Added in 8.8
|
|
SynchronizeFirst_
|
Whether or not to ODBC synchronize the member list before sending mailing. (bool, 'F')
|
Added in 8.8
|
|
Title_
|
Optional title given to this posting -- can only be set independently of the message (ie with web posting
or with 'moderate' commands (varchar(70), NULL)
|
|
|
To_
|
The email address this message was sent to (varchar(100), NULL)
|
|
|
TrackAllUrls_
|
Should URLs in this message be tracked. (bool)
|
9.2
|
|
TrackOpens_
|
Should opens of this message be tracked. (bool)
|
9.2
|
|
Transact_
|
The log of activity for this message. (text, NULL)
|
|
|
Type_
|
Message type: unknown, command, error-mail, auto-refused, bad-to-address (varchar(20), NULL)
|
|