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 |