The SDCOE Customer Resource Center is pleased to announce that we have published our first version of a query reference tool for you to use. The document is called Finance Query Reference Guide v.1.0.pdf (126 pp.). It is a compilation of all M_ and FAR_ queries used in the different PeopleSoft Finance modules, like Accounts Payable, Accounts Receivable, Budget, and so on. We hope you find this tool useful when determining which Finance queries to run.
How to read this guide:
The queries in the guide are listed alphabetically under the module that has the data.
Query name: The query name is displayed at the top of the page. You can search Query Viewer by query name. A diamond icon in the query name indicates there is information about a pivot table.
Query description: The query description is displayed below the name. This is the description of the query in the system; you can search by this, if desired.
Parameters: Sample parameters are provided.
Results: Sample results are provided. This is useful for seeing the fields that are included in the query.
Pivot table: For some queries, sample pivot table configurations are provided.