BANK_ACT_INT_VW

(SQL View)
 Index Back

Internal Account View

Used for selecting both sides of an internal account

SELECT A.SETID, A.BANK_ACCT_KEY, A.COUNTERPARTY, E.DESCR, A.BUSINESS_UNIT_GL, A.BANK_ACCOUNT_NUM, C.TREASURY_SW, B.COUNTERPARTY, B.BUSINESS_UNIT_GL, B.BANK_ACCOUNT_NUM, D.TREASURY_SW FROM PS_BANK_ACCT_CPTY A, PS_BANK_ACCT_CPTY B, PS_BANK_CD_TBL C, PS_BANK_CD_TBL D, PS_BANK_ACCT_VW7 E 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 AND A.COUNTERPARTY <> B.COUNTERPARTY AND A.COUNTERPARTY = C.BANK_CD AND B.COUNTERPARTY = D.BANK_CD AND A.SETID = E.SETID AND A.COUNTERPARTY = E.BANK_CD AND A.BANK_ACCT_KEY = E.BANK_ACCT_KEY

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 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
3 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code
4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
5 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
6 BANK_ACCOUNT_NUM Character(35) VARCHAR2(35) NOT NULL The literal unique identifier associated with a given bank/counterparty account.
7 TREASURY_SW Character(1) VARCHAR2(1) NOT NULL Allows the user to indicate whether a given bank/counterparty also serves as the internal corporate t
8 BANK_CD1 Character(5) VARCHAR2(5) NOT NULL A unique key identifier that represents an internal bank or counterparty.
9 BUSINESS_UNIT_GL1 Character(5) VARCHAR2(5) NOT NULL The general ledger business unit associated with an internal counterparty.
10 BANK_ACCOUNT_NUM1 Character(35) VARCHAR2(35) NOT NULL The literal unique identifier associated with a given internal partner bank/counterparty acco
11 TREASURY_SW1 Character(1) VARCHAR2(1) NOT NULL Allows the user to indicate whether a given bank/counterparty also serves as the internal corpo