Reference > Database > WebSphere Commerce database tables > L
WebSphere Commerce database table: LISTPRICE
Each row of this table represents a ListPrice in a particular currency for a CatalogEntry.
Column Name Column Type Description 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.
Indexes Index Name Indexed Column Names Index Type SQL100520030350900 CURRENCY+CATENTRY_ID Primary Key I0000145 CURRENCY+CATENTRY_ID+LISTPRICE Non-Unique Index I0000604 CATENTRY_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_419 CATENTRY_ID CATENTRY CATENTRY_ID Cascade F_418 CURRENCY SETCURR SETCCURR Cascade
Related reference
_vcc_freeselect_bottom_