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 Column Description
CURRSTR CHARACTER (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.
STOREENT_ID INTEGER
NOT NULL
The StoreEntity.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416034920740 CURRSTR, STOREENT_ID Primary Key
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

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable