What can we help you find? Products Coupa Product Documentation Integration Technical Documentation Coupa Core Flat Files (CSV) Flat File (CSV) Export Treasury Long-Term Loan Export

Treasury Long-Term Loan Export

The Treasury Long-Term Loan export uses only a single set of header columns.

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

Related Items

Build on the Coupa Platform

Our API-based open integration platform lets technology partners and independent software vendors (ISVs) integrate their products with Coupa

Learn More

The Coupa Core API

Our RESTful API provides robust access to read, edit, or integrate your data with the Coupa platform.

Learn More

Get Started with the API

General information about using the Coupa API and when you should consider using CSV.

Learn More

OAuth 2.0 and OIDC

Coupa is deprecating legacy API Keys and requiring the use of OAuth 2.0 / OIDC. Starting with R34, no new API Keys will be issued, and API Keys will no longer be supported with R35.

Learn More