Finance Queries
The following are some useful queries which are useful for departments
Peoplesoft Finance Navigation: Main Menu->Reporting Tools->Query->Query Manager
| Query Name | Description |
|---|---|
| UHS_AP_INTEREST_BY_DEPT_NODE | Late interest amt by dept node |
| UHS_AP_SEARCH_FOR_PAYMENTS | Vchr Pmts by Vchr Pmt Date |
| UHS_AP_SEARCH_FOR_VENDORS | Search for AP/PO vendors |
| UHS_AP_SEARCH_FOR_VOUCHERS | Vchrs by Vchr Accounting Date |
| UHS_AP_UNPOSTED_VOUCHERS | Vouchers not posted |
| UHS_CC_LOOKUP | Cost center lookup |
| UHS_OPEN_COMMITMENTS_DETAIL | Open commitments by DeptID |
| UHS_PO_BY_DEPT_NODE | POs by Dept, Project/Grant |
| UHS_WF_AP | AP voucher approval history |
| UHS_WF_AP_DENY_WITH_COMMENT | AP vouchers-Deny with comment |
| UHS_WF_AP_NOT_POSTED | AP vouchers not posted |
| UHS_WF_AP_USER_ACTIVITY | AP voucher activity by user |
| UHS_WF_GL | GL journal approval history |
| UHS_WF_GL_DENY_WITH_COMMENT | GL journal - deny with comment |
| UHS_WF_GL_NOT_POSTED | GL journals not posted |
| UHS_WF_REQ | Requisition Approval History |
| UHS_WF_REQ_DENY_WITH_COMMENT | Requisition-Deny with Comment |
| UHS_WF_REQ_NOT_APPROVED | Requisition not Approved |
| UHS_WF_SC | SC voucher approval history |
| UHS_WF_SC_BY_SERVICE_CENTER | SC vchr appr hist by Svc Ctr |
| UHS_WF_SC_DENY_WITH_COMMENT | SC vouchers-Deny with comment |
| UHS_WF_SC_NOT_POSTED | SC vouchers not posted |