BANKACCT_VW1

(SQL View)
 Index Back

External Accounts: Acct. View

External Accounts: Acct. View

SELECT A.SETID ,A.BANK_CD ,B.BRANCH_NAME ,C.BANK_ACCT_KEY ,A.BNK_ID_NBR ,B.BRANCH_ID ,C.BANK_ACCOUNT_NUM ,C.DESCR ,C.CURRENCY_CD ,C.BUSINESS_UNIT_GL ,C.ACCT_STATUS FROM PS_BANK_CD_TBL A ,PS_BANK_BRANCH_TBL B ,PS_BANK_ACCT_DEFN C WHERE B.SETID=A.SETID AND B.BANK_CD=A.BANK_CD AND C.SETID=B.SETID AND C.BANK_CD=A.BANK_CD AND C.BRANCH_NAME=B.BRANCH_NAME AND A.BANK_TYPE='E' AND A.BANKING_SW='Y'

  • Related Language Record: BANKACCT_VW1_LG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code

    Prompt Table: BANKACCT_VW2

    3 BRANCH_NAME Character(10) VARCHAR2(10) NOT NULL Branch Name

    Prompt Table: BANKACCT_VW3

    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 BNK_ID_NBR Character(20) VARCHAR2(20) NOT NULL A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
    6 BRANCH_ID Character(10) VARCHAR2(10) NOT NULL The local branch office identifier associated with a given bank/counterparty.
    7 BANK_ACCOUNT_NUM Character(35) VARCHAR2(35) NOT NULL The literal unique identifier associated with a given bank/counterparty account.
    8 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    9 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    10 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
    11 ACCT_STATUS Character(1) VARCHAR2(1) NOT NULL Account Status - Active/Inactive
    A=Active
    I=Inactive