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
| Column Name
| Column Type
| Description |
| EMLPROMO_ID
| INTEGER NOT NULL
| The ID of the e-mail activity that was sent to the user, resulting in a bounced message.
|
| USERS_ID
| BIGINT NOT NULL
| The ID of the target recipient.
|
| STOREENT_ID
| INTEGER NOT NULL
| The ID of the store to which the e-mail activity belongs.
|
| STATUSCODE
| VARCHAR(10)
| The status code returned in the DSN from the SMTP server.
|
| LASTBOUNCE
| TIMESTAMP
| The time the last bounce for the user occurred from attempting to deliver the email activity.
|
| LASTRETRY
| TIMESTAMP
| The timestamp of the latest attempt to deliver the e-mail activity.
|
| RETRYCOUNT
| SMALLINT
| The number of times the activity delivery was attempted.
|
| MAXRETRYHIT
| SMALLINT
| This 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
|
| EMLADDRINDEX
| SMALLINT NOT NULL
| This 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
|
| EMAILADDRESS
| VARCHAR(256)
| This column contains the target e-mail address for which the delivery attempt resulted in a bounced message.
|
| OPTCOUNTER
| SMALLINT
| Reserved for IBM internal use.
|