Treasury Cash Flow Import
The Treasury Cash Flow loader uses only a single set of header columns.
Overview
The Treasury Cash Flow File Import process read files from ./Incoming/CashFlows/ in the SFTP. These files will be moved to the archive folder located at ./Incoming/Archive/CashFlows/ before being processed in alphanumeric order.
| 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 | false | false | (string)500 | any |