|
This query returns a list of project transaction rows with analysis types of PAY and GLE |
Trans Rows for PAY, GLE |
|
To compare results and to isolate differences in the PC to GL Reconciliation Report (uses the journal trans table) |
GL to PC Reconciliation |
|
To compare results and to isolate differences in the PC to GL Reconciliation Report (uses the project resource table) |
PC to GL Reconciliation |
|
To display a list of projects with a particular status for a given Project Business Unit |
Projects at Status |
|
To display a listing of contracts associated with a particular project and activity combination |
Contracts for Project(s |
|
To display all the trees that a project or range of projects are associated with for a given business unit |
Trees for Projects |
|
To display purchasing and accounts payable information for charges against a project |
Projects Vendor Information |
|
To display the status for a project or range of projects for a given Project Business Unit |
Status of Projects |
|
To find a list of project team members |
Team Members for Project(s) |
|
To find a listing of all Projects ID’s that have been assigned to any agency tree |
Projects/Reporting Tree 3 |
|
To find any project not assigned to a tree |
Projects/Reporting Tree 2 |
|
To find the manager for a project or range of projects |
Manager for Project(s) |
|
To obtain a listing of transaction rows for a specified Business Unit and Range of Project IDs |
Transactions for Analysis Type |
|
To obtain the Asset IDs associated to a specific Project ID or a range of Project IDs |
Project Asset IDs |
|
To retrieve a list of projects and related transactions |
Summary and Detail Projects |
|
To select all project/activity combinations for the specified Project Business Unit that does not have an associated contract |
Proj/Activity with No Contract |
