Treasury FX Forward Rates Import

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

Yes

date

Quote currency

Currency (as set up in Coupa Treasury) of the quote

Yes

char - 3

curreny iso codes

Base currency

Currency (as set up in Coupa Treasury)

Yes

char - 3

curreny iso codes

Forward date

Specific date in the future for which the rate shall be used

date

Days

Tenor of the curve in days

integer

Swap points

Either swap points or forward rates needs to be provided

decimal

Forward Rate

Either swap points or forward rates needs to be provided

decimal