| Anchor |
|---|
| _Toc439930545 |
|---|
| _Toc439930545 |
|---|
|
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. |
|
| 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. |
| 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 |
| Specifies the security xreference type to use to filter query results. Available when Query Based On is set |
| Specifies the security xreference for the Xref ID type to filter query results. Required when Query Based On is set |
| 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. |
| Anchor |
|---|
| _Toc439930546 |
|---|
| _Toc439930546 |
|---|
|
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.
| Note |
|---|
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.
| Anchor |
|---|
| _Toc439930547 |
|---|
| _Toc439930547 |
|---|
|
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. |
| 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. |
| Specifies the security qualification to use to filter query results. |
| 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 |
| Specifies the security xreference type to use to filter query results. Available when Query Based On is set |
| Specifies the security xreference for the Xref ID type to filter query results. Required when Query Based On is set |
| 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.