ACT_NUM_EVNT_VW

(SQL View)
Index Back

Account View for Event Log


SELECT DISTINCT B.BNK_ID_NBR ,A.BANK_ACCOUNT_NUM ,A.DESCR FROM PS_BANK_ACCT_DEFN A , PS_BANK_CD_TBL B WHERE A.SETID=B.SETID AND A.BANK_CD=B.BANK_CD

# 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description