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 |