EM_INVOICE_VW

(SQL View)
 Index Back

Supplier Manage Bills View

This view is used by eSettlements to retrieve all of the voucher inquiry panel rows.

SELECT a.business_unit , a.vendor_setid , a.vendor_id , a.vndr_loc , a.invoice_id FROM PS_VOUCHER a , ps_pymnt_vchr_xref d WHERE a.business_unit = d.business_unit AND a.voucher_id = d.voucher_id AND ( a.process_man_close = 'N' OR a.close_status <> 'C') AND a.entry_status <> 'X' AND d.pymnt_type <> 'W' AND d.pymnt_selct_status = 'N' AND d.due_dt IS NOT NULL AND ((a.VOUCHER_STYLE='PPAY' AND d.PREPAID_STATUS='P' ) OR a.VOUCHER_STYLE<>'PPAY') AND NOT EXISTS ( SELECT 'X' FROM PS_EM_PROPOSAL_VW F WHERE a.business_unit = F.EM_BUSINESS_UNIT AND a.voucher_id = F.VOUCHER_ID AND F.PROPOSAL_STATUS <> 'D')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EM_BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL From Business Unit
2 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
3 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
4 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
5 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number

Prompt Table: EM_INVOI_USR_VW