Each row of this table represents an Offer to sell a product identified by a CatalogEntry.
Column Name | Column Type | Column Description |
---|---|---|
CATENTRY_ID | BIGINT NOT NULL |
The CatalogEntry offered for sale. |
ENDDATE | TIMESTAMP NULL |
The end of the time range during which this Offer is effective. |
FIELD1 | CHARACTER (30) NULL |
Customizable. |
FIELD2 | CHARACTER (1) NULL |
Customizable. |
FLAGS | INTEGER NOT NULL, DEFAULT 1 |
Contains the following bit flag value: 1 = shiptoAddressRequired - if 1, OrderPrepare will return an error if an OrderItem references this Offer but does not have a shipping address. |
IDENTIFIER | BIGINT NULL |
A number that uniquely identifies this Offer along with its specified CatalogEntry and TradingPositionContainer. |
LASTUPDATE | TIMESTAMP NULL |
The last time this Offer was updated. |
MAXIMUMQUANTITY | DOUBLE NULL |
The maximum quantity that can be purchased in a single Order under this Offer. |
MINIMUMQUANTITY | DOUBLE NULL |
The minimum quantity that can be purchased in a single Order under this Offer. |
OFFER_ID | BIGINT NOT NULL |
Generated unique key. |
OID | VARCHAR (64) NULL |
Reserved for IBM internal use. |
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). |
QTYUNIT_ID | CHARACTER (16) NULL |
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. |
STARTDATE | TIMESTAMP NULL |
The start of the time range during which this Offer is effective. |
TRADEPOSCN_ID | BIGINT NOT NULL |
The TradingPositionContainer this Offer is part of. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000165 | CATENTRY_ID, IDENTIFIER, TRADEPOSCN_ID | Unique Index |
I0000167 | CATENTRY_ID, PUBLISHED, TRADEPOSCN_ID | Non-Unique Index |
SQL030416035009530 | OFFER_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint 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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_470 | OFFER_ID | OFFERDESC | OFFER_ID | Cascade |
F_472 | OFFER_ID | OFFERPRICE | OFFER_ID | Cascade |
F_506 | OFFER_ID | ORDERITEMS | OFFER_ID | Cascade |
F_525 | OFFER_ID | ORDIOFFER | OFFER_ID | Cascade |