BNK_TR_AS_LNG_V

(SQL View)
 Index Back

Treasury Bank Accts (Settle)

Treasury External Bank Accounts useable for Settlements Used as Edit Table on BANK_SETTLEMENT.STL_THRU_ACCT

select a.setid ,a.bank_cd ,b.bank_acct_key ,c.language_cd ,c.descr from PS_BANK_CD_TBL a, ps_bank_acct_tbl b, ps_bank_acct_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_acct_key = c.bank_acct_key and a.bank_type in ('E') and b.TR = 'Y'

  • 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 STL_THRU_BANK Character(5) VARCHAR2(5) NOT NULL The intermediary transit bank/counterparty utilized for settlement purposes.
    3 STL_THRU_ACCT Character(4) VARCHAR2(4) NOT NULL The intermediary transit bank account utilized for settlement purposes.
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description