AR_WC_BKEY_F_VW

(SQL View)
 Index Back

Bank Account Key View


SELECT DISTINCT B.BANK_ACCT_KEY , 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_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
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description