DR_REMIT_BNK_VW

(SQL View)
 Index Back

Draft Remittance Bank View


SELECT DISTINCT A.REMIT_BU , B.BNK_ID_NBR , B.DESCR FROM PS_DR_REMIT_CNTL A , PS_BANK_CD_TBL B WHERE A.BANK_SETID=B.SETID AND A.BANK_CD=B.BANK_CD

  • Related Language Record: DR_RMT_BNK_VWLG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 REMIT_BU Character(5) VARCHAR2(5) NOT NULL Remittance Business Unit
    2 BNK_ID_NBR Character(20) VARCHAR2(20) NOT NULL A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description