Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

The Settled Cash Open Lot Table Query allows you to research settled cash for open lots processed by STAR to PACE Direct based on data stored in the SETTLED_CASH_OPEN_LOTS table in the HOLDING database in Eagle PACE.

To view settled cash open lots in Eagle PACE:

  1. In Accounting Center, in the left navigation pane, click Reports > System Queries > STAR to PACE Direct > Settled Cash Open Lot Table Query.
    You see the Settled Cash Open Lot Table Query panel.
  2. Complete the options on the Settled Cash Open Lot 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.

Settled Cash Open Lot Table Query Panel Options

The following table lists the fields and field descriptions for the Settled Cash Open Lot Table Query panel.

Option

Description

Optional Parameters


Entity ID

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

Entity Name

Specifies the name of the entity.

Acctg Basis

Specifies the accounting basis for the entity. For example, USTAX, GAAP, or IFRS. This field appears if you set the Reporting Source field to Specific Accounting Basis.

Issue Name

Specifies the issue name.

Issue Symbol

Specifies the issue symbol.

Primary Asset ID

Specifies the primary asset ID.

Search Criteria


Reporting Source

Specifies the accounting basis as the reporting source to use for qualifying the query. Options include:

  • Across All Accounting Basis. Every accounting basis of the selected entities is used as the reporting source.
  • Primary Accounting Basis Only (Default). Only the primary accounting basis for the entity, used as the reporting source.
  • Specific Accounting Basis. Allows you to choose a specific accounting basis to use as the reporting source. The Accounting Basis field unhides for data entry in the Optional Parameters section.

Source Name

Displays the source name. For example, STARDIRECT. The field appears if you set the Reporting Source field to Primary Accounting Basis.

Event Type

Displays the event type value Q_SCOL.

Date

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

  • No labels