BANK_MTHD_VW2

(SQL View)
 Index Back

Pay Methods by Bank


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

  • Related Language Record: BANK_MTHD_VW2LG

    • # 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description