Skip to main content

 

 

Coupa Success Portal

System - FX and Interest Rate Scenarios Import

Format Descriptions

PDF Version

FX Rate Scenarios

FX Rate Not Per Period

# Name Type Mandatory Comment
1 Currency char - 3 Yes Currency ISO code.
2 Rate decimal Yes  

FX Rate Per Period

# Name Type Mandatory Comment
1 Date (from) date Yes Date as of which the rate is valid.
2 Currency char - 3 Yes Currency ISO code.
3 Rate decimal Yes  

Interest Rate

Interest Rate Not Per Period

# Name Type Mandatory Comment
1 Currency char - 3 Yes Currency ISO code.
2 Days integer * Number of days in the time range.
3 Time Range char - 4 *  
4 Interest Rate decimal Yes  

* - Only one field is mandatory, depending on the scenario type (time range or not).

Interest Rate Per Period, No Multicurve

# Name Type Mandatory Comment
1 From date Yes Date as of which the rate is valid.
2 Currency char - 3 Yes Currency ISO code.
3 Days integer * Number of days in the time range.
4 Time Range char - 4 *  
5 Interest Rate decimal Yes  

* - Only one field is mandatory, depending on the scenario type (time range or not).

Interest Rate Per Period, No Multicurve

# Name Type Mandatory Comment
1 From date Yes Date as of which the rate is valid.
2 Currency char - 3 Yes Currency ISO code.
3 Days integer No Number of days in the time range.
4 Time Range char - 4 Yes  
5 Interest Rate decimal Yes  
6 Interest type integer Yes 0 = Discount 1 = Tenor
7 Tenor  char - 4 *  

* - If Interest type = 1 (Tenor), this field is mandatory. If Interest rate = 0 (Discount), this field must be empty.

Import Function

The import function is available on Commodity Scenarios, Interest Rate Change Scenarios, Interest Scenarios, Rate Change Scenarios, and Rate Scenarios.

For any configured scenario, click the Details button to open the details pop-up window. Under Import From File, use the Choose File button to select a file for import.

The import function processes files in standard text formats:

  • ASCII
  • Unicode

One file contains data about one specific scenario. That scenario must be set up in Coupa Treasury prior to the file import.

Each imported data set overwrites any existing data sets.

Format Rules

The file cannot contain any headers or format descriptions. Do not enclose text in quotation marks.

One file may contain multiple data sets. Each row contains exactly one data set.

  • ASCII Code 13: carriage return shows the end of a data set.
  • ASCII Code 10: new line shows the end of a data set.
  • The last data set concludes by an end of file (EOF).

In the table above, the value for “char” shows how many characters is the maximum length for that field in the imported file.

For decimals, negative numbers are marked with a leading minus sign. There may be a space between the minus sign and the number. For values without decimal places, the decimal separator is optional:

  • Example: 12345.99, -12345.00, 12345

Days and months are always 2-digit values, whereas years are 4 digits.

Date separator, date sequence, and file format must match your user settings. 

  • Field Separator – semicolon (;)
  • Decimal Separator – period (.), comma (,), no thousands separators
  • Decimal: Negative amounts must be marked with a minus sign (-); blanks between the minus sign and the amount are allowed.
  • Integer – No thousands or decimal separators
  • Date Separator – slash (/), period (.), comma (,)
  • Date Sequence – mdy, dmy, ymd

Example Data Sets

FX Rate Not Per Period

EUR;1 
USO;1,20156 
CHF;1,5751 

FX Rate Per Period 

11.10.2019;USD;1,2362
11.10.2019;JPY;135,19
11.10.2019;GBP;0,6887

Interest Rate Not Per Period 

EUR;1;1D;2,156
EUR;7;1W;2,218 
EUR;14;2W;2,496 

Interest Rate Per Period, No Multi-Curve 

11.10.2019;EUR;1;1D;2,156
11.10.2019;EUR;7;1W;2,218
11.10.2019;EUR;14;2W;2,496

Interest Rate Per Period, With Multi-Curve 

11.10.2019;EUR;1;1D;2,156;0
11.10.2019;EUR;7;1W;2,218;0
11.10.2019;EUR;14;2W;2,496;0
11.10.2019;EUR;1;1D;2,056;1;3M
11.10.2019;EUR;7;1W;2,118;1;3M
11.10.2019;EUR;14;2W;2,396;1;3M

 

  • Was this article helpful?