MAIL_MESSAGE_SENT
- Daniel Hostrup Eriksen
- Søren Duusgaard (Deactivated)
Owned by Daniel Hostrup Eriksen
Groups
MAIL_MESSAGE_SENT
| Column Name | Data Type | Field Length | Not 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 |
DELETABLE_FROM_DATE | DATE | 7 | Y | Â | Date from which mail can be deleted |
FROM_USER | VARCHAR2 | 50 | Y | Â | User creating the mail |
MAILTEMPLATE_ID | NUMBER | 22 | Y | Â | Mail template used |
| OBJECT_ID | NUMBER | Â | Â | Â | With v 9.8 |
| OBJECT_CLASS | VARCHAR2 | 100 | Â | Â | With v 9.8 |
Contains all email messages already sent by the system