MAIL_MESSAGE_SENT

Unknown macro: {float}

Col #	Column Name	Data Type	Field Length	Not Null?	Comments
1	ID	NUMBER	22	N	Primary key
2	STATUS_ID	NUMBER	22	Y	Email status: 0-ready, 1-sent, 9 error
3	CREATE_DATE	DATE	7	Y	Date of creating email
4	SENT_DATE	DATE	7	Y	Date of sending email
5	TO_ADDRESSES	VARCHAR2	1000	Y	Email destination address
6	CC_ADDRESSES	VARCHAR2	1000	Y	CC destination address
7	BCC_ADDRESSES	VARCHAR2	1000	Y	BCC destination address
8	SUBJECT	VARCHAR2	500	Y	Email subject
9	MESSAGE	VARCHAR2	4000	Y	Email text
10	FROM_NAME	VARCHAR2	100	Y	Email sender
11	FROM_EMAIL	VARCHAR2	100	Y	Email sender address
12	TYPE_ID	NUMBER	22	Y	Type of email, 0-plain text, 1-sent
13	ERROR_MESSAGE	VARCHAR2	1000	Y	Error message in case of send failure
14	PRIORITY	VARCHAR2	2	Y	Send priority
15	MARKETING_CAMPAIGN_ID	NUMBER	22	Y	References MARKETING_CAMPAIGN table
16	DELETABLE_FROM_DATE	DATE	7	Y	Date from which mail can be deleted
17	FROM_USER	VARCHAR2	50	Y	User creating the mail
18	MAILTEMPLATE_ID	NUMBER	22	Y	Mail template used

Contains all email messages already sent by the system