EM_PYMT_EXP_VW3

(SQL View)
 Index Back

MP - Express Payment View 3

MP - Express Payment View 3

SELECT DISTINCT a.remit_setid , a.remit_vendor , a.vndr_loc , a.business_unit , a.voucher_id , a.pymnt_cnt , c.invoice_id , c.invoice_dt , a.pymnt_gross_amt , c.txn_currency_cd , c.grp_ap_id , a.bank_setid , a.bank_cd , a.bank_acct_key FROM ps_pymnt_vchr_xref a , PS_VOUCHER c , ps_em_ve_buagrt_vw sec WHERE a.business_unit=c.business_unit AND a.voucher_id=c.voucher_id AND a.pymnt_method IN ('EFT', 'ACH') AND a.pymnt_hold='N' AND a.pymnt_hold_wthd='N' AND a.pymnt_selct_status='N' AND ( a.NET_SELCT_STATUS IN ('N', ' ') OR a.NET_TXN_STATUS IN ('B', 'N') ) AND c.entry_status = 'P' AND c.appr_status = 'A' AND c.process_man_close = 'N' AND c.match_status_vchr IN ('M', 'N') AND c.BUDGET_HDR_STATUS = 'V' AND c.BUDGET_MISC_STATUS = 'V' AND sec.setid = a.remit_setid AND sec.vendor_id = a.remit_vendor

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 REMIT_SETID Character(5) VARCHAR2(5) NOT NULL Remit SetID
2 REMIT_VENDOR Character(10) VARCHAR2(10) NOT NULL Remit Vendor
3 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
5 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
6 PYMNT_CNT Number(5,0) INTEGER NOT NULL Payments
7 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
8 INVOICE_DT Date(10) DATE Invoice Date
9 PYMNT_GROSS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Payment Amount
10 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
11 GRP_AP_ID Character(10) VARCHAR2(10) NOT NULL Control Group ID
12 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.
13 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code
14 BANK_ACCT_KEY Character(4) VARCHAR2(4) NOT NULL A user defined unique identifier that facilitates the identification of a given account with a given bank