EM_VCHRLOG_SRCH

(SQL View)
 Index Back

Match Exception Log Search

Match Exception Log Search

SELECT DISTINCT a.business_unit , f.oprid , a.voucher_id , d.invoice_id , d.txn_currency_cd , d.gross_amt , g.po_id , g.buyer_id , d.vendor_setid , e.vendor_name_short , d.vendor_id , e.name1 , d.vndr_loc ,d.invoice_dt FROM ps_ap_mtch_excptn a , PS_VOUCHER d , ps_vendor e , ps_sec_bu_opr f , ps_em_es_vchr_vw vchr , ps_vchr_mtch_detls g WHERE a.business_unit = d.business_unit AND a.business_unit = f.business_unit AND a.voucher_id = d.voucher_id AND d.vendor_setid = e.setid AND d.vendor_id = e.vendor_id AND g.process_instance = a.process_instance AND g.business_unit = a.business_unit AND g.voucher_id = a.voucher_id AND g.voucher_line_num = a.voucher_line_num AND d.match_status_vchr = 'E' AND d.entry_status <> 'R' AND D.CLOSE_STATUS <> 'C' AND d.business_unit = vchr.business_unit AND d.voucher_id = vchr.voucher_id

  • Related Language Record: EM_VCHRLOG_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    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 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
    5 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
    6 GROSS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Invoice Amount
    7 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
    8 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
    9 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID

    Default Value: VENDOR.SETID

    10 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name
    11 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

    Default Value: VENDOR_SHRT_VW.VENDOR_ID

    12 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    13 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location

    Prompt Table: EM_VNDR_LOC_VW

    14 INVOICE_DT Date(10) DATE Invoice Date