DKOFFERADJMNT

Stores offer adjustments to components within a specific dynamic kit.


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