CNTRCT_EVP_VWLN

(SQL View)
 Index Back

Contract Event Vchr Pay Detail


SELECT a.business_unit , a.voucher_id , a.bank_cd , a.bank_acct_key , a.pymnt_id , e.language_cd , b.pymnt_id_ref , a.currency_pymnt , b.remit_setid , b.remit_vendor , c.vendor_name_short , e.name1 , b.bank_setid , d.txn_currency_cd FROM ps_pymnt_vchr_xref a , ps_payment_tbl b , ps_vendor c , PS_VOUCHER d , ps_vendor_lang e WHERE a.bank_setid = b.bank_setid AND a.bank_cd = b.bank_cd AND c.setid = e.setid AND c.vendor_id = e.vendor_id AND c.vendor_id = d.vendor_id AND e.vendor_id = d.vendor_id AND a.bank_acct_key = b.bank_acct_key AND a.pymnt_id = b.pymnt_id AND b.remit_setid = c.setid AND b.remit_vendor = c.vendor_id AND a.business_unit = d.business_unit AND a.voucher_id = d.voucher_id

  • Related Language Record for CNTRCT_EVPAY_VW

    • # 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 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code
    4 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
    5 PYMNT_ID Character(10) VARCHAR2(10) NOT NULL Payment Number
    6 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    7 PYMNT_ID_REF Character(20) VARCHAR2(20) NOT NULL Payment Reference
    8 CURRENCY_PYMNT Character(3) VARCHAR2(3) NOT NULL Payment Currency
    9 REMIT_SETID Character(5) VARCHAR2(5) NOT NULL Remit SetID
    10 REMIT_VENDOR Character(10) VARCHAR2(10) NOT NULL Remit Vendor
    11 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name
    12 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    13 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.
    14 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency