VCHR_APRV_WF_VW

(SQL View)
 Index Back

Voucher Payment Approval


SELECT A.BUSINESS_UNIT , A.VOUCHER_ID , A.INVOICE_DT , A.ORIGIN , A.VCHR_SRC , A.GRP_AP_ID , A.VENDOR_SETID , A.VENDOR_ID , 'A' FROM PS_VOUCHER A , PS_BUS_UNIT_TBL_AP B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.ENTRY_STATUS = 'P' AND A.APPR_STATUS <> 'A' AND A.APPR_CHECK_FLG = 'N' AND A.VCHR_APPRVL_FLG = 'S' AND A.MATCH_STATUS_VCHR IN ('M', 'N') AND ((A.vchr_src IN ('AMLS', 'ARCR', 'BILL', 'CLBK', 'CNTR', 'CONS', 'EDI', 'FRE', 'MTCH', 'NERS', 'ONL', 'PAYR', 'PBIL', 'PERS', 'PPAY', 'PROC', 'QUCK', 'RBCR', 'RETL', 'RPOV', 'RTV', 'SAD', 'SPRO', 'TRPM', 'XLS','PRQ')) OR ((A.vchr_src IN ('XML','DCM','SSI','EXL') AND EXISTS ( SELECT 'X' FROM PS_EM_BUY_REG_TBL D WHERE D.BUSINESS_UNIT = A.BUSINESS_UNIT AND D.EM_USE_AP_APPROVAL = 'Y')) OR (A.VCHR_SRC IN ('XML','DCM') AND NOT EXISTS ( SELECT 'X' FROM PS_EM_BUY_REG_TBL H , PS_EM_AGREEMENT g , PS_SET_CNTRL_REC i WHERE i.setcntrlvalue = A.business_unit AND i.rec_group_id = 'EM_01' AND i.recname = 'EM_AGREEMENT' AND i.setid = g.SETID AND H.BUSINESS_UNIT = A.BUSINESS_UNIT AND A.vendor_setid = g.vendor_setid AND A.vendor_id = g.vendor_id AND A.vndr_loc = g.vndr_loc))))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
3 INVOICE_DT Date(10) DATE Invoice Date
4 ORIGIN Character(3) VARCHAR2(3) NOT NULL Origin
5 VCHR_SRC Character(4) VARCHAR2(4) NOT NULL Voucher Source
6 GRP_AP_ID Character(10) VARCHAR2(10) NOT NULL Control Group ID
7 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
8 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
9 APPR_STATUS Character(1) VARCHAR2(1) NOT NULL Approval status flag used on appr_inst_log and derived records to track virtual approver status
A=Approved
D=Denied
P=Pending

Default Value: P