Query MSGCENTER Cash Work Tables

When reconciling using MSGCENTER work tables, you can use the Cash Recon console to view the cash match exceptions table and the associated MSGCENTER work tables directly with the source data loaded from the Eagle data warehouse, Eagle STAR, or custodian files.

You must set DataSetOption=1 to view work table queries for the MSGCENTER database.

Create Cash Recon Results Summary Report

The Cash Recon Results Summary report displays cash record counts by entity for the date qualifications submitted. You can select a count record to view the underlying cash activity detail records in a companion pane.

To create the Cash Recon Results Summary report based on MSGCENTER work tables:

From the Cash Recon console, click Cash Recon Results Summary in the left pane.
Click the Query Cash Recon Results Summary tab.
You see the Query Cash Recon Results Summary panel.
Complete the fields on the Query Cash Recon Results Summary panel.
Click Search.
You see the Query Cash Recon Results Summary report.

On this page

Query Cash Recon Results Summary Panel Options

The following table describes the key options on the Query Cash Recon Results Summary panel.

Option	Description
Entity List	Specifies the entity list to use filter query results.
Primary Asset ID	Specifies the asset identifier to filter query results.
Select by Post Date	Indicates whether to filter query results by an exact post date or post date range. The default is Exact Value.
Post Date	Specifies the post date to include in cash activity query results.
Select by Trade Date	Indicates whether to filter query results by an exact trade date or trade date range. The default is Exact Value.
Trade Date	Specifies the trade date to include in cash activity query results.
Select by Settlement Date	Indicates whether to filter query results by an exact settlement date or settlement date range. The default is Exact Value.
SettlementDate	Specifies the settlement date to include in cash activity query results.
Max Items	Specifies the maximum number of result records that are returned for viewing. Default is 100 records.

Query Cash Transactions

The Cash Transaction report displays the cash activity records loaded to the CASH_TXN work table in the MSGCENTER database. These records are typically refreshed from Eagle STAR or copied from the Eagle data warehouse.

To submit the Cash Transaction query for the MSGCENTER work tables:

From the Cash Recon console, click Query Cash Txn in the left pane.
Click the Query Cash Txn tab.
You see the Query Cash Txn panel.
Complete the fields on the Query Cash Txn panel.
Click Submit.
You see the Query Cash Txn report.

Query Cash Txn Panel Options

The following table describes the key options on the Query Cash Txn panel.

Option	Description
Status	Specifies the status of the cash activity match to filter query results. Options include: No match found Not Reconed Auto Recon Auto Recon With Tolerance Manual Recon Out-of-Balance
Query Date Type	Specifies the type of date range to filter cash activity query results. Options include: Post Date Trade Date Accounting Date Settlement Date
Start Post Date	Specifies the low post date to filter query results.
End Post Date	Specifies the high post date to filter query results.
Entity ID	Specifies the entity ID to filter query results. You can use a composite entity ID to view the roll up of all entities in the composite at the security level.
Source Name	Specifies the source to filter query results. For example, CUSTODY.
Trade Date	Specifies the trade date to filter query results.
Accounting Date	Specifies the accounting date to filter query results.
SettlementDate	Specifies the settlement date to filter query results.
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 assigned by and assigned to users, cash category, primary asset id, has comments (yes/no), transaction type, flow type (receipts/disbursements), and transaction status (traded/settled).

Query Cust Cash Transactions

The Cust Cash Transaction report displays records on the CUST_CASH_TXN work table in the MSGCENTER database. These records are typically loaded from custodian files.

To create the Cash Transaction query for the MSGCENTER work tables:

From the Cash Recon console, click Query Cust Cash Txn in the left pane.
Click the Query Cust Cash Txn tab.
You see the Query Cust Cash Txn panel.
Complete the fields on the Query Cust Cash Txn panel.
Click Submit.
You see the Query Cust Cash Txn report.

Query Cust Cash Txn Panel Options

The following table describes the key options on the Query Cust Cash Txn panel.

Option	Description
Status	Specifies the status of the cash activity match to filter query results. Options include: No match found Not Reconed Auto Recon Auto Recon With Tolerance Manual Recon Out-of-Balance
Start Post Date	Specifies the low post date to filter query results.
End Post Date	Specifies the high post date to filter query results.
Entity ID	Specifies the entity ID to filter query results. You can use a composite entity ID to view the roll up of all entities in the composite at the security level.
Source Name	Specifies the source to filter query results. For example, CUSTODY.
Trade Date	Specifies the trade date to filter query results.
Accounting Date	Specifies the accounting date to filter query results.
SettlementDate	Specifies the settlement date to filter query results.
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 assigned by and assigned to users, cash category, primary asset id, has comments (yes/no), transaction type, flow type (receipts/disbursements), transaction status (traded/settled), and custodian account.