BNK_CDSTL_LNG_V

(SQL View)
 Index Back

Settlement Banks by Currency


SELECT A.SETID, A.CURRENCY_CD, B.BANK_CD, C.LANGUAGE_CD, C.DESCR FROM PS_BANK_ACCT_DEFN A, PS_BANK_CD_TBL B, PS_BANK_CD_LNG C WHERE A.SETID = B.SETID AND A.SETID=C.SETID AND A.BANK_CD = B.BANK_CD AND A.BANK_CD=C.BANK_CD AND B.BANK_TYPE = 'E'

  • Related Language Record for BANK_CD_STL_VW

  • Parent record: BANK_CD_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    3 STL_THRU_BANK Character(5) VARCHAR2(5) NOT NULL The intermediary transit bank/counterparty utilized for settlement purposes.
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description