Exchange Rates Import
Overview
The Exchange Rate Import process read files from ./Incoming/ExchangeRates/ in the SFTP. These files will be moved to the archive folder located at ./Incoming/Archive/ExchangeRates/ before being processed in alphanumeric order.
Coupa does not support modifying existing exchange rates, only creating new rates.
The Exchange Rates loader only supports the creation of one-way exchange rates. For example, if you include for EUR > USD in the loader, you'll have that rate populated in your Coupa instance, but the reverse rate (USD > EUR) won't be created. You need to explicitly include USD > EUR for it to be included.
Exchange Rate Columns
| Column Name | Description | Req'd | Unique | Type | Allowable Values |
|---|---|---|---|---|---|
| From Currency* | The source (base) currency code. | TRUE | FALSE | string(6) | Currency code must exist in Coupa |
| To Currency* | The target currency code. | TRUE | FALSE | string(6) | Currency code must exist in Coupa |
| Rate* | Exchange Rate | TRUE | FALSE | decimal(30,9) | any |
| Rate Date* | Exchange Rate Effective Start Date | TRUE | TRUE | datetime | YYYY-MM-DDTHH:MM:SS+HH:MM |