Stores adjustments to components within a specific dynamic kit.
Column Name | Column Type | Description |
---|---|---|
TERMCOND_ID | BIGINT NOT NULL | The terms and conditions ID. |
KIT_ID | BIGINT NOT NULL | The dynamic kit CatalogEntry offered for sale. |
CATENTRY_ID | BIGINT NOT NULL | The component CatalogEntry within the dynamic kit offered for sale. |
ADJUSTMENT | DECIMAL (20,5) NOT NULL DEFAULT 0 | Percentage adjustment on the component. |
ADJTYPE | INTEGER NOT NULL DEFAULT 0 | Specifies whether the component should be included or excluded: 0 = include 1 = exclude |
OPTCOUNTER | SMALLINT | Reserved for IBM internal use. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL050212031221220 | TERMCOND_ID+KIT_ID+CATENTRY_ID | Primary Key |
I0000906 | KIT_ID | Non-Unique Index |
I0000907 | CATENTRY_ID | Non-Unique Index |
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
---|---|---|---|---|
F_1155 | KIT_ID | CATENTRY | CATENTRY_ID | Cascade |
F_1156 | CATENTRY_ID | CATENTRY | CATENTRY_ID | Cascade |
F_1154 | TERMCOND_ID | TERMCOND | TERMCOND_ID | Cascade |