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:

Name	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 NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	CURRSTR+STOREENT_ID	Primary Key
I0000553	STOREENT_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_295	CURRSTR	SETCURR	SETCCURR	Cascade
F_296	STOREENT_ID	STOREENT	STOREENT_ID	Cascade

Related reference
Currency data model