VCHR_MTCH_SRC

(SQL View)
 Index Back

Match Exception Vouchers


select distinct a.business_unit, a.voucher_id, a.invoice_id, c.business_unit_po, c.po_id, d.buyer_id, a.gross_amt, a.invoice_dt, a.vendor_setid, b.vendor_name_short, a.vendor_id, b.name1, a.txn_currency_cd from PS_VOUCHER_line c, PS_VOUCHER a, ps_po_hdr_fs d, ps_vendor b where a.business_unit = c.business_unit and a.voucher_id = c.voucher_id and c.business_unit_po = d.business_unit and c.po_id = d.po_id and a.vendor_setid = b.setid and a.vendor_id = b.vendor_id and a.match_status_vchr = 'E'

# 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 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
4 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
5 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
6 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
7 GROSS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Invoice Amount
8 INVOICE_DT Date(10) DATE Invoice Date
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

Prompt Table: VENDOR_PRIM_VW

12 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
13 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency