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 Description(s):
Column NameColumn TypeDescription
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.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031220360 CURRSTR+STOREENT_ID Primary Key
I0000553 STOREENT_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_295 CURRSTR SETCURR SETCCURR Cascade
F_296 STOREENT_ID STOREENT STOREENT_ID Cascade

Feedback