/
MAIL_CAMPAIGN
MAIL_CAMPAIGN
Groups
MAIL_CAMPAIGN
Column Name | Data Type | Field Length | Not Null? | Data Def. | Comments |
---|---|---|---|---|---|
ID | NUMBER | 22 | N | ||
STATUS_ID | NUMBER | 22 | Y | ||
NAME | VARCHAR2 | 100 | Y | ||
POP_SUBJECT | VARCHAR2 | 100 | Y | ||
MAIL_TEMPLATE_ID | NUMBER | 22 | Y | ||
TYPE_ID | NUMBER | 22 | Y | ||
FROM_NAME | VARCHAR2 | 100 | Y | ||
FROM_EMAIL | VARCHAR2 | 100 | Y | ||
NEXT_DATE | DATE | 7 | Y | ||
INTERVAL | NUMBER | 22 | Y | ||
INTERVAL_TYPE | CHAR | 1 | Y | ||
IS_INTERNAL_MAIL | CHAR | 1 | Y | ||
MAIL_CAMPAIGN_METHOD | VARCHAR2 | 50 | Y | ||
MAIL_CAMPAIGN_HANDLER | VARCHAR2 | 50 | Y | ||
START_TIME | DATE | 7 | Y | ||
NEXT_DATE_SQL | VARCHAR2 | 1000 | Y | ||
CODE | VARCHAR2 | 10 | Y | ||
AS_ATTACHMENT | CHAR | 1 | Y | ||
SAVE_ONLY | CHAR | 1 | Y | ||
PUBLIC_ATTACHMENT | VARCHAR2 | 500 | Y | ||
BRANDED_CAMPAIGN | VARCHAR2 | 4 | Y | ||
MAIL_TEMPLATE_KEY | VARCHAR2 | 800 | Y | ||
CATEGORY | VARCHAR2 | 200 | Y | ||
CSV_ATTACHMENT_FIELD_SEPARATOR | VARCHAR2(1) | With Vs 10 |
, multiple selections available,