Treasury Cash Flow Import
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 |
Yes |
(string)50 |
any |
|
|
Amount |
Amount |
Yes |
decimal |
cannot be zero |
|
|
Value Date |
Value Date |
Yes |
date |
mdy, dmy, ymd |
|
|
Booking Date |
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 |