TR_WR_AC_F_V_L

(SQL View)
 Index Back

Ext Bank Acct View for Inquiry

View over External Bank Accounts with a Payment Method in ('ACH','DD','EFT','WIR')

SELECT DISTINCT A.SETID ,A.BNK_ID_NBR ,B.BANK_ACCOUNT_NUM ,R.LANGUAGE_CD ,R.DESCR FROM PS_BANK_CD_TBL A ,PS_BANK_ACCT_DEFN B ,PS_BANK_ACCT_MTHD C ,PS_BANK_ACCT_LNG R WHERE B.SETID=A.SETID AND B.BANK_CD=A.BANK_CD AND C.SETID=B.SETID AND C.BANK_CD=B.BANK_CD AND C.BANK_CD_CPTY=B.BANK_CD_CPTY AND C.BANK_ACCT_KEY=B.BANK_ACCT_KEY AND C.PYMNT_METHOD IN ('ACH','DD','EFT','WIR') AND A.BANK_TYPE='E' AND B.ACCT_STATUS='A' AND R.SETID = B.SETID AND R.BANK_CD = B.BANK_CD AND R.BANK_CD_CPTY = B.BANK_CD_CPTY AND R.BANK_ACCT_KEY = B.BANK_ACCT_KEY

  • Related Language Record for TR_WR_ACCT_F_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 FROM_BNK_ID_NBR Character(20) VARCHAR2(20) NOT NULL From Bank ID Number
    3 FROM_BNK_ACCT_NBR Character(35) VARCHAR2(35) NOT NULL From Bank Account #
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description