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 Descriptions
| 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 |
| SQL060903235149910
| 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