Exchange Rate 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.
Note: 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.
Note: Although the allowable values for the
Rate Date
column are in the YYYY-MM-DDTHH :MM:SS+HH:MM format, the column floors
the date and time to the beginning of the day (00:00).Exchange Rate
| Field Name | Required Field | Unique? | Field Type | Field Description | Possible Values |
| From Currency | Yes | No | Base Currency Code | ||
| To Currency | Yes | No | Target Currency Code | ||
| Rate | Yes | No | decimal(30,9) | Exchange Rate | |
| Rate Date | Yes | Yes | datetime | Exchange Rate Effective Start Date |