Importing Exchange Rates
The following tables define field references used in the Exchange Rate Header Information section of the MasterMCRATE.DEF file:
| Table: tblMCExchangeRates | ||||
|---|---|---|---|---|
| Context Section: CONTEXT,MCRATE,HEADER,HEXR | ||||
| Field ID | Req'd | Field Length | Default Value | Notes |
|
EXR_RATE_TYPE |
Y |
3 |
|
DSR (Daily Spot Rate) or MAR (Monthly Average Rate) |
|
EXR_CURRENCY |
Y |
3 |
|
Active or inactive Currency code. |
|
EXR_ACTIVE_DATE |
Y |
Date |
|
Active Date. Can be 6, 8, or 10 digit date. |
|
EXR_EXCHANGE_ |
Y |
8 |
0.0000000 |
Currency Exchange Rate |
|
EXR_EXPIRATION_ |
Y |
Date |
|
Expiration Date. Can be 6, 8, or 10 digit date. |
|
EXR_SOURCE |
N |
35 |
|
Exchange Rate Source |
- You cannot import the functional currency.
- If you attempt to import a date that does not follow the format outlined in the DEF file or the system's date settings, the system defaults to today's date. This could cause exchange date overwrites.
- You should limit the EXR_EXCHANGE_RATE field to six digits before and 7 digits after the decimal.
- There are no fixed width files for exchange rates.