The List Delta Log - Detail Level panel retrieves and reports on data from the SPD_DELTA_TRIGGER_LOG and the SPD_DELTA_TRIGGER_LOG_HIST tables. Information includes the instance, account, accounting and post dates, status switch, asset currency, event and batch identifiers, target event id, link event id, MT query type, event type, cash category, cash event type, update date, and update source.
To view Delta Trigger Log information at the detail level:
- In Accounting Center, in the left navigation pane, click Setup > Admin > STAR to PACE Maintenance > List Delta Log – Detail Level.
You see the List Delta Log – Detail Level panel. - Complete the options on the List Delta Log – Detail Level panel.
- Under Result Options, in the Format area, click Grid or Advanced Report for the report view you want.
- Click Submit.
You see the results that met your criteria in the Show All tab.
List Delta Log – Detail Level Panel Options
The following table lists the fields and field descriptions for the List Delta Log – Detail Level panel.
Option | Description |
|---|---|
List S2P Direct Log – Detail Level | |
Post Date | Specifies the post date for your report result. For example, enter today's date. |
Accounting Date | Specifies the accounting date for your report result. |
Entity ID | Specifies the entity identifier for a portfolio, sector portfolio, composite portfolio, or Master Fund. |
Entity Name | Specifies the entity by the name of the entity. |
Accounting Basis | Specifies the accounting basis for the entity. For example, USTAX, GAAP, or IFRS. |
Event Type | Displays the event type value QRY_DELTA_LOG_DETAIL. |
Asset ID Type | Specifies the primary asset identifier type for the security. For example, CUSIP, ISIN, or SEDOL. |
Issue Name | Specifies the issue name. |
Asset ID | Specifies the primary asset identifier. |
Long/Short Indicator | Specifies whether the position is long or short. |
Max Rows | Specifies the maximum number of rows. Default value is 5,000. |
Partition | Specifies the database partition for the position. This value is automatically established by a lookup based on the specific entity. |
0 Comments