Each row of this table represents an Offer to sell a product identified by a CatalogEntry.
Column Descriptions
| Column Name
| Column Type
| Description
|
| OFFER_ID
| BIGINT NOT NULL
| Generated unique key.
|
| STARTDATE
| TIMESTAMP
| The start of the time range during which this Offer is effective.
|
| TRADEPOSCN_ID
| BIGINT NOT NULL
| The TradingPositionContainer this Offer is part of.
|
| CATENTRY_ID
| BIGINT NOT NULL
| The CatalogEntry offered for sale.
|
| ENDDATE
| TIMESTAMP
| The end of the time range during which this Offer is effective.
|
| 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 0
| 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).
|
| LASTUPDATE
| TIMESTAMP
| The last time this Offer was updated.
|
| MINIMUMQUANTITY
| DOUBLE
| The minimum quantity that can be purchased in a single Order under this Offer.
|
| QTYUNIT_ID
| CHAR(16)
| The unit of measure for MINIMUMQUANTITY and MAXIMUMQUANTITY. If this is NULL, then MINIMUMQUANTITY and MAXIMUMQUANTITY are multiplied by CATENTSHIP.NOMINALQUANTITY and the unit of measure of the results is CATENTSHIP.QUANTITYMEASURE.
|
| MAXIMUMQUANTITY
| DOUBLE
| The maximum quantity that can be purchased in a single Order under this Offer.
|
| FIELD1
| CHAR(30)
| Customizable.
|
| FIELD2
| CHAR(1)
| Customizable.
|
| FLAGS
| INTEGER NOT NULL DEFAULT 1
| Reserved for IBM internal use.
|
| IDENTIFIER
| BIGINT
| A number that uniquely identifies this Offer along with its specified CatalogEntry and TradingPositionContainer.
|
| OID
| VARCHAR(64)
| Reserved for IBM internal use.
|
| OPTCOUNTER
| SMALLINT
| Reserved for IBM internal use.
|