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 Description(s):
Column NameColumn TypeDescription
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 inclusion
ADJUSTMENT 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.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031259500 TERMCOND_ID+PRODUCTSET_ID Primary Key
I0000703 PRODUCTSET_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_921 PRODUCTSET_ID PRODUCTSET PRODUCTSET_ID Cascade
F_922 TERMCOND_ID TERMCOND TERMCOND_ID Cascade

Feedback