BANK_ACCTNUM_L1

(SQL View)
 Index Back

Bank Acct Num for Inquiry


SELECT DISTINCT A.BNK_ID_NBR , B.BANK_ACCOUNT_NUM , D.LANGUAGE_CD , D.DESCRSHORT , D.DESCR FROM PS_BANK_CD_TBL A ,PS_BANK_ACCT_CPTY B ,PS_BANK_ACCT_DEFN C ,PS_BANK_CD_LNG D WHERE A.SETID = B.SETID AND A.BANK_CD = B.COUNTERPARTY AND B.SETID = C.SETID AND B.BANK_CD = C.BANK_CD AND B.BANK_CD_CPTY = C.BANK_CD_CPTY AND B.BANK_ACCT_KEY = C.BANK_ACCT_KEY AND A.SETID = D.SETID AND A.BANK_CD = D.BANK_CD

  • Related Language Record for BANK_ACCTNUM_V1 BANK_ACCTNUM_V2 BANK_ACCTNUM_V3 BANK_ACCTNUM_V4 BANK_ACCTNUM_V5 BANK_ACCTNUM_VW BNK_ACCTNUM_DV4 BNK_ACCTNUM_DVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BNK_ID_NBR Character(20) VARCHAR2(20) NOT NULL A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
    2 BANK_ACCOUNT_NUM Character(35) VARCHAR2(35) NOT NULL The literal unique identifier associated with a given bank/counterparty account.
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description