Treasury Foreign Exchange Export
Export of these records is included as a Standard CSV Export.
Note:
Because Integration Transaction Formats are not available for Treasury objects, you cannot configure the columns for this export.
|
Column Name |
Description |
Req'd |
Unique |
Type |
Allowable Values |
|---|---|---|---|---|---|
|
IntegerID |
Integer ID given by the system |
||||
|
UniqueID |
GuID given by the system |
||||
|
IntegerID (Entity) |
Id |
int |
|||
|
Abbreviation (Entity) |
Title |
string |
|||
|
IntegerID (Counterparty) |
Id |
int |
|||
|
Abbreviation (Counterparty) |
Title |
string |
|||
|
Direction |
Indicates whether currency 1 is bought |
Buy, Sell |
|||
|
UniqueID (Deal Type) |
UniqueID of deal type |
||||
|
Abbreviation (Deal Type) |
Abbreviation of deal type |
||||
|
Swap IntegerID |
IntegerID of the other swap leg; 0 in case the deal is not a swap |
int |
|||
|
Value Date |
Value date of the currency exchange |
date |
|||
|
Amount |
Amount of Currency 1 |
decimal |
|||
|
Currency 1 |
Currency of which the amount is bought/sold (depending on direction) |
string |
|||
|
Currency 2 |
Currency that is sold/bought in exchange of currency 1 |
string |
|||
|
IntegerID (Hedge Name (Currency 1)) |
Id |
int |
|||
|
Underlying (Hedge Name (Currency 1)) |
Name |
string |
|||
|
Currency (Hedge Name (Currency 1)) |
CurrencyIsoCode |
string |
|||
|
IntegerID (Hedge Name (Currency 2)) |
Id |
int |
|||
|
Underlying (Hedge Name (Currency 2)) |
Name |
string |
|||
|
Currency (Hedge Name (Currency 2)) |
CurrencyIsoCode |
string |
|||
|
Rate |
Agreed Exchange Rate of the deal |
decimal |
|||
|
Spot Rate |
Spot Rate |
decimal |
|||
|
Reciprocal |
Reciprocal = TRUE means amount of currency 2 = amount of currency 1 / rate; FALSE means amount of currency 2 = amount of currency 1 * rate |
boolean |
|||
|
Settlement Rate |
Settlement Rate of the NDF |
decimal |
|||
|
Fixing |
Fixing Date of the settlement Rate |
date |
|||
|
Settlement Rate Source |
Indicates the source of the settlement rate (relevant for matching) |
string |
|||
|
Comments |
Comments |
string |
|||
|
Unique Trade Identifier (UTI) |
Unique Trade Identifier |
string |
|||
|
External Reference |
Identification of the deal in external systems |
string |
|||
|
IntegerID (Previous Deal) |
Integer ID given by the system |
||||
|
UniqueID (Previous Deal) |
GuID given by the system |
||||
|
IntegerID (MM Reference) |
Integer ID given by the system |
int |
|||
|
UniqueID (MM Reference) |
GuID given by the system |
GuIDentifier |
|||
|
IntegerID (External Deal Request) |
IntegerID of the external deal request |
int |
|||
|
IntegerID (Classic Credit Line) |
Integer ID given by the system |
||||
|
UniqueID (Classic Credit Line) |
GuID given by the system |
||||
|
UniqueID (Classic Credit Line) |
GuID given by the system |
||||
|
IntegerID (Classic Credit Line) |
Integer ID given by the system |
int |
|||
|
Class |
Indicates whether the deal is concluded, projected or used for benchmarking |
Concluded, Projected, Benchmark |
|||
|
UniqueID (Project) |
GuID given by the system |
||||
|
IntegerID (Project) |
Integer ID given by the system |
int |
|||
|
Abbreviation (Project) |
Abbreviation of the project |
Yes |
|
string |
|
|
UniqueID (Portfolio) |
GuID given by the system |
||||
|
IntegerID (Portfolio) |
Integer ID given by the system |
int |
|||
|
Abbreviation (Portfolio) |
Abbreviation of the portfolio |
Yes |
Yes |
string |
|
|
UniqueID (IFRS Class) |
UniqueID (IFRS Class) |
||||
|
IntegerID (IFRS Class) |
IntegerID (IFRS Class) |
||||
|
Abbreviation (IFRS Class) |
Abbreviation (IFRS Class) |
||||
|
Funding |
Indicates whether the deal is included in funding reports |
boolean |
|||
|
Realized |
Realized |
boolean |
|||
|
Customer Order |
Customer Order |
string |
|||
|
IFRS Comments |
IFRS Comments |
string |
|||
|
Traded Date |
Date and time the deal was concluded |
||||
|
Classic User IntegerID (Traded User) |
Classic User IntegerID (Traded User) |
integer |
|||
|
Core User IntegerID (Traded User) |
Core User IntegerID (Traded User) |
integer |
|||
|
Entered Date |
Date and time the deal was entered in the system |
||||
|
Classic User IntegerID (Entered User) |
Classic User IntegerID (Entered User) |
integer |
|||
|
Core User IntegerID (Entered User) |
Core User IntegerID (Entered User) |
integer |
|||
|
Changed Date |
Date and time the deal was changed the last time |
||||
|
Classic User IntegerID (Changed User) |
Classic User IntegerID (Changed User) |
integer |
|||
|
Core User IntegerID (Changed User) |
Core User IntegerID (Changed User) |
integer |
|||
|
Approved |
Indicates whether the deal was approved |
||||
|
Approved Date |
Date and time the deal was approved |
||||
|
Classic User IntegerID (Approved User) |
Classic User IntegerID (Approved User) |
integer |
|||
|
Core User IntegerID (Approved User) |
Core User IntegerID (Approved User) |
integer |
|||
|
Confirmation Sent |
Indicates whether a confirmation was sent for this deal |
||||
|
Confirmation Sent Date |
Date and time the confirmation was sent |
||||
|
Classic User IntegerID (Confirmation Sent User) |
Classic User IntegerID (Confirmation Sent User) |
integer |
|||
|
Core User IntegerID (Confirmation Sent User) |
Core User IntegerID (Confirmation Sent User) |
integer |
|||
|
Confirmation Received |
Indicates whether a confirmation was received for this deal |
||||
|
Confirmation Received Date |
Date and time the confirmation was received |
||||
|
Classic User IntegerID (Confirmation Received User) |
Classic User IntegerID (Confirmation Received User) |
integer |
|||
|
Core User IntegerID (Confirmation Received User) |
Core User IntegerID (Confirmation Received User) |
integer |
|||
|
Fusion CMS Match |
Indicates whether the deal was matched via Fusion CMS |
||||
|
Fusion CMS Match Date |
Date and time the deal was matched via Fusion CMS |
||||
|
Classic User IntegerID (Fusion CMS Match User) |
Classic User IntegerID (Fusion CMS Match User) |
integer |
|||
|
Core User IntegerID (Fusion CMS Match User) |
Core User IntegerID (Fusion CMS Match User) |
integer |