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:

  1. In Accounting Center, in the left navigation pane, click Reports > Position Viewer.

  2. Select the position you want to view.

  3. In the Reports list, select Income.
    You see the tabs that apply to the Income object.

    Position Viewer - Income tabs
  4. 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.

  5. 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

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.

Position Viewer - Income Lots tab

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.

View Row dialog box

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.

Position Viewer - 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

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.