WebSphere Commerce database table: DKOFFER

DKOFFER

Stores prices of components within a dynamic kit. This table is not used with the Sterling Configurator dynamic kit integration provided with WebSphere Commerce Feature Pack 3.

Column Descriptions:

Name 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 as follows:
0 = not published (temporarily disabled).
1 = published.
2 = marked for deletion (and not published).
FIELD1 CHAR (30) Customizable.
FIELD2 CHAR (1) Customizable.
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> DKOFFER_ID Primary Key
I0000932 TRADEPOSCN_ID+KIT_ID+CATENTRY_ID+CURRENCY+IDENTIFIER Unique Index
I0000903 KIT_ID Non-Unique Index
I0000904 CATENTRY_ID Non-Unique Index
I0000905 CURRENCY Non-Unique Index

Constrained By Parent Tables:

Constraint Columns Parent Table Parent Columns Type
F_1150 TRADEPOSCN_ID TRADEPOSCN TRADEPOSCN_ID Cascade
F_1151 KIT_ID CATENTRY CATENTRY_ID Cascade
F_1152 CATENTRY_ID CATENTRY CATENTRY_ID Cascade
F_1153 CURRENCY SETCURR SETCCURR Cascade

Name	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 as follows: 0 = not published (temporarily disabled). 1 = published. 2 = marked for deletion (and not published).
FIELD1	CHAR (30)	Customizable.
FIELD2	CHAR (1)	Customizable.
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.

Name	Column Names	Type
<SYSTEM-GENERATED>	DKOFFER_ID	Primary Key
I0000932	TRADEPOSCN_ID+KIT_ID+CATENTRY_ID+CURRENCY+IDENTIFIER	Unique Index
I0000903	KIT_ID	Non-Unique Index
I0000904	CATENTRY_ID	Non-Unique Index
I0000905	CURRENCY	Non-Unique Index

Constraint	Columns	Parent Table	Parent Columns	Type
F_1150	TRADEPOSCN_ID	TRADEPOSCN	TRADEPOSCN_ID	Cascade
F_1151	KIT_ID	CATENTRY	CATENTRY_ID	Cascade
F_1152	CATENTRY_ID	CATENTRY	CATENTRY_ID	Cascade
F_1153	CURRENCY	SETCURR	SETCCURR	Cascade