This table stores the number of times a coupon has been accepted from the coupon promotion by the guest customer identified by the e-mail ID. It also stores the number of times the customer has redeemed coupons from this promotion. This table is being deprecated and this implementation will be replaced by px_promotion related tables since 6.0.
Column Descriptions
| Column Name
| Column Type
| Description |
| CPPMN_ID
| INTEGER NOT NULL
| Foreign key to the CPPMN table. This is the promotion ID. This is a primary table.
|
| SHOPPEREMAILID
| CHAR(64) NOT NULL
| Primary key. The e-mail ID of the customer.
|
| NUMACCEPTED
| INTEGER NOT NULL DEFAULT 0
| Reserved for IBM internal use.
|
| NUMREDEEMED
| INTEGER NOT NULL DEFAULT 0
| Number of times the customer has redeemed coupons of this promotion.
|
| OPTCOUNTER
| SMALLINT
| Reserved for IBM internal use.
|