DR_RMT_BNK_VWLG

(SQL View)
 Index Back

Draft Remittance Bank Vw RLR


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

  • Related Language Record for DR_REMIT_BNK_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description