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