EMLBOUNCED

Records information about bounced messages for e-mail activities. Each row corresponds to a bounced message for a particular recipient of a particular e-mail activity.

Column Descriptions:

NameTypeDescription
EMLPROMO_IDINTEGER NOT NULLThe ID of the e-mail activity that was sent to the user, resulting in a bounced message.
USERS_IDBIGINT NOT NULLThe ID of the target recipient.
STOREENT_IDINTEGER NOT NULLThe ID of the store to which the e-mail activity belongs.
STATUSCODEVARCHAR (10)The status code returned in the DSN from the SMTP server.
LASTBOUNCETIMESTAMPThe time the last bounce for the user occurred from attempting to deliver the email activity.
LASTRETRYTIMESTAMPThe timestamp of the latest attempt to deliver the e-mail activity.
RETRYCOUNTSMALLINTThe number of times the activity delivery was attempted.
MAXRETRYHITSMALLINTThis column contains a flag that indicates whether the e-mail activity has reached the maximum re-try limit. Possible values include: 1 - This bounced message has reached its maximum number of retry attempts 0 - This bounced message has not reached its maximum number of retry attempts
EMLADDRINDEXSMALLINT NOT NULLThis column indicates in which column the target e-mail address is found in the ADDRESS table. Possible values include: 1 - The e-mail address corresponds to the EMAIL1 column of the ADDRESS table 2 - The e-mail address corresponds to the EMAIL2 column of the ADDRESS table
EMAILADDRESSVARCHAR (256)This column contains the target e-mail address for which the delivery attempt resulted in a bounced message.
OPTCOUNTERSMALLINTThe optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>EMLPROMO_ID+USERS_IDPrimary Key
I0000378USERS_IDNon-Unique Index
I0000379EMLPROMO_IDNon-Unique Index
I0000380STOREENT_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_1034EMLPROMO_IDEMLPROMOEMLPROMO_IDCascade
F_1035USERS_IDUSERSUSERS_IDCascade
F_1036STOREENT_IDSTOREENTSTOREENT_IDCascade