DKOFFERADJMNT

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:

NameTypeDescription
TRADEPOSCN_IDBIGINT NOT NULLTrading position container id.
KIT_IDBIGINT NOT NULLThe dynamic kit CatalogEntry offered for sale.
CATENTRY_IDBIGINT NOT NULLThe component CatalogEntry within the dynamic kit offered for sale.
ADJUSTMENTDECIMAL (20,5) NOT NULL DEFAULT 0Percentage adjustment on the component.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>TRADEPOSCN_ID+KIT_ID+CATENTRY_IDPrimary Key
I0001407KIT_IDNon-Unique Index
I0001408CATENTRY_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3693TRADEPOSCN_IDTRADEPOSCNTRADEPOSCN_IDCascade
F_3694KIT_IDCATENTRYCATENTRY_IDCascade
F_3695CATENTRY_IDCATENTRYCATENTRY_IDCascade