WebSphere Commerce database table: TCPITMAP

This table stores all of the items from the shopping cart that are applicable to the current coupon for the Coupon Decision Support system.


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

Feedback