RMT_BANK_VW_LG

(SQL View)
 Index Back

Remit Bank Set Vw Lg


SELECT a.setid , a.vendor_id , a.vndr_loc , c.language_cd , ' ' , c.descr FROM PS_VNDR_BANK_ACCT a , ps_setid_tbl b , ps_setid_lang c WHERE a.setid = b.setid AND effdt = ( SELECT MAX(a1.effdt) FROM PS_VNDR_BANK_ACCT a1 WHERE a.setid = a1.setid AND a.vendor_id = a1.vendor_id AND a.vndr_loc = a1.vndr_loc AND a1.effdt <= %CurrentDateIn) AND b.setid = c.setid

  • Related Language Record for RMT_BANK_SET_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description