Reference > Database > WebSphere Commerce database tables > O
WebSphere Commerce database table: OFFER
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...
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 Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type I0000165 CATENTRY_ID+IDENTIFIER+TRADEPOSCN_ID Unique Index SQL100520030357850 OFFER_ID Primary Key I0000167 CATENTRY_ID+PUBLISHED+TRADEPOSCN_ID Non-Unique Index I0000626 TRADEPOSCN_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names 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
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names 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
Related reference
- Order trading agreement data model
- Price data model
- Quantity unit - references data model
- Offers data model
_vcc_freeselect_bottom_