Reference > Database > WebSphere Commerce database tables > D
WebSphere Commerce database table: DKADJMNT
Stores adjustments to components within a specific dynamic kit.
Column Name Column Type Description TERMCOND_ID BIGINT NOT NULL The terms and conditions 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. ADJTYPE INTEGER NOT NULL DEFAULT 0 Specifies whether the component should be included or excluded:
0 = include
1 = excludeOPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030324430 TERMCOND_ID+KIT_ID+CATENTRY_ID Primary Key I0000906 KIT_ID Non-Unique Index I0000907 CATENTRY_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_1155 KIT_ID CATENTRY CATENTRY_ID Cascade F_1156 CATENTRY_ID CATENTRY CATENTRY_ID Cascade F_1154 TERMCOND_ID TERMCOND TERMCOND_ID Cascade _vcc_freeselect_bottom_