Treasury Cash Flow Export
The Treasury Cash Flow 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 |
|---|---|---|---|---|---|
| AccountID | Account ID as given in the Accounts reference Data | true | false | (string)50 | any |
| Amount | true | false | decimal | cannot be zero | |
| Value Date | true | false | date | mdy, dmy, ymd | |
| Booking Date | false | false | date | mdy, dmy, ymd | |
| Payment Reference | Free text containing additional information about the transaction | false | false | (string)400 | any |
| Project | Internal reference as defined in Coupa Treasury | false | false | (string)50 | any |
| Portfolio | Internal reference as defined in Coupa Treasury | false | false | (string)50 | any |
| Counterparty | Internal reference as defined in Coupa Treasury | false | false | (string)50 | any |
| Cash Flow GL number | String of numbers or letters referencing the general ledger | false | false | (string)50 | any |
| CategoryID | ID planning category as defined in Coupa Treasury | false | false | (string)50 | any |
| Cash Flow category | ID cash flow category as defined in Coupa Treasury | false | false | (string)50 | any |
| Comment | Comment | false | false | (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 |