Treasury Interest Rate Options 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.
Interest Rate Options Export
Exports all outstanding deals.
|
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 |
|||
|
UniqueID (Deal Type) |
UniqueID of deal type |
|
|||
|
Abbreviation (Deal Type) |
Abbreviation of deal type |
|
|||
|
Buy/Sell |
Indicates whether the option is bought or sold |
|
Buy, Sell |
||
|
Currency |
Currency of the Interest Rate Option |
string |
|||
|
Reference Amount |
Reference amount of the Interest Rate Option |
decimal |
|||
|
Cap Rate |
Cap Rate of the Interest Rate Option |
decimal |
|||
|
Floor Rate |
Floor Rate of the Interest Rate Option |
decimal |
|||
|
Base Rate |
Indicates the name of the base rate |
decimal |
|||
|
Start |
First day of the Interest Rate Option |
date |
|||
|
End |
Last day of the Interet Rate Option |
date |
|||
|
Payment Period |
Payment Period |
Enum |
Monthly, Quarterly, Biannually, Annually, Unique |
||
|
Interest Method |
Day count convention for calculating interest |
Enum |
actual365, actual360, 30E360ISDA, actualActualISDA, 30360ICMA, actualActualICMA, bus252, 30360US, actual360Exp, 30360ICMAExp, bus252Exp |
||
|
Date Rolling |
Indicates how a date is adjusted if it falls on a weekend or bank holiday |
Enum |
Actual, Following, Modified Following, Preceding |
||
|
Premium |
Premium for the Interest Rate Option |
decimal |
|||
|
Premium Currency |
Currency of the premium |
string |
|||
|
Premium Value Date |
Value date of the premium |
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 |
|||
|
Market Value |
Market value (manual entry) |
decimal |
|||
|
Market Value Date |
Value date of the market value entry |
date |
|||
|
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) |
|
|||
|
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 |