WebSphere Commerce database table: LISTPRICE

Each row of this table represents a ListPrice in a particular currency for a CatalogEntry.


Column Description(s):
Column NameColumn TypeDescription
CATENTRY_ID BIGINT NOT NULL The CatalogEntry.
CURRENCY CHAR(3) NOT NULL The Currency of the ListPrice. This is a currency code as per ISO 4217 standards.
LISTPRICE DECIMAL (20,5) NOT NULL The amount of the ListPrice.
OID VARCHAR(64) Reserved for IBM internal use.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031236690 CURRENCY+CATENTRY_ID Primary Key
I0000145 CURRENCY+CATENTRY_ID+LISTPRICE Non-Unique Index
I0000604 CATENTRY_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_419 CATENTRY_ID CATENTRY CATENTRY_ID Cascade
F_418 CURRENCY SETCURR SETCCURR Cascade

Feedback