VCHR_AF_HDR_VW

(SQL View)
 Index Back

Voucher Approval Search

Voucher Approval Search Record

SELECT a.business_unit , a.voucher_id , a.appr_status , a.oprid , a.oprid_last_updt FROM PS_VOUCHER a , ps_bus_unit_tbl_ap c WHERE a.voucher_style <> 'TMPL' AND a.vchr_apprvl_flg = 'W' AND a.business_unit = c.business_unit AND ((c.match_apprv_flg = 'N') OR (c.match_apprv_flg = 'Y' AND a.match_status_vchr = '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') 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))) OR a.vchr_src IN ('SSI','XML','DCM','EXL') AND EXISTS ( SELECT 'X' FROM PS_EM_BUY_REG_TBL HH WHERE HH.BUSINESS_UNIT = A.BUSINESS_UNIT AND HH.EM_USE_AP_APPROVAL = 'Y'))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BU_AP_NONVW

2 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID

Default Value: NEXT

3 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
4 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
5 OPRID_LAST_UPDT Character(30) VARCHAR2(30) NOT NULL Last User to Update