TR_WR_PM_F_V_L

(SQL View)
 Index Back

Ext Bank Acct View for Inquiry

View over External Bank Accounts

SELECT A.SETID , A.BNK_ID_NBR , B.BANK_ACCOUNT_NUM , C.PYMNT_METHOD ,E.LANGUAGE_CD ,E.XLATLONGNAME FROM PS_BANK_CD_TBL A , PS_BANK_ACCT_DEFN B , PS_BANK_ACCT_MTHD C , PSXLATITEM D , PSXLATITEMLANG E WHERE A.BANK_TYPE='E' AND 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 D.FIELDNAME='PYMNT_METHOD' AND D.FIELDVALUE=C.PYMNT_METHOD AND D.EFF_STATUS='A' AND D.EFFDT=( SELECT MAX(EFFDT) FROM PSXLATITEM F WHERE F.FIELDNAME=D.FIELDNAME AND F.FIELDVALUE=D.FIELDVALUE AND F.EFFDT<=%CurrentDateIn) AND B.ACCT_STATUS = 'A' AND D.FIELDNAME = E.FIELDNAME AND D.FIELDVALUE = E.FIELDVALUE AND D.EFFDT = E.EFFDT

  • Related Language Record for TR_WR_PMTH_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 PYMNT_METHOD Character(3) VARCHAR2(3) NOT NULL Payment Method
    ACH=Automated Clearing House
    BEF=Draft - Customer EFT
    BOO=Draft - Customer Initiated
    CHK=System Check
    D=Deposit
    DD=Direct Debit
    DFT=Draft - Supplier Initiated
    DRA=Draft
    EFT=Electronic Funds Transfer
    GE=Giro - EFT
    GM=Giro - Manual
    LC=Letter of Credit
    MAN=Manual Check
    TRW=Treasury Wire
    WIR=Wire Transfer
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description