Stores offer 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 |
| TRADEPOSCN_ID | BIGINT NOT NULL | Trading position container 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. |
| OPTCOUNTER | SMALLINT NOT NULL DEFAULT 0 | 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> | TRADEPOSCN_ID+KIT_ID+CATENTRY_ID | Primary Key |
| I0001407 | KIT_ID | Non-Unique Index |
| I0001408 | CATENTRY_ID | Non-Unique Index |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | Type |
| F_3693 | TRADEPOSCN_ID | TRADEPOSCN | TRADEPOSCN_ID | Cascade |
| F_3694 | KIT_ID | CATENTRY | CATENTRY_ID | Cascade |
| F_3695 | CATENTRY_ID | CATENTRY | CATENTRY_ID | Cascade |