Treasury Interest Rate Options Export
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 |
|
|||
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 |