BANK_ID_VW2

(SQL View)
 Index Back

Bank ID View for Inquiry

Bank ID View for Inquiry for Manual Recon

SELECT b.bnk_id_nbr , b.descr , b.descrshort , b.descr_ac FROM PS_BANK_CD_TBL b WHERE NOT EXISTS ( SELECT bnk_id_nbr FROM ps_bnk_rcn_schedid d WHERE b.setid = d.bank_setid AND b.bank_cd = d.bank_cd AND b.bnk_id_nbr = d.bnk_id_nbr) AND B.BANK_TYPE ='E'

  • Related Language Record: BANK_ID_VW2_LNG

    • # 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    4 DESCR_AC Character(30) VARCHAR2(30) NOT NULL Alternate Description