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 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 Name | Indexed Column Names | Index Type |
---|---|---|
SQL050212031259500 | TERMCOND_ID+PRODUCTSET_ID | Primary Key |
I0000703 | PRODUCTSET_ID | Non-Unique Index |
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
---|---|---|---|---|
F_921 | PRODUCTSET_ID | PRODUCTSET | PRODUCTSET_ID | Cascade |
F_922 | TERMCOND_ID | TERMCOND | TERMCOND_ID | Cascade |