Treasury FX Forward Rates Import
The Treasury FX Forward Rates loader uses only a single set of header columns.
Overview
The Treasury FX Forward Rates Import process reads files from ./Incoming/FxForwardRates in the SFTP. These files will be moved to the archive folder located at ./Incoming/Archive/FxForwardRates before being processed in alphanumeric order.
| Column Name | Description | Req'd | Unique | Type | Allowable Values |
|---|---|---|---|---|---|
| Rate Date | Date for which the foreign exchange forward rate is valid | TRUE | FALSE | date | |
| Quote currency | Currency (as set up in Coupa Treasury) of the quote | TRUE | FALSE | char - 3 | curreny iso codes |
| Base currency | Currency (as set up in Coupa Treasury) | TRUE | FALSE | char - 3 | curreny iso codes |
| Forward date | Specific date in the future for which the rate shall be used | FALSE | FALSE | date | |
| Days | Tenor of the curve in days | FALSE | FALSE | integer | |
| Swap points | Either swap points or forward rates needs to be provided | FALSE | FALSE | decimal | |
| Forward Rate | Either swap points or forward rates needs to be provided | FALSE | FALSE | decimal |