View Settled Cash Disposal Lots
The Settle Cash Disposal Lot Table Query allows you to research settled cash disposal lots processed by STAR to PACE Direct based on data stored in the SETTLED_CASH_DISPOSAL_LOTS table in the TRADES database in the Eagle data warehouse.
To view settled cash disposal lots in the Eagle data warehouse:
In Accounting Center, in the left navigation pane, click Reports > System Queries > STAR to PACE Direct > Settle Cash Disposal Lot Table Query.
You see the Settle Cash Disposal Lot Table Query panel.Complete the options on the Settle Cash Disposal Lot Table Query panel.
Under Result Options, in the Format area, click Grid or Advanced Report for the report view you want.
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.
Click Submit.
The report appears on your desktop for the view selected.
Settle Cash Disposal Lot Table Query Panel Options
The following table lists the fields and field descriptions for the Settle Cash Disposal 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 entity by 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. |
Search Criteria | Â |
Reporting Source | Specifies the accounting basis as the reporting source to use for qualifying the query. Options include:
|
Source Name | Displays the source name. For example, STARDIRECT. The field appears if you set the Reporting Source field to Primary Accounting Basis. |
Query Based On | Allows you to qualify your query result. Options include:
|
Date Type | Specifies the type of date to use for qualifying the query. Options include:
|
Event Type | Displays the event type value Q_SCDL. |
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. |
Â