Treasury MMF Balances Import
The Treasury MMF Balances Import loader uses only a single set of header columns.
Overview
The Treasury MMF Balances Import process reads files from ./Incoming/MoneyMarketFund/Balance in the SFTP. These files will be moved to the archive folder located at ./Incoming/Archive/MoneyMarketFund/Balance before being processed in alphanumeric order.
| Column Name | Description | Req'd | Unique | Type | Allowable Values |
|---|---|---|---|---|---|
| Balance Amount | Amount | TRUE | FALSE | decimal | cannot be zero |
| Balance Date | Date at which funds, assets, or money's value becomes effective | TRUE | FALSE | date | mdy, dmy, ymd |
| Entity | Entity as set up in Coupa Treasury | TRUE | FALSE | string | any |
| ISIN | ISIN as set up in Coupa Treasury | TRUE | string | any | |
| Name | Name of the money market fund as set up in Coupa Treasury | TRUE | string | any | |
| Volume | Number of shares | FALSE | FALSE | decimal | zero or positive numbers |