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 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 | Reserved for IBM internal use. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000932 | TRADEPOSCN_ID+KIT_ID+CATENTRY_ID+CURRENCY+IDENTIFIER | Unique Index |
SQL050212031221370 | DKOFFER_ID | Primary Key |
I0000903 | KIT_ID | Non-Unique Index |
I0000904 | CATENTRY_ID | Non-Unique Index |
I0000905 | CURRENCY | Non-Unique Index |
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | 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 |