Each row of this table represents an Offer to sell
a product identified by a CatalogEntry.
Column Descriptions:
Name | 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 | 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> | OFFER_ID | Primary Key |
I0000165 | CATENTRY_ID+IDENTIFIER+TRADEPOSCN_ID | Unique Index |
I0000167 | CATENTRY_ID+PUBLISHED+TRADEPOSCN_ID | Non-Unique Index |
I0000626 | TRADEPOSCN_ID | Non-Unique Index |
Constrained By Parent Tables:
Constraint | Columns | Parent Table | Parent Columns | Type |
F_467 | TRADEPOSCN_ID | TRADEPOSCN | TRADEPOSCN_ID | Cascade |
F_468 | CATENTRY_ID | CATENTRY | CATENTRY_ID | Cascade |
F_469 | QTYUNIT_ID | QTYUNIT | QTYUNIT_ID | Cascade |
Referenced By Child Tables: