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: