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 Description(s):
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. |
Index(es):
Index Name | Indexed Column Names | Index Type |
SQL050212031219880 |
COUNTERVALUECURR+CURRSTR+STOREENT_ID+DISPLAYSEQ |
Primary Key |
I0000552 |
STOREENT_ID |
Non-Unique Index |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_287 |
COUNTERVALUECURR |
SETCURR |
SETCCURR |
Cascade |
F_288 |
CURRSTR |
SETCURR |
SETCCURR |
Cascade |
F_289 |
STOREENT_ID |
STOREENT |
STOREENT_ID |
Cascade |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.