| Highwire Fields | Mandatory/Optional | Notes |
|---|---|---|
| Portfolio code | M | Portfolio code (as per the Portfolio Master multi short name) |
| Currency | M | The local currency of the cashflow (in 3-digit ISO fomat) |
| Cashflow transaction ID* | M | A unique id for the cashflow |
| Cashflow trade date | O | The transaction date for the cashflow, if left blank then date is taken from file name. Rules run based on trade date. |
| Cashflow settlement date** | M | The settlement / payment date of the cashflow |
| Cashflow type | M | Cashflow Type (which gets recorded in the Cash Flow Groups) |
| Cashflow Transaction description 1 | O | Description |
| Cashflow Transaction description 2 | O | Product Type, Account Type etc |
| Cashflow Transaction description 3*** | O | A concatenation of Currency, Trade ID, ISIN |
| Bank | M | This is the Prime broker or Bank that the cashflow files ae coming from. If this is not in the file, it can be added to the file by the automations team or brought in though a default column. It needs to be entity in company master, see next slide. |
| Counterparty Code | M | This is the counterparty / payee to the cashflow – e.g. who the payment is being made to, if identified in the file. This needs to be an entity in the Company master. |
| Cashflow amount | M* | This is the local amount of the cash flow. Typically we will use gross / principal amounts before commission, rather than net amounts |
| Cashflow amount base currency | M* | This is the amount of the cash flow converted to the base currency of the fund. Typically we will use gross / principal amounts before commission, rather than net amounts |
| Cashflow FX Rate (if required) | O | This is the conversion rate to convert local currency to base currency |
