BANK_ACCT_LG

(SQL View)
 Index Back

Bank Accounts by Bank Setid


SELECT a.setid , a.bank_cd , a.bank_acct_key , b.language_cd , b.descrshort , b.descr FROM PS_BANK_ACCT_DEFN a ,ps_bank_acct_lng b WHERE a.setid = b.setid AND a.bank_cd = b.bank_cd AND a.bank_cd_cpty = b.bank_cd_cpty AND a.bank_acct_key = b.bank_acct_key

  • Related Language Record for BANK_ACCTKEY_V1 BANK_ACCT_VW BANK_ACCT_VW10 BANK_ACCT_VW3 BANK_ACTINFO_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.
    2 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code

    Prompt Table: BANK_CD_TBL

    3 BANK_ACCT_KEY Character(4) VARCHAR2(4) NOT NULL A user defined unique identifier that facilitates the identification of a given account with a given bank
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description