CURCVLIST

Each row of this table represents a CounterCurrencyPair. The primary use of this information is for "dual display" of European Monetary Union monetary amounts.

Column Descriptions:

Name	Type	Description
STOREENT_ID	INTEGER NOT NULL	The StoreEntity this CounterCurrencyPair is part of. The complete list of counter value currencies for a Store includes CounterCurrencyPairs from both the Store and its StoreGroup.
CURRSTR	CHAR (3) NOT NULL	The shopping currency (in which customer intends to pay). This is a currency code as per ISO 4217 standards.
COUNTERVALUECURR	CHAR (3) NOT NULL	A counter value currency (ISO 4217 standards code). When "dual display" is desired, amounts in the shopping currency are converted to all the counter value currencies for that shopping currency and shown for the information of the customer.
DISPLAYSEQ	DOUBLE NOT NULL	Counter value amounts, one for each counter value currency, are displayed in ascending sequence of DISPLAYSEQ.
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>	COUNTERVALUECURR+CURRSTR+STOREENT_ID+DISPLAYSEQ	Primary Key
I0000552	STOREENT_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_287	COUNTERVALUECURR	SETCURR	SETCCURR	Cascade
F_288	CURRSTR	SETCURR	SETCCURR	Cascade
F_289	STOREENT_ID	STOREENT	STOREENT_ID	Cascade

Related reference
Currency data model