Reference > Database > WebSphere Commerce database tables > D
WebSphere Commerce database table: DKOFFER
Stores prices of components within a dynamic kit
Column Name Column Type Description DKOFFER_ID BIGINT NOT NULL Generated unique key. TRADEPOSCN_ID BIGINT NOT NULL The TradingPositionContainer to which this dynamic kit offer belongs. 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. CURRENCY CHAR(3) NOT NULL The currency of the price. This is a currency code as per ISO 4217 standards. IDENTIFIER BIGINT A number that uniquely identifies this Offer along with its specified CatalogEntry and TradingPositionContainer. PRICE DECIMAL (20,5) NOT NULL Price of the component within the dynamic kit. STARTDATE TIMESTAMP The start of the time range during which this offer is effective. ENDDATE TIMESTAMP The end of the time range during which this offer is effective. MINIMUMQUANTITY DOUBLE The minimum quantity that can be purchased in a single Order under this offer. MAXIMUMQUANTITY DOUBLE The maximum quantity that can be purchased in a single Order under this offer. PRECEDENCE DOUBLE NOT NULL DEFAULT 0 When more than one Offer is effective at a particular time, the one with the highest PRECEDENCE is used. PUBLISHED INTEGER NOT NULL DEFAULT 1 Describes whether or not the offer has been published...
0 = not published (temporarily disabled).
1 = published.
2 = marked for deletion (and not published).FIELD1 CHAR(30) Customizable. FIELD2 CHAR(1) Customizable. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type I0000932 TRADEPOSCN_ID+KIT_ID+CATENTRY_ID+CURRENCY+IDENTIFIER Unique Index SQL100520030324670 DKOFFER_ID Primary Key I0000903 KIT_ID Non-Unique Index I0000904 CATENTRY_ID Non-Unique Index I0000905 CURRENCY Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_1151 KIT_ID CATENTRY CATENTRY_ID Cascade F_1152 CATENTRY_ID CATENTRY CATENTRY_ID Cascade F_1153 CURRENCY SETCURR SETCCURR Cascade F_1150 TRADEPOSCN_ID TRADEPOSCN TRADEPOSCN_ID Cascade _vcc_freeselect_bottom_