The following table shows the FXRates table schema:
Table 1. FXRates
table schemaColumn |
Description |
SQL Type |
Size |
Java Type |
FROMCURRENCY (PK) |
Identifies the source currency. |
CHAR |
3 |
String |
TOCURRENCY (PK) |
Identifies the destination currency. |
CHAR |
3 |
String |
FROMMONETARYITEM (PK) |
Identifies how the financial institution receives the
source currency. |
CHAR |
2 |
String |
TOMONETARYITEM (PK) |
Identifies how the financial institution received the
destination currency. |
CHAR |
2 |
String |
BUYRATE |
Contains the rate at which the financial institution
buys the destination currency. Its format is fixed to six significant digits. |
CHAR |
8 |
String |
SELLRATE |
Contains the rate at which the financial institution
sells the destination currency. Its format is fixed to six significant digits. |
CHAR |
8 |
String |
1Note: The table stores the buy and sell rates
based on a single unit of the from currency to x units of
the to currency. For example, a single USD to 173.000 ESP.
The
following is an example of the FXRates table:
Table 2. FROM CURRENCY |
TO CURRENCY |
FROM MONETARY ITEM |
TO MONETARY ITEM |
BUY RATE |
SELL RATE |
USD |
ESP |
CA |
CA |
"173.145" |
"173.155" |
EUR |
DEM |
CA |
CA |
"1.95583" |
"1.95583" |