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 |