NOTE For general information on using imports, see Imports FAQ.
The following table lists the format for importing a record in Currency Exchange Rate Import.
Column |
Position |
Field |
Maximum Length |
Format |
Required |
Description |
A |
1 |
From Currency Code |
8 |
Character |
Yes |
Enter a valid currency code to be exchanged to the currency code entered for the To Currency Code field. For information on creating currencies, see Currency Maintenance. |
B |
2 |
To Currency Code |
8 |
Character |
Yes |
Enter a valid currency code to be exchanged to the currency code entered for the From Currency Code field. For information on creating currencies, see Currency Maintenance. |
C |
3 |
Effective Date |
10 |
99/99/9999 |
Yes |
Enter the date at which the exchange rate takes effect. |
D |
4 |
|
|
|
|
This field is not currently used. Leave this field blank. |
E |
5 |
Exchange Rate |
14 |
99999.99999999 |
Yes |
Enter the rate of exchange between the two currency codes entered in the From Currency Code and the To Currency Code fields. |
F |
6 |
|
|
|
|
This field is not currently used. Leave this field blank. |
Before using this import, the following must be set up:
currencies