EN globe icon
user icon
On This Page
What can we help you find? Products Coupa Product Documentation Integration Technical Documentation Coupa Core Flat Files (CSV) Flat File (CSV) Export Treasury Money Market Export

Treasury Money Market Export

The Treasury Money Market 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
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 Amount Initial amount of the deal FALSE FALSE decimal n/a
Interest Rate (%) Interest Rate (in %) of the deal FALSE FALSE decimal (%) n/a
Start date Day of the initial payment FALSE FALSE date n/a
End Date Maturity date of the deal FALSE FALSE date n/a
Interest Method Day count convention for calculating interest FALSE FALSE Enum actual365, actual360, 30E360ISDA, actualActualISDA, 30360ICMA, actualActualICMA, bus252, 30360US, actual360Exp, 30360ICMAExp, bus252Exp
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
Comments Comments FALSE FALSE 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
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
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
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
Effective Interest Rate (%) Effective interest rate (in %) FALSE FALSE decimal (%) n/a
Payment Period Payment period FALSE FALSE Enum Monthly, Quarterly, Biannually, Annually, Unique
Date Rolling Indicates how a date is adjusted if it falls on a weekend or bank holiday FALSE FALSE Enum Actual, Following, Modified Following, Preceding
External Reference Identification of the deal in external systems FALSE FALSE n/a
Interest Rate Fixing Indicates whether the interest is fixed: Automatic, variable, fixed FALSE FALSE Enum Automatic, Variable, Fixed
IntegerID (Previous Deal) Integer ID given by the system FALSE FALSE integer n/a
UniqueID (Previous Deal) GuID given by the system FALSE FALSE GuIDentifier n/a
IntegerID (FX Reference) Integer ID given by the system FALSE FALSE n/a
UniqueID (FX Reference) GuID given by the system 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 n/a
VAT (%) Value added tax applied to the interest FALSE FALSE 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 int 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 int 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 FALSE n/a
IntegerID (IFRS Class) IntegerID (IFRS Class) FALSE FALSE n/a
Abbreviation (IFRS Class) Abbreviation (IFRS Class) FALSE FALSE n/a
Initial Exchange Rate Initial Exchange Rate FALSE FALSE n/a
Exchange Rate at Principal Maturity Exchange Rate at Principal Maturity FALSE FALSE n/a
Exchange Rate at Interest Maturity Exchange Rate at Interest Maturity FALSE FALSE n/a
Valuation Exchange Rate Valuation Exchange Rate FALSE FALSE n/a
Market Interest Rate Market Interest Rate FALSE FALSE n/a
In Funding Indicates whether the deal is included in funding reports 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
Confirmation Sent Indicates whether a confirmation was sent for this deal FALSE FALSE n/a
Confirmation Sent Date Date and time the confirmation was sent FALSE FALSE n/a
Classic User IntegerID (Confirmation Sent User) Classic User IntegerID (Confirmation Sent User) FALSE FALSE integer n/a
Core User IntegerID (Confirmation Sent User) Core User IntegerID (Confirmation Sent User) FALSE FALSE integer n/a
Confirmation Received Indicates whether a confirmation was received for this deal FALSE FALSE n/a
Confirmation Received Date Date and time the confirmation was received FALSE FALSE n/a
Classic User IntegerID (Confirmation Received User) Classic User IntegerID (Confirmation Received User) FALSE FALSE integer n/a
Core User IntegerID (Confirmation Received User) Core User IntegerID (Confirmation Received User) FALSE FALSE integer n/a
Fusion CMS Match Indicates whether the deal was matched via Fusion CMS FALSE FALSE n/a
Fusion CMS Match Date Date and time the deal was matched via Fusion CMS FALSE FALSE n/a
Classic User IntegerID (Fusion CMS Match User) Classic User IntegerID (Fusion CMS Match User) FALSE FALSE integer n/a
Core User IntegerID (Fusion CMS Match User) 0 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