EM_PYMNTNOTE_LN

(SQL View)
 Index Back

EBPP Payment File Creation Vw

View of file payments that have been made. Used to create email notification via a component interface. RSR MarketPay

SELECT DISTINCT a.pay_cycle , a.pay_cycle_seq_num , b.business_unit , b.voucher_id , b.pymnt_cnt , LN.LANGUAGE_CD , LN.NAME1 FROM ps_pycycl_stat a , ps_pymnt_vchr_xref b , ps_payment_tbl c , PS_VOUCHER d , PS_VENDOR E , PS_VENDOR_LANG LN WHERE a.pay_cycle=b.pay_cycle AND a.pay_cycle_seq_num=b.pay_cycle_seq_num AND a.pay_cycle=c.pay_cycle AND a.pay_cycle_seq_num=c.pay_cycle_seq_num AND b.business_unit=d.business_unit AND b.voucher_id=d.voucher_id AND a.pay_run_ap_status IN ('C','X') AND b.pymnt_selct_status<>'X' AND C.REMIT_VENDOR=B.REMIT_VENDOR AND C.REMIT_SETID=B.REMIT_SETID AND C.PYMNT_ID = B.PYMNT_ID AND C.REMIT_VENDOR=E.VENDOR_ID AND C.REMIT_SETID=E.SETID AND E.SETID=LN.SETID AND E.VENDOR_ID=LN.VENDOR_ID

  • Related Language Record for AP_PYMNTNOTE_VW EM_PYMNTNOTE_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PAY_CYCLE Character(6) VARCHAR2(6) NOT NULL Pay Cycle
    2 PAY_CYCLE_SEQ_NUM Number(6,0) INTEGER NOT NULL Pay Cycle Sequence Number
    3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    4 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
    5 PYMNT_CNT Number(5,0) INTEGER NOT NULL Payments
    6 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    7 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1