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.
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 | 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 |