Treasury Long-term Loan 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 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