BANK_ACT_TR_LNG

(SQL View)
 Index Back

Bank Accounts with Ledger='H'

This view selects active Bank Accounts fothat have a chartfield defined for Ledger Type = 'H' (Treasury Cash). Used for the "to bank account" on the destination page of bank transfers on the transfer templates

SELECT B.SETID ,B.BANK_CD ,B.BANK_ACCT_KEY ,C.LANGUAGE_CD ,C.DESCR FROM PS_BANK_ACCT_CHRT A ,PS_BANK_ACCT_DEFN B ,PS_BANK_ACCT_LNG C WHERE A.BANK_ACCT_LED_TYPE='H' AND B.ACCT_STATUS='A' AND B.SETID=A.SETID AND B.BANK_CD=A.BANK_CD AND B.BANK_CD_CPTY=A.BANK_CD_CPTY AND B.BANK_ACCT_KEY=A.BANK_ACCT_KEY 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

  • Related Language Record for BANK_ACT_TR_VW2

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 TO_BANK_CD Character(5) VARCHAR2(5) NOT NULL To Bank Code for Bank Transfers on Destination Page of Transfer Template
    3 TO_BANK_ACCT_KEY Character(4) VARCHAR2(4) NOT NULL To Bank Account on the Destination Page of Transfer Templates
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description