Versions Compared

Key

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

...

To view cash activity information:

  1. In Accounting Center, in the left navigation pane, click Reports > System Queries > STAR to PACE Direct > Cash Activity Table Query.
    You see the Cash Activity Table Query panel.

  2. Complete the options on the Cash Activity Table Query panel.

  3. Under Result Options, in the Format area, click Grid or Advanced Report for the report view you want.

  4. In the Location area, click Show results after submit. Or, you can click Send results to Scheduler for optimum performance when submitting ad hoc reports that involve a significant amount of data.

  5. Click Submit.
    The report appears on your desktop for the view selected.

Cash Activity Table Query Panel Options

The following table lists the fields and field descriptions for the Cash Activity Table Query panel.

Option

Description

Search Criteria

Source Name

Specifies the source.

Date Type

Specifies the type of date for your query result. Options include:

  • Post Date

  • Trade Date

  • Accounting Date

  • Settlement Date

  • Month End Date

Query Based On

Allows you to qualify your query result. Options include:

  • Entity ID. Default.

  • Security Alias. The Issue Name, Issue Symbol, and Primary Asset ID fields unhide for data entry.

  • Security Alias and Entity ID. The Issue Name, Issue Symbol, and Primary Asset ID fields unhide for data entry.

  • No Filter.

Optional Parameters

Entity ID

Specifies the entity identifier for a portfolio, sector portfolio, composite portfolio, or Master Fund.

Entity Name

Specifies the entity by the name of the entity.

Event Type

Displays the event type value Q_CASH_ACTIVITY.

Start Date

Specifies the start date for your query results. The default is today's date.

End Date

Specifies the end date for your query results. The default is today's date.

Include Reflexive Flows

Indicates whether to include reflexive flows. A reflexive flow is an equal and opposite record that represents the currency cash flow of the transaction. Options include:

  • No (Default). Do not include reflexive flows.

  • Yes. Include reflexive flows.