This table gives the details of what a promotion is, and reference to its purchase, validity, and discount conditions. 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
| This is the Coupon Promotion ID. This is a primary key.
|
| CPPMNVAL_ID
| INTEGER
| Foreign key to CPPMNVAL table.
|
| STOREENT_ID
| INTEGER NOT NULL
| The ID of the store that owns this coupon promotion.
|
| INITIATIVE_ID
| INTEGER
| Foreign Key to INITIATIVE table, to which this promotion belongs.
|
| SETCCURR
| CHAR(3)
| The default currency for this promotion. This is a currency code as per ISO 4217 standards.
|
| TOTALNUMOFFER
| INTEGER NOT NULL
| Number of coupons to be offered for this promotion. This indicates the accepted number of coupons by the customers.
|
| NUMOFFERED
| INTEGER NOT NULL
| Number of coupons already offered from this promotion.
|
| EARLYBIRDLIMIT
| INTEGER
| Limit for early-bird coupons. If this attribute is NULL, it indicates that the promotion is not of early-bird type.
|
| CREATIONTIME
| TIMESTAMP
| Date and time when this entry was made.
|
| PURCHASECONDTYPE
| CHAR(4) NOT NULL
| This field specifies the promotion purchase condition type. Possible values include:
P=Product
O=Order
|
| NUMSEENALLOWED
| INTEGER NOT NULL
| This field denotes the number of times this promotion should be offered to the user. Valid for only banner ads not for OfferLists.
|
| FIELD1
| VARCHAR(64)
| Customizable.
|
| PROMODISPTYPE
| CHAR(4) NOT NULL
| Stores how the promotion was communicated. That is, where is it shown. Possible values include:
B=Banner Ad
E=E-mail
O=OfferList
|
| NUMUSEALLOWED
| INTEGER NOT NULL
| Number of times this coupon can be redeemed.
|
| STATUS
| CHAR(1) NOT NULL
| Indicates the status of the coupon promotion. Valid values include:
A=active
D=deleted
E=expired
|
| CPPMNNAME
| CHAR(64) NOT NULL
| Name of the coupon promotion.
|
| CPPMNDESC
| CHAR(254)
| Description of the coupon promotion (for merchant viewing).
|
| STARTDATE
| TIMESTAMP NOT NULL
| The date before which this coupon promotion will not be effective.
|
| ENDDATE
| TIMESTAMP
| The date after which this coupon promotion will not be effective.
|
| NUMACPALLOWED
| INTEGER NOT NULL DEFAULT 1
| This is the number of coupons from a coupon promotion that can be accepted by a single user. The default value is 1.
|
| OPTCOUNTER
| SMALLINT
| Reserved for IBM internal use.
|