Each row of this table represents an Offer to sell a product identified by a CatalogEntry.
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 | 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 | 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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000165 | CATENTRY_ID+IDENTIFIER+TRADEPOSCN_ID | Unique Index |
SQL050212031241460 | OFFER_ID | Primary Key |
I0000167 | CATENTRY_ID+PUBLISHED+TRADEPOSCN_ID | Non-Unique Index |
I0000626 | TRADEPOSCN_ID | Non-Unique Index |
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
---|---|---|---|---|
F_468 | CATENTRY_ID | CATENTRY | CATENTRY_ID | Cascade |
F_469 | QTYUNIT_ID | QTYUNIT | QTYUNIT_ID | Cascade |
F_467 | TRADEPOSCN_ID | TRADEPOSCN | TRADEPOSCN_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
---|---|---|---|---|
F_1180 | OFFER_ID | DKPDCOFFERREL | OFFER_ID | Cascade |
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 |