BNK_STL_CSLNG_V

(SQL View)
 Index Back

Sell/buyback Settlement Instr.

Counterparty Settlement Instructions used for Sell / Buyback, Related Language View

SELECT DISTINCT c.setid ,c.bank_cd ,c.currency_cd ,c.settlement_id ,x.language_cd ,x.descr FROM ps_bank_settlement c ,PS_STL_INSTRUCTION s ,ps_stl_instrct_lng x WHERE s.settlement_id = c.settlement_id AND s.currency_cd = c.currency_cd AND x.settlement_id = s.settlement_id AND x.currency_cd = s.currency_cd

  • Related Language Record for BANK_SETL_CS_VW

  • Parent record: BANK_CD_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SALE_CPTY_SETID Character(5) VARCHAR2(5) NOT NULL The subject settlement bank tableset ID for a buy/sellback transaction.
    2 SALE_COUNTERPARTY Character(5) VARCHAR2(5) NOT NULL The subject counterparty for a buy/sellback transaction.
    3 SALE_CURRENCY Character(3) VARCHAR2(3) NOT NULL The subject transaction currency for a buy/sellback transaction.
    4 SETTLEMENT_ID Character(5) VARCHAR2(5) NOT NULL A unique key identifier that represents the settlement instructions for a given bank/counterparty and acc
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description