Reference > Database > WebSphere Commerce database tables > C
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. This table is being deprecated and this implementation will be replaced by px_promotion related tables since 6.0.
Column Name Column Type Description 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.
Indexes Index Name Indexed Column Names Index Type SQL100520030320410 CPWALLET_ID+ORDERITEMS_ID Primary Key I0000280 ORDERITEMS_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_262 CPWALLET_ID CPWALLET CPWALLET_ID Cascade F_261 ORDERITEMS_ID ORDERITEMS ORDERITEMS_ID Cascade
Related reference
_vcc_freeselect_bottom_