Currency Exchange Rate Import Format

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.

Prerequisites

Before using this import, the following must be set up: