- 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 tool.
You see the Position Viewer workspace. The Search Type option has a value of One Portfolio by default. - In the Search Details pane, complete the search criteria.
- Select the entity and source you want to view.
- Click the Account Basis field and select the entity's custody basis.
The custody basis is the entity's accounting basis that has its Position Cash Segregation Basis field set to Yes to enable cash segregation.
- Click the View by Custody Location field and click Yes or No.
If you select Yes, you limit your results to a single custody location. A custody location is a custodian bank with a custodian bank account number. If you select No, your results include all custody locations. - Click the Custodian Bank field or Custodian Bank Code field to select a custodian bank.
You can select a custodian bank which has an entity bank relationship defined for the entity or the entity's reporting composite. If multiple custodians have entity bank relationships with the entity, you can select one custodian. - Click the Cash Balance Date Type field and indicate the date type of cash balance record you want to view.
Options include:
– Posting date
– Trade date
– Accounting date
– Contractual settlement date
– Month end date - Click the Display Zero Cash Balances field and select Yes or No.
If you select Yes, the query includes cash balance records for the specified cash position and asset currency. A zero cash balance is a valid balance. Otherwise, the results exclude zero cash balances. - Complete the remaining search criteria in the Search Details pane.
Click the Search button.
You see the Cost, Cash, and Income objects for the position that met your criteria.WRITERS NOTE: you can no longer select View by Custody Location to limit results to one custody location. You get results only if you click + to add Custodian Bank and Custodian Bank Code AND select CUST..View the Cost, Cash, and Income position data.
If a position in an entity that uses cash segregation has holdings in multiple custody locations, the grid results can include multiple Cost objects, multiple Cash objects, and multiple Income objects for a single position in the custody basis.
View Segregated Asset Quantities in the Cost Object
If you use cash segregation, the Cost object for the custody basis allows you to view the asset quantity (units/shares) associated with a specified custody location for a position that has multiple custodians.
To view cost accounting information for a specific position with cash segregation:
- In the Position Viewer workspace, view positions for one portfolio by custody location.
- Select the position in the custody accounting basis that you want to view.
If the position in an entity that uses cash segregation has holdings associated with multiple custody locations in the custody basis, and you did not restrict your query to a single custody location, you see multiple Cost objects for that position. - In the Reports list, select Cost.
You see the tabs that apply to the Cost object. populated with data, if there is related activity available. Tabs containing data are highlighted. You can view the asset quantity (units/shares) associated with the specified custody location for a position. - Click a row to view the cost accounting activity in the Cost object.
The Source System Code column (tag 98) value for a position's custody basis identifies the entity bank relationship alias for the custodian associated with the segregated custodian quantity. This value matches the value of the transaction's Bank Alias (tag 16). (Otherwise, the Source System Code for a non custody basis displays a value of F.)
The following figure shows details from the Cost object for the custody basis of a position in an entity that uses cash segregation. In the Position Viewer search criteria, you set the View by Custody Location field to a value of No. As a result, the search results include cost information for more than one custodian location, and you see two Cost objects for the issue in the grid rather than a single Cost object.
If you click the row for the second Cost object, in the Summary tab you see the Source System Code column (tag 98). You can double-click the source system row to display the value of 361, in this example, for that Cost object in position's custody basis. This numeric value identifies the entity bank relationship alias for the custodian associated with the segregated custodian quantity. This value matches the value of the transaction's Bank Alias (tag 16).
If you click the Open Lots tab to view the transaction details and scroll to the right, you can see the custodian information for the transaction. You can see the Bank Alias value of 361, which identifies the instance of the entity bank relationship that applies to the transaction. The entity bank relationship links the custody location (custody bank/custody bank account number grouping) to the entity or entity group.
View Segregated Cash Balances in the Cash Object
You can view traded and settled cash balances associated with a Cash object. For entities that do not use cash segregation, you can view the overall cash balances. For entities that use cash segregation, you can view the Cash object in the entity's custody basis to view the cash and cash account associated with a specified custody location for a position that has multiple custodians.
The results for the Query Positions window display local currency cash balances. To view non local currency balances, you can select the Position Viewer's Cash Position - Different Settle Currency option.
To view cash activity for a specific position with cash segregation:
- From the Position Viewer tool, view positions for one portfolio by custody location.
- Select the position in the custody accounting basis that you want to view.
If the position in an entity that uses cash segregation has cash associated with multiple custody locations in the custody basis, and you did not restrict your query to a single custody location, you see multiple Cash objects for that position. - In the Reports list, select Cash.
You see the tabs that apply to the Cash object populated with data. The following tabs associated with the Cash object provide information related to cash segregation:
– Traded Cash Balances. Displays the traded cash balance records for the position.
– Settled Cash Balance. Displays the settled cash balance records for the position. - Click a row to view the cash activity in the Cash object.
In the Traded Cash Balance tab or the Settled Cash Balance tab for the position's custody basis, the cash balance's Source System Code column (tag 98) value identifies the entity bank relationship instance for the custodian associated with the segregated custodian cash amount in the custody basis. This value matches the value of the transaction's Bank Alias (tag 16). (Otherwise, the Source System Code for a non custody basis displays a value of F.) The Cash Account Alias column (tag 11698) identifies the cash account relationship instance for the cash balance record.
In the following Cash object example, you select the custody basis of a position in an entity that uses cash segregation. In the Position Viewer query you set the View by Custody Location field to a value of No. As a result, the query results include cost information for more than one custodian location, and you see two Cash objects for the issue in the upper pane rather than a single Cash object.
After you click the Cash Position - Asset Currency tab, you can click the Traded Cash Balance tab or the Settled Cash Balance tab to view the cash balances for the selected custody location. The cash balance's Source System Code column (tag 98) value identifies the entity bank relationship instance for the custodian associated with the segregated custodian cash amount in the custody basis. This value matches the value of the transaction's Bank Alias (tag 16). The Cash Account Alias column (tag 11698) identifies the cash account relationship instance for the cash balance record.
If you examine the cash for a trade, corporate action, or direct cash event, you can see the information for the custodian cash account that the system assigned during processing during rules defined in entity bank relationships and cash account relationships. You can view the custodian details in the Receipts, Disbursements, Traded, and Settled tabs, for example.
Search Position Data for All Custodial Banks and One Security
In the Position Viewer tool, you can view position data for actual cash settlements across all custody banks for a single security. The All Custodial Banks - One Security option restricts results to the custody accounting basis used with cash segregation. The query results shows results for a single security held across all entities within a database partition. You can view unit and cash balances by both entity and custody location. If you hold a security in multiple custodian banks, you can identify the quantity for holdings associated with each custodian. You can also identify the entitlements for units or cash that are segregated at the custodian level.
To search position data for all custodial banks and one security:
- 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 Position Viewer workspace. - In the Search type list, select All Custodial Banks - One Sec.
In the Search Details pane, you see the search criteria for the selected search type. When you select this option, you cannot choose an entity. The Account Basis field displays a value of CUST, indicating that you are viewing results for the custody accounting basis across all entities. The custody basis is the entity's accounting basis that has its Position Cash Segregation Basis field set to Yes to enable cash segregation. Additional fields appear where you can specify issue criteria. - Complete the search criteria.
- Click the Search button.
You see the selected search criteria in the header area. You see the search results in the grid. The grid shows a row for each custody location where you hold the security. The Custodian Bank Code column and the Custody Bank Acct Num column identify the custody location. You can also view the Account and Units for the holding at the custody location. - View the Cost, Cash, and Income position data.
In the Reports pane, you can review the Cost, Cash, and Income objects for the position for each custodial bank that met your criteria for the selected security.
The following example shows the search results when you select the All Custodial Banks - One Security option for a security held in multiple custody locations. For a single security, you can have holdings for multiple entities/accounts in multiple custodian bank code/custody bank account number groupings.
Add Comment