IBM WebSphere Multichannel Bank Transformation Toolkit, Version 7.1

Foreign Exchange Database structure

The following table shows the FXRates table schema:
Table 1. FXRates table schema
Column 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
1
Note: 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"
1 PK = primary key


Feedback