WebSphere Commerce database table: CPITMAP

This table stores all of the items from the given (completed) order that were applicable to the selected coupon set.


Column Description(s):
Column NameColumn TypeDescription
CPWALLET_ID BIGINT NOT NULL Foreign key to the CPWALLET table. This is a primary key.
ORDERITEMS_ID BIGINT NOT NULL Foreign key to the ORDERITEMS table. This is a primary key.
DISCAMT DECIMAL (20,5) NOT NULL The discount amount applied to this item when this coupon is used.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031217270 CPWALLET_ID+ORDERITEMS_ID Primary Key
I0000280 ORDERITEMS_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_262 CPWALLET_ID CPWALLET CPWALLET_ID Cascade
F_261 ORDERITEMS_ID ORDERITEMS ORDERITEMS_ID Cascade

Feedback