AR_WC_BKNM_F_VW

(SQL View)
 Index Back

Bank Account Number View


SELECT DISTINCT B.BANK_ACCOUNT_NUM , B.DESCR FROM PS_BANK_ACCT_DEFN B WHERE B.AR = 'Y' AND B.ACCT_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BANK_ACCOUNT_NUM Character(35) VARCHAR2(35) NOT NULL The literal unique identifier associated with a given bank/counterparty account.
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description