Reference > Database > WebSphere Commerce database tables > C
WebSphere Commerce database table: 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 Name Column 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 Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030322910 COUNTERVALUECURR+CURRSTR+STOREENT_ID+DISPLAYSEQ Primary Key I0000552 STOREENT_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_287 COUNTERVALUECURR SETCURR SETCCURR Cascade F_288 CURRSTR SETCURR SETCCURR Cascade F_289 STOREENT_ID STOREENT STOREENT_ID Cascade
Related reference
_vcc_freeselect_bottom_