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 |