OFFER

Each row of this table represents an Offer to sell a product identified by a CatalogEntry.

Column Descriptions:

NameTypeDescription
OFFER_IDBIGINT NOT NULLGenerated unique key.
STARTDATETIMESTAMPThe start of the time range during which this Offer is effective.
TRADEPOSCN_IDBIGINT NOT NULLThe TradingPositionContainer this Offer is part of.
CATENTRY_IDBIGINT NOT NULLThe CatalogEntry offered for sale.
ENDDATETIMESTAMPThe end of the time range during which this Offer is effective.
PRECEDENCEDOUBLE NOT NULL DEFAULT 0When more than one Offer is effective at a particular time, the one with the highest PRECEDENCE is used.
PUBLISHEDINTEGER NOT NULL DEFAULT 0Describes whether or not the offer has been published as follows: 0 = not published (temporarily disabled). 1 = published. 2 = marked for deletion (and not published).
LASTUPDATETIMESTAMPThe last time this Offer was updated.
MINIMUMQUANTITYDOUBLEThe minimum quantity that can be purchased in a single Order under this Offer.
QTYUNIT_IDCHAR (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.
MAXIMUMQUANTITYDOUBLEThe maximum quantity that can be purchased in a single Order under this Offer.
FIELD1CHAR (30)Customizable.
FIELD2CHAR (1)Customizable.
FLAGSINTEGER NOT NULL DEFAULT 1Reserved for IBM internal use.
IDENTIFIERBIGINTA number that uniquely identifies this Offer along with its specified CatalogEntry and TradingPositionContainer.
OIDVARCHAR (64)Reserved for IBM internal use.
OPTCOUNTERSMALLINTThe optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>OFFER_IDPrimary Key
I0000165CATENTRY_ID+IDENTIFIER+TRADEPOSCN_IDUnique Index
I0000167CATENTRY_ID+PUBLISHED+TRADEPOSCN_IDNon-Unique Index
I0000626TRADEPOSCN_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_467TRADEPOSCN_IDTRADEPOSCNTRADEPOSCN_IDCascade
F_468CATENTRY_IDCATENTRYCATENTRY_IDCascade
F_469QTYUNIT_IDQTYUNITQTYUNIT_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_1180OFFER_IDDKPDCOFFERRELOFFER_IDCascade
F_470OFFER_IDOFFERDESCOFFER_IDCascade
F_472OFFER_IDOFFERPRICEOFFER_IDCascade
F_506OFFER_IDORDERITEMSOFFER_IDCascade
F_525OFFER_IDORDIOFFEROFFER_IDCascade