Treasury Long-term Loan 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 |
integer |
|||
UniqueID |
GuID given by the system |
GuIDentifier |
|||
IntegerID (Entity) |
Id |
integer |
|||
Abbreviation (Entity) |
Title |
string |
|||
IntegerID (Counterparty) |
Id |
integer |
|||
Abbreviation (Counterparty) |
Title |
string |
|||
Direction |
Indicating whether it is an investment or a loan |
enum |
Investment, Loan |
||
UniqueID (Deal Type) |
UniqueID of deal type |
||||
Abbreviation (Deal Type) |
Abbreviation of deal type |
||||
Currency |
Currency of the deal |
||||
Initial Payment Date |
Date of the initial payment of the loan |
date |
|||
Loan Amount |
Total amount of the loan |
decimal |
|||
Initial Payment |
Amount of the initial payment of the loan |
decimal |
|||
IntegerID (Hedge Name) |
Id |
integer |
|||
Underlying (Hedge Name) |
Name |
string |
|||
Currency (Hedge Name) |
CurrencyIsoCode |
string |
|||
Interest Rate |
Interest Rate (in %) of the deal |
decimal (%) |
|||
Margin |
Margin (in %) on top of the interest reference rate (is included in interest rate) |
||||
InterestRateFixing |
Indicates whether interest is fix or variable |
Automatic, Variable, Fixed |
|||
Base Rate |
Indicates the name of the base rate |
|
|||
Interest Method |
Day count convention for calculating interest |
enum |
actual365, actual360, 30E360ISDA, actualActualISDA, 30360ICMA, actualActualICMA, bus252, 30360US, actual360Exp, 30360ICMAExp, bus252Exp |
||
Interest Maturity |
Interest Maturity taken into account for interest fixing proposals. |
||||
Effective Interest Rate |
Effective interest rate (in %) |
decimal (%) |
|||
Fixed Until |
In case of fixed interest, date until the rate is fixed |
date |
|||
Payment Period (Interest) |
Payment period (Interest) |
enum |
Monthly, Quarterly, Biannually, Annually, Unique |
||
First Due Date |
First due date of interest payment |
date |
|||
Last Day of the Month (Due Date) |
Indicates whether the due date is always the last day of a month |
boolean |
|||
Date Rolling (Due Date) |
Indicates how a date is adjusted if it falls on a weekend or bank holiday |
enum |
Actual, Following, Modified Following, Preceding |
||
First Calculation Date |
First calculation date |
date |
|||
Last Day of the Month (Calculation Date) |
Indicates whether the calculation date is always the last day of a month |
boolean |
|||
Date Rolling (Calculation Date) |
Indicates how a date is adjusted if it falls on a weekend or bank holiday |
enum |
Actual, Following, Modified Following, Preceding |
||
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 |
|||
Annuity / Savings Amount |
Annuity / Savings Amount |
decimal |
|||
Annuity Percentage |
Annuity Percentage (Annuity Loans only) |
decimal |
|||
Payment Period (Amortization) |
Payment Period (Amortization) |
enum |
Monthly, Quarterly, Biannually, Annually, Unique |
||
First Due Date (Amortization) |
First due date of the amortization payment |
|
|||
Last Day of the Month (Due Date Amortization) |
Indicates whether the due date of amortizations is always the last day of a month |
||||
Date rolling (Crediting) |
Date rolling for amortization in case of a positive flow |
Actual, Following, Modified Following, Preceding |
|||
Date rolling (Payment) |
Date rolling for amortization in case of a negative flow |
Actual, Following, Modified Following, Preceding |
|||
Final Maturity Date (Entered) |
Final maturity date of the loan as entered |
||||
Final Maturity Date (Calculated) |
Final maturity date of the loan as calculated per payment plan |
date |
|||
Repayable before maturity |
Indicates whether the loan may be repaid before final maturity |
||||
External Reference |
Identification of the deal in external systems |
||||
File Number |
File number of the loan |
||||
Receiver No. |
Receiver number of the loan |
||||
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 |
integer |
|||
Ultimate Debtor (Credit Line) |
Ultimate Debtor (Credit Line) |
||||
Payment Reference 1 |
Oliver Knapp what are these fields doing? |
||||
Payment Reference 2 |
Oliver Knapp what are these fields doing? |
||||
Fee |
Fee for the loan |
decimal |
|||
Disagio |
Disagio (in %) |
decimal (%) |
|||
Withholding Tax 1 |
Value added tax rate 1 (in %) on the Interest |
decimal (%) |
|||
Withholding Tax 2 |
Value added tax rate 2 (in %) on the Interest |
||||
VAT |
Value added tax applied to the interest |
||||
Initial Exchange Rate |
Initial exchange rate for the loan |
decimal |
|||
Initial Exchange Rate Reciprocal |
Indicates whether the initial exchange rate is reciprocal |
boolean |
|||
Date Signed |
Date the contract was signed |
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 |
integer |
|||
Abbreviation (Project) |
Abbreviation of the project |
Yes |
string |
||
UniqueID (Portfolio) |
GuID given by the system |
||||
IntegerID (Portfolio) |
Integer ID given by the system |
integer |
|||
Abbreviation (Portfolio) |
Abbreviation of the portfolio |
Yes |
Yes |
string |
|
IntegerID (Financial Status Main Category) |
IntegerID of the Financial Status Main Category |
||||
Name (Financial Status Main Category) |
Name (language dependent) of the Financial Status Main Category |
||||
IntegerID (Financial Status Category) |
IntegerID of the Financial Status Category |
||||
Name (Financial Status Category) |
Name (language dependent) of the Financial Status Category |
||||
UniqueID (IFRS Class) |
UniqueID (IFRS Class) |
||||
IntegerID (IFRS Class) |
IntegerID (IFRS Class) |
||||
Abbreviation (IFRS Class) |
Abbreviation (IFRS Class) |
||||
In Funding |
Indicates whether the deal is included in funding reports |
||||
Recalculation Allowed |
Oliver Knapp what is this field doing? |
||||
Comments |
Comments for the loan |
||||
IFRS Comments |
IFRS comments for the loan |
||||
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 |