Treasury Cash Flow File Import
The Treasury Cash Flow file import loader uses only a single set of header columns.
Column Name | Description | Req'd | Unique | Type | Allowable Values |
---|---|---|---|---|---|
AccountID | Account Name, ID for Reporting, Account No. or Account No. GL as set up in Coupa Treasury | 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 | 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 | false | false | (string)50 | any | |
Cash Flow GL number | false | false | (string)50 | any | |
CategoryID | ID planning category as defined in Coupa Treasury | false | false | (string)50 | any |
Cash Flow category | false | false | (string)50 | any | |
Comment | false | false | (string)500 | any |