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_


+

Search Tips   |   Advanced Search