Reference > Database > WebSphere Commerce database tables > C


WebSphere Commerce database table: CURLIST

Each row of this table represents an explicitly supported currency for a StoreEntity. A Store implicitly supports all its default currencies (see the STOREENT and STORELANG tables), and all currencies supported by its StoreGroup.

Column Name Column Type Description
STOREENT_ID INTEGER NOT NULL The StoreEntity.
CURRSTR CHAR(3) NOT NULL The supported currency. A store must be able to accept payment in all its supported currencies. This is a currency code as per ISO 4217 standards.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL100520030323430 CURRSTR+STOREENT_ID Primary Key
I0000553 STOREENT_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_295 CURRSTR SETCURR SETCCURR Cascade
F_296 STOREENT_ID STOREENT STOREENT_ID Cascade


Related reference

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search