Anchor
_Toc439930545 _Toc439930545

Query Warehouse Cash Activity Panel Options

The following table describes the key options on the Warehouse Cash panel.

• Query Date Type. Specifies the type of date range to filter cash activity query results.
  Options include:
  –  Accounting Date
  –  Post Date
  –  Settlement Date
  –  Trade Date
• 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
  –  Issue Name (Default)
  –  Xref ID
• 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.

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.

To create the ESTAR Cash Transaction report:

1. From the Cash Recon console, click Query ESTAR Cash Transaction in the left pane.
2. Click the Query ESTAR Cash Transaction tab.
   You see the ESTAR Cash Transaction panel.
3. Complete the fields on the Query ESTAR Cash Transaction panel.
4. 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.

• Query Date Type. Specifies the type of date range to filter cash activity query results.
  Options include:
  –  Accounting Date
  –  Month End Date
  –  Post Date
  –  Settlement Date
  –  Trade Date
• 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:
  –  Traded
  –  Settled
• Query Based On. Specifies the security qualification to use to filter query results.
  Options include:
  –  Primary Asset ID
  –  Issue Name (Default)
  –  Xref ID
• 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.