Treasury FX Options Export
Export of these records is included as a Standard CSV Export.
![](/DITARoot/icons/important.png)
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) |
Abbreviation of the Participant |
string |
|||
CoreID (Entity) |
ID of the legal entity / financial counterparty in Coupa Core |
|
|||
ReportingClassification (Entity) |
ReportingClassification of the Participant (Internal or External) |
|
Internal, External |
||
IntegerID (Counterparty) |
Id |
int |
|||
Abbreviation (Counterparty) |
Abbreviation of the Participant |
string |
|||
CoreID (Counterparty) |
ID of the legal entity / financial counterparty in Coupa Core |
|
|||
ReportingClassification (Counterparty) |
ReportingClassification of the Participant (Internal or External) |
|
Internal, External |
||
Buy/Sell |
Indicates whether the option is bought or sold |
|
Buy, Sell |
||
Type |
Indicates whether the option is a put or a call |
|
Put, Call |
||
UniqueID (Deal Type) |
UniqueID of deal type |
|
|||
Abbreviation (Deal Type) |
Abbreviation of deal type |
|
|||
Execution Date |
Execution Date |
date |
|||
Due Date |
Due Date |
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 |
|||
Strike |
Strike Rate of the deal |
decimal |
|||
Spot Rate |
Spot Rate |
decimal |
|||
Reciprocal |
When true, the amount of currency 2 equals the amount of currency 1 divided by rate. When false, the amount of currency 2 equals the amount of currency 1 multiplied by rate. |
boolean |
|||
Price/Premium |
Indicates whether a premium or price (per 100 ccy1) is quoted |
|
Price, Premium |
||
Price/Premium Amount |
Price/Premium Amount |
decimal |
|||
Currency of Price/Premium |
Currency of price or premium |
string |
|||
Premium Value Date |
Value date of the premium |
date |
|||
Option Status |
Indicates whether the option is open, executed or expired |
|
Open, Executed, Expired |
||
Option Status Date |
The date of the option status |
date |
|||
Comments |
Comments |
string |
|||
Unique Trade Identifier (UTI) |
Unique Trade Identifier |
string |
|||
External Reference |
Identification of the deal in external systems |
string |
|||
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 |
Yes | Yes |
int |
|
Abbreviation (Portfolio) |
Abbreviation of the portfolio |
string |
|||
UniqueID (IFRS Class) |
UniqueID (IFRS Class) |
|
|||
IntegerID (IFRS Class) |
IntegerID (IFRS Class) |
|
|||
Abbreviation (IFRS Class) |
Abbreviation (IFRS Class) |
|
|||
Option Premium |
Manual entry of paid premium |
decimal |
|||
Option Value on Cut-off Date |
Manual entry of value on cut-off date |
decimal |
|||
Execution Type |
Indicates whether the option is an European or American option |
|
European, American |
||
Do Not Use |
Indicates whether the option shall be used or not |
boolean |
|||
Expiry Time |
Time at which the option expires |
hh:mm |
|||
Expiry Comment |
Additional comments to the expiry time (such as timezone) |
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 |