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:

NameTypeDescription
STOREENT_IDINTEGER NOT NULLThe 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.
CURRSTRCHAR (3) NOT NULLThe shopping currency (in which customer intends to pay). This is a currency code as per ISO 4217 standards.
COUNTERVALUECURRCHAR (3) NOT NULLA 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.
DISPLAYSEQDOUBLE NOT NULLCounter value amounts, one for each counter value currency, are displayed in ascending sequence of DISPLAYSEQ.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED> COUNTERVALUECURR+CURRSTR+STOREENT_ID+DISPLAYSEQPrimary Key
I0000552STOREENT_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_287COUNTERVALUECURRSETCURRSETCCURRCascade
F_288CURRSTRSETCURRSETCCURRCascade
F_289STOREENT_IDSTOREENTSTOREENT_IDCascade