Database Table: OFFER

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.
Indexes:
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
Constraints:
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

Referenced By:
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