EM_VCHRPYCNT_VW

(SQL View)
 Index Back

Voucher Inquiry view

This view is used by the Market Pay Module to retrieve all of the voucher inquiry page rows.

SELECT a.business_unit , sec.oprid , a.voucher_id , MAX(d.pymnt_cnt) FROM PS_VOUCHER a , ps_vendor b , ps_sec_bu_opr sec , ps_pymnt_vchr_xref d , ps_pymt_trms_hdr t WHERE sec.business_unit = a.business_unit AND a.vendor_setid = b.setid AND a.vendor_id = b.vendor_id AND a.business_unit = d.business_unit AND a.voucher_id = d.voucher_id AND t.setid = ( SELECT SETID FROM PS_SET_CNTRL_REC WHERE REC_GROUP_ID = 'FS_14' AND RECNAME = 'PYMT_TRMS_HDR' AND SETCNTRLVALUE = a.business_unit) AND a.pymnt_terms_cd = t.pymnt_terms_cd AND ((a.process_man_close = 'N' OR a.close_status <> 'C') OR (a.process_man_close <> 'N' AND d.pymnt_selct_status = 'E')) AND a.entry_status <> 'X' AND d.pymnt_type <> 'W' AND d.pymnt_selct_status <> 'X' AND ((a.VOUCHER_STYLE='PPAY' AND d.PREPAID_STATUS='P' ) OR a.VOUCHER_STYLE<>'PPAY') AND d.due_dt IS NOT NULL GROUP BY a.business_unit , sec.oprid , a.voucher_id

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EM_BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Buyer
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
4 PYMNT_CNT Number(5,0) INTEGER NOT NULL Payments