View Income Activity in the Income Object
In the Position Viewer workspace, the Income object displays income activity, including amortization, for a position.
To view income activity related to a specific position:
In Accounting Center, in the left navigation pane, click Reports > Position Viewer.
Select the position you want to view.
In the Reports list, select Income.
You see the tabs that apply to the Income object.Select a tab, or if you cannot see all the tabs at once, you can:Â
- Click the down arrow at the left of the tabs to show a list of available tabs, and then select the tab you want to view.
- Click the left/right arrows at the right of the tabs to move forward or backwards through the tabs, and then select the tab you want to view.Â
When there is viewable activity for a specific tab, Data Loaded (green circle) appears next to the tab name to indicate that data is available. If the system did not yet check whether data is available, a question mark appears next to the tab name until you click the tab.Click a row to view the entire contents of that row.
For example, clicking the Income Lots tab displays daily income activity at the lot level for the selected position. Key fields within the Income object are Accr Delta Base and Accr Delta Local, which display the daily accrual factor for the selected lot. Note when researching income issues within Position Viewer, you may need to change the Income Report Start Date field on the Query Positions window to research items from a previous year.
Income Object Tabs
The following are the tabs associated with the Income object.
Tab Name | Description |
---|---|
Income Summary | Displays basic field/value information. |
SMF Reference | Displays security master detail information. |
Income Position | Displays current income position. |
Income Lots | Displays lot level income activity, including daily income activity at the lot level for the selected position. |
Income Close Lots | Displays lot level closed income activity. |
Income Cancel Open | Displays canceled income from open transactions. |
Income Cancel Close | Displays canceled income from close transactions. |
Income Sub Lots | Displays sub lot level income activity, including daily income activity at the sub lot level for the selected position. You can use this tab to view term loan facility level income broken down by underlying term loan contracts. |
Income Sub Cancel Open | Displays canceled income from open transactions at the sub lot level. You can use this tab to view cancelled term loan facility level income broken down by underlying term loan contracts. |
Income Object Example
In the following example, after you select the Income option, the Position Viewer displays income activity, including amortization.
Within the Income object, you can click the Income Lots tab to display daily income activity, at the lot level, for the selected position. In the following figure, you can see in the Income Lots tab that on July 11, there are two separate lots.
The Income object shows the accrual details for each of these tots. You can double-click a selected row to view the entire contents of that row.
The key data element in the Income object is the Accr Delta (Base and/or Local) column value, which displays the daily accrual factor for the selected lot.
When you research Income object issues from a previous year in Position Viewer, you may need to change the Income Report Start Date field value in the Search Details pane.
In the previous figure, the Income Report Start Date field value has a default value of 1 Jan 2017. If you want to research income activity from 2016 or earlier, you need to change this date and resubmit the query.
Key Data Elements
The following are key data elements in the Income object.
Option | Tag | Description |
---|---|---|
Accr Delta Base | 589 | Daily accrued interest in the account’s base currency. |
Accr Ptd Base | 588 | Period-to-date accrued interest in the account’s base currency. |
Accr Fytd Base | 2717 | Fiscal year-to-date accrued interest in the account’s base currency. |
Accr Ltd Base | 585 | Life-to-date accrued interest in the account’s base currency. |
Accr Mtd Base | 587 | Month-to-date accrued interest in the account’s base currency. |
Amort Ptd Base | 598 | Amortization period to date base. |
Amort Ltd Base | 595 | Amortization life to date base. |
Amort Mtd Base | 597 | Amortization month to date base. |
Amort Delta Base | 599 | Amortization delta base. |
Amort Method | 113 | Amortization method (for example, SL, SLA, CY1, CY2, NONE). |
Amort Yield | 75 | Amortization yield. |
Coupon Begin Date | 992 | Day 1 of the coupon period. |
Coupon End Date | 993 | End date of the coupon period. |
Coupon Type Code | 97 | I=Variable, F=Fixed, and so on. |
Earned Thru Date | 461 | Effective date of the earnings/income data. |
The Accr Spread fields are populated when the account has Coupon Spreading enabled.