Field Name
|
Description
|
Version Added
|
BeingProcessedBy_
|
The machine name that is currently processing this inmail record. For use in clustering. (varchar(25),
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)
|
|
Created_
|
Date the message was entered in the queue (datetime, NULL)
|
|
DeliverBefore_
|
After this time the message should not be delivered. (smalldatetime, NULL)
|
|
DetectHTML_
|
Should this inmail detect HTML use. (bool)
|
|
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
|
HdrAll_
|
The complete message header (text, NULL)
|
|
HdrDate_
|
The 'date:' header (varchar(100), NULL)
|
|
HdrFrom_
|
The 'from:' header (varchar(238), NULL)
|
|
HdrFromSpc_
|
The 'from' header (varchar(200), NULL)
|
|
HdrSubject_
|
The 'subject:' header (varchar(2001000), NULL)
|
|
HdrTo_
|
The 'to:' header (varchar(200), NULL)
|
|
List_
|
The list that this message belongs to (varchar(6070), NULL)
|
|
MailStreamID_
|
The MailStream associated with this Mailing (int, NULL) |
|
MaxRecips_
|
For a list posting, the maximum number of recipients allowed to get this message. ListManager will remove
any members so that this max is not reached. (int, NOT NULL)
|
|
MessageID_
|
Unique message ID (int, identity, NOT NULL)
|
|
ModerApp_
|
Has this message been moderation approved? (bool)
|
|
NextAttempt_
|
Next time that inmail_ will be processed (smalldatetime, NULL)
|
8.95
|
NodeID_
|
The identifier for this node, references into lyrConfigNodeSettings. (int, null)
|
8.0
|
NumFailures_
|
Number of times that processing this record has failed
|
8.95
|
Priority_
|
Current unused. (tinyint, NOT NULL)
|
|
PurgeMess_
|
For a list posting, indicates that the posting should remove recipients who have received the following
archived message ids. (text, 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)
|
|
Status_
|
Status of the message: processed (varchar(20), NOT NULL)
|
|
SubsetID_
|
The ID of the subset sent to for this inmail. 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
|
Title_
|
The title of this message (varchar(70), NULL)
|
|
To_
|
The email address this message was sent to (varchar(200), NULL)
|
|
TrackOpens_
|
Should opens of this inmail be tracked. (bool)
|
|
Transact_
|
Transaction log for each record (text, NULL)
|
|
Type_
|
Message type: list, command, error-mail, auto-refused, bad-to-address (varchar(10), NULL)
|
|