EM_VCHR_MTCH_VW

(SQL View)
Index Back

Match Expections View

View of Vouchers with Match Exceptions used for Workflow Notifications in MarketPay. RSR MarketPay Development

SELECT DISTINCT a.business_unit , a.voucher_id , b.descr , d.invoice_id , d.vendor_setid , d.vendor_id , d.vndr_loc , d.entered_dt , d.invoice_dt FROM ps_AP_MTCH_EXCPTN a , ps_bus_unit_tbl_fs b , PS_VOUCHER d WHERE a.business_unit = d.business_unit AND a.voucher_id = d.voucher_id AND a.business_unit = b.business_unit AND d.match_status_vchr IN ('E', 'O', 'D','C')

# 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description
4 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
5 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
6 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
7 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
8 ENTERED_DT Date(10) DATE Entered on
9 INVOICE_DT Date(10) DATE Invoice Date