Added in Version 7.0
The MKTGSVC_UNDELIVER table stores all the information collected when an e-mail sent by the marketing service cannot be delivered. This table contains information including, but not limited to, the campaign name, number of times an e-mail was undeliverable, and the reason an e-mail was undeliverable.
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
MKTGSVC_UNDELIVERID (PK) |
char(12) |
NOT NULL |
MKTGSVC_UNDELIVERABLE_ID_PK (CA) |
|
|
|
MKTGSVC_RECIPIENTID (FK) |
char(12) |
NOT NULL |
MKTGSVC_UNDELIVER_RECIPEINTID (IE) |
(Many) to (One) |
|
|
CREATEUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
|
|
BOUNCECAMPAIGNNAME |
varchar(50) |
NULLS |
|
|
|
|
BOUNCECOUNT |
int(4) |
NULLS |
|
|
|
|
BOUNCEDATE |
datetime(8) |
NULLS |
|
|
|
|
BOUNCEREASON |
varchar(128) |
NULLS |
|
|
|