Column Name	Data Type	Field Length	Not Null?	Comments
ID	NUMBER	22	N	'Primary' key
STATUS_ID	NUMBER	22	Y	Email status: 0-ready, 1-sent, 9 error
CREATE_DATE	DATE	7	Y	Date of creating email
SENT_DATE	DATE	7	Y	Date of sending email
TO_ADDRESSES	VARCHAR2	1000	Y	Email destination address
CC_ADDRESSES	VARCHAR2	1000	Y	CC destination address
BCC_ADDRESSES	VARCHAR2	1000	Y	BCC destination address
SUBJECT	VARCHAR2	500	Y	Email subject
MESSAGE	VARCHAR2	4000	Y	Email text
FROM_NAME	VARCHAR2	100	Y	Email sender
FROM_EMAIL	VARCHAR2	100	Y	Email sender address
TYPE_ID	NUMBER	22	Y	Type of email, 0-plain text, 1-sent
ERROR_MESSAGE	VARCHAR2	1000	Y	Error message in case of send failure
PRIORITY	VARCHAR2	2	Y	Send priority
MARKETING_CAMPAIGN_ID	NUMBER	22	Y	References MARKETING_CAMPAIGN table
SEND_FROM_DATE	DATE	7	Y	Date from which mail is ready for sending
MAIL_DELETION_PROFILE_ID	NUMBER	22	Y	References MAIL_DELETION_PROFILE table
FROM_USER	VARCHAR2	50	Y	User creating the mail
MAILTEMPLATE_ID	NUMBER	22	Y	Mail template used
GATEWAY_KEY	VARCHAR2	400	Y
OBJECT_ID	NUMBER			With v 9.8
OBJECT_CLASS	VARCHAR2	100		With v 9.8

Contains detailed information about all outgoing mail in the system

Browser not supported