STAR to PACE Direct provides several useful panels for viewing/maintaining tables, logs, price exceptions, and price overrides.
...
- In Accounting Center, in the left navigation pane, click Reports > System Queries.
- In the left navigation, click STAR to PACE Direct. Or, for archive queries, click Archive.
You see the options for the available panels. - Select the option for the panel you want to use.
...
Query | Description | Database | Database Table |
|---|---|---|---|
Displays performance returns. | PerformPERFORM | PERF_SEC_RETURNS | |
Displays the list of PACE dictionaries. | RulesRULES | DICTIONARIES | |
Displays position level data. | HoldingHOLDING | POSITION | |
Displays lot level holdings data. This includes the individual open lots created by Eagle Accounting for each position. | HoldingHOLDING | LOT_LEVEL_POSITION | |
Displays trade details from the Trades tables. | TRADES | TRADE | |
Displays the individual close lots created by Eagle Accounting, including the individual gain/ loss for each close lot. | TradesTRADES | DISPOSAL_LOTS | |
Displays individual cash activity data from the Cash Activity table.Cash | CASH | CASH_ACTIVITY | |
Displays the individual settled cost cash open lots from the settled cash open lots table. | HoldingHOLDING | SETTLED_CASH_OPEN_ LOTS | |
Displays the individual settled cash activity records from the Settled Cash Activity table. | TradesTRADES | SETTLED_CASH_ACTIVITY | |
Displays the individual settled cash activity disposal lots from the Settled Cash Disposal Lot table. | TradesTRADES | SETTLED_CASH_DISP LOTS | |
Displays the daily or monthly general ledger account balances from the General Ledger Detail Posting table and provides security details from the Security Master table.Ledger | LEDGER | GL_DETAIL_POSTING | |
Interest Income Table query | No longer supported. | Do not use |
...
- In Accounting Center, in the left navigation pane, click Setup > Admin > STAR to PACE Maintenance.
You see the list of panels available. - Select the panel you want to use.
For detailed instructions about the options available for querying/rebuilding the Delta Trigger logs and maintaining the prices and FX rates exception information, see Perform Data Maintenance.
...
You can maintain entity price overrides, including adding, changing, and deleting price overrides at the entity level. The price in the Eagle data warehouse is an enterprise wide value for a given source. Under certain conditions, for a given entity, you may want to deviate from this price.
For detailed instructions information about the Entity Price Override options available for maintaining entity price overrides, see Add Entity Price Overrides, Delete an Entity Price Override, and Change an Entity Price Override.
...