Reference > Database > WebSphere Commerce database tables > C
WebSphere Commerce database table: CPPMNORD
This table contains the minimum purchase amount that must be in the shopping cart before this coupon is applicable. 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 Foreign key to the CPPMN table. ORDERMIN DECIMAL (20,5) NOT NULL Minimum purchase amount that must be in the shopping cart. ORDERMAX DECIMAL (20,5) Maximum purchase amount allowed in the shopping cart. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030321490 CPPMN_ID Primary Key
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_273 CPPMN_ID CPPMN CPPMN_ID Cascade
Related reference
_vcc_freeselect_bottom_