The Eagle PACE General Ledger Balance Table Query allows you to research general ledger account balances transferred by STAR to PACE Direct based on data stored in the GL Detail Posting table in the Ledger LEDGER database in the Eagle PACEdata warehouse. This report provides balance information from the GL_DETAIL_POSTING table as well as security details from the SECURITY_MASTER table.
To report Eagle PACE GL Balances in the Eagle PACEdata warehouse:
In Accounting Center, in the left navigation pane, click Reports > System Queries > STAR to PACE Direct > Eagle PACE General Ledger Balance Table Query.
You see the Eagle PACE General Ledger Balance Table Query panel.Complete the options on the Eagle PACE General Ledger Balance Table Query panel.
Click Submit.
...
Eagle PACE General Ledger Balance Table Query Panel Options
The following table lists the fields and field descriptions for the Eagle PACE General Ledger Balance Table Query panel.
Option | Description |
|---|---|
Entity Parameters |
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. |
Position Parameters |
Issue Name | Specifies the issue name for your report result. |
Issue Symbol | Specifies the issue symbol for your report result. |
Primary Asset ID | Specifies the primary asset ID for your report result. |
Asset Currency | Specifies the currency in which the security is priced for your report result. |
Xref Security ID | Specifies the cross reference security ID for your report result. |
Xref Type | Specifies the cross reference type for your report result. |
Run Options |
Event Type | Displays the event type value GL_DETAIL_POSTING_QRY. Typically, this field is hidden. |
Source | Specifies the source. |
End Date | Specifies the date associated with general ledger balances to include in the report. The default is today's date. |
Syncsend Engine Router | (Hidden) Indicates whether the system uses the Accounting engine or a report service to process the report results. Options include:
|