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 |