EM_BUBKACCT_V2

(SQL View)
Index Back

Bank Accounts by Tableset Cntr

Returns list of bank accounts available to user based on Tableset Control. Only used in the BD Model.

SELECT DISTINCT C.SETID , C.BANK_CD , C.BANK_ACCT_KEY , C.BANK_ACCOUNT_NUM , C.DESCR FROM PS_SET_CNTRL_REC B , PS_BANK_ACCT_TBL C WHERE B.RECNAME = 'BANK_CD_TBL' AND C.SETID = B.SETID AND C.BANK_ACCT_KEY NOT IN ('DRAF')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.

Prompt Table: SETID_TBL

2 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code
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 BANK_ACCOUNT_NUM Character(35) VARCHAR2(35) NOT NULL The literal unique identifier associated with a given bank/counterparty account.
5 DESCR Character(30) VARCHAR2(30) NOT NULL Description