Reference > Database > WebSphere Commerce database tables > T
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 Name Column Type Description 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.
Indexes Index Name Indexed Column Names Index Type SQL100520030438100 CPWALLET_ID+ORDERITEMS_ID Primary Key I0000281 ORDERITEMS_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_828 CPWALLET_ID CPWALLET CPWALLET_ID Cascade F_827 ORDERITEMS_ID ORDERITEMS ORDERITEMS_ID Cascade
Related reference
_vcc_freeselect_bottom_