Treasury FX Options Export

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

string

UniqueID (Portfolio)

GuID given by the system

IntegerID (Portfolio)

Integer ID given by the system

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