Reference > Database > WebSphere Commerce database tables > P
WebSphere Commerce database table: PSETADJMNT
This table stores information on product set adjustments and shows which product set is referenced by a term and condition for a business policy.
Column Name Column Type Description TERMCOND_ID BIGINT NOT NULL The terms and conditions ID. PRODUCTSET_ID INTEGER NOT NULL The product set ID. TYPE INTEGER NOT NULL Specifies whether the product set should be included or excluded:
0 = Category inclusion
1 = Category exclusion
2 = Product inclusion
3 = Product exclusion
4 = Browsable inclusionADJUSTMENT DECIMAL (20,5) NOT NULL DEFAULT 0 Percentage adjustment on the product set. PRECEDENCE INTEGER NOT NULL DEFAULT 0 The order in which to apply the adjustment. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030414990 TERMCOND_ID+PRODUCTSET_ID Primary Key I0000703 PRODUCTSET_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_921 PRODUCTSET_ID PRODUCTSET PRODUCTSET_ID Cascade F_922 TERMCOND_ID TERMCOND TERMCOND_ID Cascade
Related reference
_vcc_freeselect_bottom_