WebSphere Commerce database table: CPPMNORD

This table contains the minimum purchase amount that must be in the shopping cart before this coupon is applicable.


Column Description(s):
Column NameColumn TypeDescription
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.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031218230 CPPMN_ID Primary Key
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_273 CPPMN_ID CPPMN CPPMN_ID Cascade

Feedback