Stores adjustments to components within a specific
dynamic kit. This table is not used with the Sterling Configurator
dynamic kit integration provided with WebSphere Commerce Feature
Pack 3.
Column Descriptions:
| Name | 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 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
| Name | Column Names | Type |
| <SYSTEM-GENERATED> | TERMCOND_ID+KIT_ID+CATENTRY_ID | Primary Key |
| I0000906 | KIT_ID | Non-Unique Index |
| I0000907 | CATENTRY_ID | Non-Unique Index |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | Type |
| F_1154 | TERMCOND_ID | TERMCOND | TERMCOND_ID | Cascade |
| F_1155 | KIT_ID | CATENTRY | CATENTRY_ID | Cascade |
| F_1156 | CATENTRY_ID | CATENTRY | CATENTRY_ID | Cascade |