OFFER
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 NOT NULL DEFAULT 0 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:
Constraint Columns Child Table Child Columns 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
Related concepts
How WebSphere Commerce selects the correct price from the OFFER database table
Related reference
Offers data model
Order trading agreement data model
Pricing data model
Quantity unit - references data model