BANK_MTHD_VW2LG

(SQL View)
 Index Back

Pay Methods by Bank


SELECT A.SETID , A.BANK_CD , A.BANK_ACCT_KEY , C.PYMNT_METHOD , D.LANGUAGE_CD , D.XLATLONGNAME FROM PS_BANK_ACCT_DEFN A , PS_BANK_ACCT_MTHD C , PSXLATITEMLANG D WHERE A.BANK_ACCT_QUAL = 'C' AND A.AP = 'Y' AND A.SETID = C.SETID AND A.BANK_CD = C.BANK_CD AND A.BANK_ACCT_KEY = C.BANK_ACCT_KEY AND C.PYMNT_METHOD IN ('CHK' ,'EFT' ,'ACH', 'GE', 'WIR') AND D.FIELDNAME = 'PYMNT_METHOD' AND D.FIELDVALUE = C.PYMNT_METHOD AND D.EFFDT = ( SELECT MAX(B.EFFDT) FROM PSXLATITEMLANG B WHERE D.FIELDVALUE = B.FIELDVALUE AND D.FIELDNAME = B.FIELDNAME AND D.LANGUAGE_CD = B.LANGUAGE_CD AND B.EFFDT <= %CurrentDateIn)

  • Related Language Record for BANK_MTHD_VW2

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BANK_SETID_NEW Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.
    2 BANK_CD_NEW Character(5) VARCHAR2(5) NOT NULL A unique key identifier that represents a new bank or counterparty to the system.
    3 BANK_ACCT_KEY_NEW Character(4) VARCHAR2(4) NOT NULL A user defined unique identifier that facilitates the identification of a new account in the system w
    4 PYMNT_METHOD_NEW Character(3) VARCHAR2(3) NOT NULL Payment Method
    CHK=System Generated Check
    EFT=Electronic Funds Transfer
    WIR=Wire Report
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description