BANKACCT_VW1_LG

(SQL View)
Index Back

External Accounts: Acct. View


SELECT A.SETID ,A.BANK_CD ,A.BRANCH_NAME ,A.BANK_ACCT_KEY ,B.LANGUAGE_CD ,B.DESCR FROM PS_BANKACCT_VW1 A ,PS_BANK_ACCT_LNG B WHERE B.SETID=A.SETID AND B.BANK_CD=A.BANK_CD AND B.BANK_ACCT_KEY=A.BANK_ACCT_KEY

  • Related Language Record for BANKACCT_VW1
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code
    3 BRANCH_NAME Character(10) VARCHAR2(10) NOT NULL Branch Name
    4 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
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description