Query Position Data for One Portfolio
To query position data for one portfolio:
- From any Eagle window, click the Eagle Navigator button to access the Eagle Navigator.
- Enter Position Viewer in the Start Search text box.
- Click the Position Viewer (Accounting Center) link to access the Position Viewer.
You see the Query Positions window. The Query Based On field displays One Portfolio by default.Â
 - Complete the options on the Query Positions window. See the Query Positions Window Options - Query Based on One Portfolio section.
- Click Search.
Query Positions Window Options - Query Based on One Portfolio
The following are the options for a query based on one portfolio in Position Viewer:
- Query Based On. Determines the scope of position data to return. One Portfolio is displayed by default. Returns position data based on a single account.
- Entity Name. Specifies the unique account description for the entity to query.
- Entity ID. Specifies the unique account identifier for the entity to query. This is the primary key to the Entity table.
- Src Name. Specifies the name of the interface source. You can accept the default based on the Entity Name and Entity ID field values.
- Cash Balance. Specifies the cash balance as of date. Available options include:
–  Settlement Date. Returns cash balances as of the settlement date.
–  Trade Date. Returns cash balances as of the trade date. - Position Type. Allows you to view position information for the current day or as of a point in time. Available options include:
–  Current. Allows you to view all positions as of the current day.
–  As Of. Allows you to view positions for a specified date. When using this option, select a date and select As Of Summary. - Account Basis. Specifies the accounting basis used by the entity. If there are multiple bases, select a basis from the drop down list.
- Base Currency. Displays the currency that the entity uses for accounting purposes.
- Cash Balance Date Type. Indicates the date type of cash balance record you want to view. Options include:
–  Posting date (Default)
–  Trade date
–  Accounting date
–  Contractual settlement date
–  Month end date - Display Zero Cash Balance. Indicates whether to include zero cash balances. A zero cash balance is a valid balance. Options include:
–  Yes. Default. The results include zero cash balance records for the specified cash position and asset currency.
–  No. The results exclude zero cash balances. - Rejection/Corporate Actions Begin Date. Specifies the begin date for which you want to view rejection and corporate action activity. If you specify a range, you exclude activity that occurred outside this date range from the Rejections and Corporate Action detail tabs in the Cost object.
- Rejection/Corporate Actions End Date. Specifies the end date for which you want to view rejection and corporate action activity.
- Trade Activity Start Date. Specifies the begin date for which you want to view trade activity. If you specify a range, you exclude trade activity that occurred outside this date range from the Trade Activity detail tab in the Cost object.
- Trade Activity End Date. Specifies the end date for which you want to view trade activity.
- Include Zero Holdings. Determines whether zero holdings appear in the query result. Available options include:
–  No. Do not include these holdings in the query result.
–  Yes. Include these holdings in the query result. - Select Date Range for Income History Query. Indicates whether to enter a date range to view income activity. If you specify a range, you exclude income activity that occurred outside this date range from the Income object.
- Income Report Start Date. Specifies the begin date to view income activity. Displayed when you select Yes in the Select Date Range for Income History Query field.
- Income Report End Date. Specifies the end date to view income activity. Displayed when you select Yes in the Select Date Range for Income History Query field.
- Max Items Composite. Specifies the maximum number of rows of data to return.
- Page Rows. Specifies the number of rows to return on the Query Result window, up to the maximum specified in the Max Items Composite field.
- Search. Executes the query based on the current query parameters. Returns data from the database in the Query Result view.
- Resubmit. Resubmits a query after you change some query parameters.
- Cancel. Stops the query that is currently executing.
- Clear Query. Clears the current query criteria from the query fields. This button is located both in the main toolbar and halfway down the right side.
- AutoSave Requests. Automatically saves queries for future use as you execute them.
- Save Query. Saves a query for use in future sessions of Position Viewer.
- Save as Default Query. Saves a query as the default query. The default query automatically runs each time you open Position Viewer.
- Delete. Permanently deletes the selected query.
- Clear. Permanently deletes all queries from the Position Viewer query list for your user ID. This includes the default query, which will no longer be available when you access Position Viewer.
- Properties. Opens the Query Properties dialog box where you can review the query parameters and enter a custom caption for the query.