WebSphere Commerce database table: OFFERPRICE

Each row of this table represents a price in a currency for an Offer.


Column Description(s):
Column NameColumn TypeDescription
OFFER_ID BIGINT NOT NULL The Offer.
CURRENCY CHAR(3) NOT NULL The currency of the price. This is a currency code as per ISO 4217 standards.
PRICE DECIMAL (20,5) NOT NULL The price for the nominal quantity (see CATENTSHIP.NOMINALQUANTITY) of the product referred to by the Offer.
COMPAREPRICE DECIMAL (20,5) Reserved for IBM internal use.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031241760 OFFER_ID+CURRENCY Primary Key
I0000168 PRICE+CURRENCY+OFFER_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_472 OFFER_ID OFFER OFFER_ID Cascade
F_473 CURRENCY SETCURR SETCCURR Cascade

Feedback