What can we help you find? Products Coupa Product Documentation Integration Technical Documentation Coupa Core Flat Files (CSV) Flat File (CSV) Import Exchange Rate Import

Exchange Rate Import

The exchange rates integration loader uses only a single set of header columns.

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.

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 Note Although the allowable values are `YYYY-MM-DDTHH` `:MM:SS+HH:MM` , the Rate Date column floors the date and time to the beginning of the day (that is, `00:00` ).	TRUE	TRUE	datetime	YYYY-MM-DDTHH:MM:SS+HH:MM