Treasury Cash Flow 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 |
|---|---|---|---|---|---|
|
AccountID |
Account ID as given in the Accounts reference Data |
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 |