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 Disposal Lot Table Query allows you to research disposal lots processed by STAR to PACE Direct based on data stored in the DISPOSAL_LOTS table in the Eagle PACE TRADES database.

To view disposal lots in Eagle PACE:

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

Disposal Lot Table Query Panel Options

The following table lists the fields and field descriptions for the Disposal Lot Table Query panel.

Option

Description

Optional Parameters


Query Based On

Allows you to qualify your query result. Options include:

  • Date Range.
  • 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.

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.

Entity Type

Displays the entity type.

Event Type

Displays the event type value DISPOSAL_LOT_QUERY.

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.

Search Criteria


Source Name

Specifies the source to use for qualifying the query.

Date Type

Specifies the type of date to use for qualifying the query. Options include:

  • Post Date
  • Trade Date
  • Accounting Date (Default)
  • Settlement Date
  • Month End Date
  • No labels