Reference > Database > WebSphere Commerce database tables > C
WebSphere Commerce database table: CPPMN
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 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=OrderNUMSEENALLOWED 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=OfferListNUMUSEALLOWED 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=expiredCPPMNNAME 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.
Indexes Index Name Indexed Column Names Index Type I0000289 CPPMNNAME+STOREENT_ID Unique Index SQL100520030320730 CPPMN_ID Primary Key I0000302 ENDDATE Non-Unique Index I0000546 STOREENT_ID Non-Unique Index I0001251 INITIATIVE_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_267 CPPMNVAL_ID CPPMNVAL CPPMNVAL_ID Cascade F_266 INITIATIVE_ID INITIATIVE INITIATIVE_ID Cascade F_268 SETCCURR SETCURR SETCCURR Cascade F_265 STOREENT_ID STOREENT STOREENT_ID Cascade
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_264 CPPMN_ID CPOFFER CPPMN_ID Cascade F_975 CPPMN_ID CPPMNACC CPPMN_ID Cascade F_976 CPPMN_ID CPPMNCAT CPPMN_ID Cascade F_270 CPPMN_ID CPPMNDESC CPPMN_ID Cascade F_271 CPPMN_ID CPPMNDISC CPPMN_ID Cascade F_273 CPPMN_ID CPPMNORD CPPMN_ID Cascade F_275 CPPMN_ID CPPMNPROD CPPMN_ID Cascade F_277 CPPMN_ID CPWALLET CPPMN_ID Cascade
Related reference
_vcc_freeselect_bottom_