Treasury Security 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.
|
Column Name |
Description |
Req'd |
Unique |
Type |
Allowable Values |
|---|---|---|---|---|---|
|
IntegerID |
integer |
||||
|
UniqueID |
GuIDentifier |
||||
|
Entity |
|
||||
|
Counterparty |
|
||||
|
Deal Type |
|
||||
|
Name |
string |
||||
|
Issuer |
string |
||||
|
Face Amount |
decimal |
||||
|
ISIN |
string |
||||
|
Country/Region |
string |
||||
|
Currency |
string |
||||
|
Comments |
string |
||||
|
Issue Date |
date |
||||
|
First Due Date |
date |
||||
|
Date Rolling (Due Date) |
Enum |
Actual, Following, Modified Following, Preceding |
|||
|
First Calculation Date |
date |
|
|||
|
Date Rolling (Calculation Date) |
Enum |
Actual, Following, Modified Following, Preceding |
|||
|
Final Maturity Date |
date |
|
|||
|
Effective Interest Rate |
decimal |
|
|||
|
Interest Method |
Enum |
actual365, actual360, 30E360ISDA, actualActualISDA, 30360ICMA, actualActualICMA, bus252, 30360US, actual360Exp, 30360ICMAExp, bus252Exp |
|||
|
Payment Period |
Enum |
Monthly, Quarterly, Biannually, Annually, Unique |
|||
|
Payment Method |
Enum |
Monthly, Quarterly, Biannually, Annually, Unique |
|||
|
Base Rate |
string |
||||
|
Margin |
decimal |
||||
|
Compounded Rate |
Method used for compounding |
Enum |
No,Plain, Lockout, LookbackLag, LookbackShift |
||
|
Compounded Rate Rounding |
Rounding convention for the daily interest rates to be applied to the rates before going into the compounding calculation |
Enum |
< none >, Rounding half away from zero, Rounding up, Rounding down |
||
|
Compounded Rate Rounding Decimal Places |
Number of decimal places to which the compounded rate is rounded |
tinyint |
|||
|
Floor at Zero |
Indicates whether daily (negative) interest rates are floored at 0 before the compounding calculation is applied |
boolean |
|||
|
Lag Days |
Number of days shift of the observation period/observation rate depending on the compounding method |
integer |
|||
|
Spread |
Spread to be applied to the daily interest rates before the compounding calculation is applied |
decimal |
|||
|
External Ref. |
string |
||||
|
Classic Credit Line |
|
||||
|
Withholding Tax 1 |
decimal |
||||
|
Withholding Tax 2 |
decimal |
||||
|
Class |
|
Concluded, Projected, Benchmark |
|||
|
Project |
|||||
|
Portfolio |
|||||
|
Financial Status Category |
|||||
|
IFRS Class |
|||||
|
In Funding |
boolean |
|
|||
|
Traded Date |
Date and time the deal was concluded |
||||
|
Traded User |
User who concluded the trade |
||||
|
Entered Date |
Date and time the deal was entered in the system |
||||
|
Entered User |
User who entered the deal in the system |
||||
|
Changed Date |
Date and time the deal was changed the last time |
||||
|
Changed User |
User who changed the deal the last time |
||||
|
Approved |
Indicates whether the deal was approved |
||||
|
Approved Date |
Date and time the deal was approved |
||||
|
Approved User |
User who approved the deal |