Query Warehouse Cash Activity Panel Options
The following table describes the key options on the Warehouse Cash panel.
| Option | Description |
|---|---|
| Query Date Type | Specifies the type of date range to filter cash activity query results. Options include:
|
| Start Date | .Specifies the low date to include in cash activity query results. |
| End Date | Specifies the high date to include in cash activity query results. |
| Entity Name | Specifies the entity name to filter query results. |
| Entity ID | Specifies the entity ID to filter query results. |
| Query Based On | Specifies the security qualification to use to filter query results. Options include:
|
| Primary Asset ID | Specifies the asset identifier to filter query results. Available when Query Based On is set to Primary Asset ID. |
| Issue Name | Specifies the issue name to filter query results. Available when Query Based On is set to Issue Name. |
| Xref Type | Specifies the security xreference type to use to filter query results. Available when Query Based On is set to Xref ID. |
| Xref ID | Specifies the security xreference for the Xref ID type to filter query results. Required when Query Based On is set to Xref ID. |
| Source Name | Specifies the data source to filter query results. For example, CUSTODY. |
| Max Items | Specifies the maximum number of result records that are returned for viewing. Default is 100 records. |
Query ESTAR Cash Transactions
You can query the Eagle data warehouse to display ESTAR cash activity for a given data source and effective date. Results are based on the ESTAR_TRADED_CASH_ACTIVITY and the ESTAR_SETTLED_CASH_ACTIVITY tables in the ESTAR database.
You must set DataSetOption=3 or DataSetOption=4 in the MSGSERVICE.INI file to view the ESTAR report option.
To create the ESTAR Cash Transaction report:
- From the Cash Recon console, click Query ESTAR Cash Transaction in the left pane.
- Click the Query ESTAR Cash Transaction tab.
You see the ESTAR Cash Transaction panel. - Complete the fields on the Query ESTAR Cash Transaction panel.
- Click Search.
You see the ESTAR Cash Transaction report.
Query ESTAR Cash Transaction Panel Options
The following table describes the required options on the ESTAR Cash Transaction panel.
| Option | Description |
|---|---|
| Query Date Type | Specifies the type of date range to filter cash activity query results. Options include:
|
| Start Date | Specifies the low date to include in cash activity query results. |
| End Date | Specifies the high date to include in cash activity query results. |
| Entity ID | Specifies the entity ID to filter query results. |
| Base Currency | Specifies the base currency to filter query results. |
| Transaction Status | Specifies the transaction status to filter query results. Options include:
|
| Query Based On | Specifies the security qualification to use to filter query results. Options include:
|
| Primary Asset ID | Specifies the asset identifier to filter query results. Available when Query Based On is set to Primary Asset ID. |
| Issue Name | Specifies the issue name to filter query results. Available when Query Based On is set to Issue Name. |
| Xref Type | Specifies the security xreference type to use to filter query results. Available when Query Based On is set to Xref ID. |
| Xref ID | Specifies the security xreference for the Xref ID type to filter query results. Required when Query Based On is set to Xref ID. |
| Max Items | Specifies the maximum number of result records that are returned for viewing. Default is 100 records. |
You can optionally qualify report results by security type, share class, transaction type, flow type, cash category, processing security type, accounting basis, ticker, and investment type.
0 Comments