DKADJMNT

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:

NameTypeDescription
TERMCOND_IDBIGINT NOT NULLThe terms and conditions 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.
ADJTYPEINTEGER NOT NULL DEFAULT 0Specifies whether the component should be included or excluded: 0 = include 1 = exclude
OPTCOUNTERSMALLINTThe 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>TERMCOND_ID+KIT_ID+CATENTRY_IDPrimary Key
I0000906KIT_IDNon-Unique Index
I0000907CATENTRY_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_1154TERMCOND_IDTERMCONDTERMCOND_IDCascade
F_1155KIT_IDCATENTRYCATENTRY_IDCascade
F_1156CATENTRY_IDCATENTRYCATENTRY_IDCascade