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 Column Description
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.
PRODUCTSET_ID INTEGER
NOT NULL
The product set ID.
TERMCOND_ID BIGINT
NOT NULL
The terms and conditions 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
Indexes:
Index Name Indexed Column Names Index Type
SQL030416035041550 TERMCOND_ID, PRODUCTSET_ID Primary Key
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

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable