Column Descriptions
| 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.
|