Versions Compared

Old Version 1

changes.mady.by.user Copy Page Tree

Saved on

compared with

New Version 2

changes.mady.by.user Former user

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


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.

Noteinfo

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

Anchor
_Toc439930549
_Toc439930549
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:

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


Panel
borderColor#9F9F9F
titleColor#F7F9F9
titleBGColor#B48436
borderStyledashed
titleContent on this page:

Table of Contents
maxLevel2
indent2 px


Anchor
_Toc439930550
_Toc439930550
Query Cash Recon Results Summary Panel Options

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

OptionDescription
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
Settlement Date.
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.

Anchor
_Toc439930551
_Toc439930551
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:

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

Anchor
_Toc439930552
_Toc439930552
Query Cash Txn Panel Options

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

OptionDescription
Status
.

Specifies the status of the cash activity match to filter query results.


Options include:

–  No
  • No match found
–  Not
  • Not Reconed
–  Auto
  • Auto Recon
–  Auto
  • Auto Recon With Tolerance
–  Manual
  • Manual Recon
–  Out
  • Out-of-Balance
Query Date Type
.

Specifies the type of date range to filter cash activity query results.


Options include:

–  Post
  • Post Date
–  Trade
  • Trade Date
–  Accounting
  • 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.
Settlement Date.
SettlementDateSpecifies 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).

Anchor
_Toc439930553
_Toc439930553
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:

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

Anchor
_Toc439930554
_Toc439930554
Query Cust Cash Txn Panel Options

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

OptionDescription
Status
.

Specifies the status of the cash activity match to filter query results.


Options include:

–  No
  • No match found
–  Not
  • Not Reconed
–  Auto
  • Auto Recon
–  Auto
  • Auto Recon With Tolerance
–  Manual
  • Manual Recon
–  Out
  • 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
Settlement Date.
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.