Exchange Rate CSV Format

Each Exchange Rates CSV file contains rates associated with a single exchange rate source.

For information about using CSV format files, see Best Practices for Importing Data with CSV Files.

Exchange Rate File Format

SDITYPE=ExchangeRate
Column Name	Format	Req?	Description
FromCurrencyCode	number	Y	The "from" currency for this conversion rate.
ToCurrencyCode	number	Y	The "to" currency for this conversion rate.
StartDate	mm/dd/yyyy	Y	The start date for the conversion rate.
EndDate	mm/dd/yyyy	Y	The end date for the conversion rate.
Rate	number	Y	The rate of conversion from the "from" currency to the "to" currency.

Exchange Rate File Example

This file includes two exchange rates.

1. sdiType=ExchangeRate

2. FromCurrencyCode,ToCurrencyCode,StartDate,EndDate,Rate

3. USD,CAD,10/04/2006,11/04/2006,1.1263

4. CAD,USD,10/04/2006,11/04/2006,0.8879
   

For more information about formatting a CSV file, see Creating CSV Import Files.

Updating an Existing Exchange Rate

You can update an existing exchange rate by including matching data in all columns except Rate, then entering a new rate in that column.

Exchange Rates File Import Prerequisites

You must create the desired company into which you want to import exchange rates, as well as the associated exchange rate source, before running the Import/Export Wizard.

Exchange Rates File Import Options