MAIL_MESSAGE

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	SEND_FROM_DATE	DATE	7	Y	Date from which mail is ready for sending
17	MAIL_DELETION_PROFILE_ID	NUMBER	22	Y	References MAIL_DELETION_PROFILE table
18	FROM_USER	VARCHAR2	50	Y	User creating the mail
19	MAILTEMPLATE_ID	NUMBER	22	Y	Mail template used
20	GATEWAY_KEY	VARCHAR2	400	Y

Contains detailed information about all outgoing mail in the system