Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 RECIPIENTDATA xml   This field will containt the recipient dataset for this email.
 EMAILHEADER xml   Contains the email information (except for the body). Fields such as To, From, etc. with merge field placeholders.
 CONTENTTEXT nvarchar(max)   Default = '' Contains the email content information in text format with merge field placeholders.
 CONTENTHTML nvarchar(max)   Default = '' Contains the email content information in HTML format with merge field placeholders.
 THREADID uniqueidentifier   Contains a unique guid used to determine which emails are being processed by current loop
 RETRYNUMBER tinyint   Default = 0 Contains a 0 based number indicating which retry we are currently on.
 DATEADDEDTOQUEUE datetime   Default = getdate() Contains the date and time the email was added to the queue. This is needed since the Audit trail fields are not included.
 SOURCE int   Default = 0 Identifies the calling application. Used to determine priority.

Index Name Field(s) Unique Primary Clustered
 IX_EMAILQUEUETRANSACTIONAL_THREADID THREADID      
 PK_EMAILQUEUETRANSACTIONAL ID

Referenced by Field
 EMAILSTATUSTRANSACTIONAL EMAILQUEUETRANSACTIONALID

Entity-Relationship diagram of this table