BANK_ACCT_NM_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_V2
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ACCOUNT_SETID Character(5) VARCHAR2(5) NOT NULL Account SETID
    2 BANK_CD2 Character(5) VARCHAR2(5) NOT NULL A unique key identifier that represents a bank or counterparty.

    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