Treasury Cash Flow Export
Export of these records is included as a Standard CSV Export.

Because Integration Transaction Formats are not available for Treasury objects, you cannot configure the columns for this export.
Cash Flow Export
Exports all cash flows created since prior day (yesterday).
Column Name |
Description |
Req'd |
Unique |
Type |
Allowable Values |
---|---|---|---|---|---|
Account |
Account Name |
Yes |
(string)50 |
any |
|
Amount |
Yes |
decimal |
cannot be zero |
||
Value Date |
Yes |
date |
mdy, dmy, ymd |
||
Booking Date |
date |
mdy, dmy, ymd |
|||
Payment Reference |
Free text containing additional information about the transaction |
(string)400 |
any |
||
Project |
Internal reference as defined in Coupa Treasury |
(string)50 |
any |
||
Portfolio |
Internal reference as defined in Coupa Treasury |
(string)50 |
any |
||
Counterparty |
Internal reference as defined in Coupa Treasury |
(string)50 |
any |
||
Cash Flow GL number |
String of numbers or letters referencing the general ledger |
(string)50 |
any |
||
CategoryID |
ID planning category as defined in Coupa Treasury |
(string)50 |
any |
||
Cash Flow category |
ID cash flow category as defined in Coupa Treasury |
(string)50 |
any |
||
Comment |
Comment |
(string)500 |
any |
||
0 Day Float |
0 Day Float |
||||
1 Day Float |
1 Day Float |
||||
2+ Day Float |
2+ Day Float |
||||
Account Category |
Category of the account as set up in Coupa Treasury |
||||
Account GL Number |
String of numbers or letters referencing the general ledger |
||||
Account Payer/Payee |
Account Payer/Payee |
||||
Additional Entry Information |
Additional Entry Information |
||||
Additional Transaction Information |
Information from the Account Statement |
||||
Balance Relevant |
Flag: whether a cash flow is used for balance calculation or not |
||||
Bank |
Bank as set up in Coupa Treasury |
||||
Bank Code Payer/Payee |
Bank Code Payer/Payee |
||||
Bank Reference |
Bank Reference |
||||
Bank Transaction ID |
Bank Transaction ID |
||||
Booking Instruction |
Booking Instruction |
||||
Booking Key |
Booking Key |
||||
Cash Flow Rule |
Cash flow rule used on the cash flow |
||||
Cash Pool |
Cash Pool |
||||
Changed by |
User name as set up in Coupa Treasury |
||||
Changed Date |
Date when the entry has been changed |
||||
Creditor ID |
|||||
Currency |
Currency of the amount (given by the account) as set up in Coupa Treasury |
||||
Customer Reference |
|||||
Debit/Credit |
Categorizes the amount by sign (- debit, + credit) |
||||
Distributed Availability |
Distributed Availability |
||||
Domain Code |
Domain Code |
||||
End-to-end Reference |
End-to-end Reference |
||||
Entered By |
User name as set up in Coupa Treasury |
||||
Entered Date |
Date when the entry has been entered |
||||
Entity |
Entity of the account as set up in Coupa Treasury |
||||
Exported |
Flag: whether a cash flow has been exported as an IC Account Statement or not |
||||
Exported by |
User name as set up in Coupa Treasury |
||||
Exported Date |
Date when the entry has been exported as an IC Account Statement |
||||
Family Code |
Family Code |
||||
Instruction ID |
Instruction ID |
||||
Mandate Reference |
Mandate Reference |
||||
Mirror Cash Flow |
Mirror Cash Flow |
||||
Mirrored Rebooking Account |
Mirrored Rebooking Account |
||||
Name Payer/Payee |
Name Payer/Payee |
||||
Payment Source (Classic) |
Source of cash flow |
||||
Prima Nota |
Prima Nota |
||||
Proprietary Bank Transaction Code |
Proprietary Bank Transaction Code |
||||
Proprietary Bank Transaction References |
Proprietary Bank Transaction References |
||||
Rebooked |
Flag: whether a cash flow has been rebooked or not |
||||
Rebooked by Cash Pool |
Names the cash pool as set up in Coupa Treasury that triggered the rebooking |
||||
Rebooking Account |
Names the account as set up in Coupa Treasury to which the cash flow has been rebooked |
||||
Reconciled |
Flag: whether a cash flow has been reconciled or not |
||||
Recurr. Cash Flow ID |
ID of batch of recurring cash flows |
||||
Sender Identification Code |
Sender Identification Code |
||||
Source |
Source of cash flow as set up in Coupa Treasury |
||||
Sub Family Code |
Sub Family Code |
||||
Transaction Code |
Transaction Code |
||||
Transaction Code Supplement |
Transaction Code Supplement |
||||
Transfer Target |
Names the target liquidity plan as set up in Coupa Treasury |
||||
Transferred By |
User name as set up in Coupa Treasury |
||||
Transferred Date |
Date when the entry has been transferred to Liquidity Planning |
||||
Transferred to Liquidity Planning |
Flag: whether a cash flow has been transferred to Liquidity Planning or not |
||||
Type |
Type of cash flow |
||||
Type Code |
Type Code |
||||
Ultimate Creditor |
Ultimate Creditor |
||||
Ultimate Debtor |
Ultimate Debtor |