MAIL_MESSAGE

Owned by Daniel Hostrup Eriksen
Last updated: 10.11.2014 by Søren Duusgaard (Deactivated)

Groups

MAIL_MESSAGE

Column NameData TypeField LengthNot Null?Data Def.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_IDNUMBER   With v 9.8
OBJECT_CLASSVARCHAR2100  With v 9.8

Contains detailed information about all outgoing mail in the system