...
| Query Name | Description | Query Events | ||
|---|---|---|---|---|
Cost/Cash/Income Positions | This query is available by default in the Position Viewer workspace. Allows you to search and review current position data in the ESTAR database and archive cost BLOB. Provides several options to search position data and allows searching for data that pertains to the current entity. Search types include:
| Shows the accounting data for three areas.
| ||
| Portfolio Valuation | Allows you to search and review portfolio valuations by entity and trade end date. |
| ||
| Ledger Reports | Allows you to search and review ledger balances and activity for trial balances, financial statements, and ledger balances. | Uses the following events:
| ||
| Wash Sale Adjustments | Displays close lot and open lot adjustments to audit open adjustment and close adjustment rows reflecting the incremental transfer of a loss, as well as the adjustment of the wash sale's eligible quantity. Information appears for the Wash Sale Adjustments object query only if you use the ESTAR tables to store wash sales adjustment information by converting the wash sales adjustments using the Convert Wash Sale Adjustments panel. Otherwise, if you do not convert wash sale adjustments, you can view wash sales information in the adjustment tabs displayed for the Cost object by default.
|
| ||
| Other Income/Expense | Allows you to search and review other income/expense data in the database. You can query data for the current Entity, Account Basis, Transaction Status (Traded or Settled), and Report Type (Accounting Date, Posting Date, Trade Date, and Contractual Settlement Date). |
| ||
| Dividend Income/Expense | Allows you to search and review dividend-related data in the database. You can search for data by the current Entity, Account Basis, All or Individual Securities, and Report Type (Accounting Date, Posting Date, Trade Date, and Contractual Settlement Date). |
| ||
| Interest Receivable/Payable | Allows you to search and review receivable/payable information. Query options include Entity and Report Type (Accounting Date, Posting Date, Trade Date, and Contractual Settlement Date). |
| ||
| Unsettled Transactions | Allows you to search and review unsettled transactions using an entity and start date. |
| ||
| PACE as of Positions | Allows you to search and review current as-of position data in the Eagle data warehouse. You can search data for the current entity. |
| ||
PACE as of Positions - Price | Allows you to search and review current as of position price data in the Eagle data warehouse. You can search data for the current entity or entity/security combination. |
| ||
PACE as of Position - One | Allows you to search and review current as-of position data in the Eagle data warehouse. You can search data for the current entity and accounting basis. |
| ||
PACE as of Positions - One | Allows you to search and review current as-of position data in the Eagle data warehouse. You can search data for the current entity and accounting basis. |
| ||
| Cash Position - Different Settlement Currency | Allows you to view the cash position when you want to display cash in a currency other than the entity's base currency.
|
|
...