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 |