STL_ID_CPTY_VW1

(SQL View)
Index Back

Deal Settlement Netting


SELECT DISTINCT SOURCE_BUS_UNIT ,COUNTERPARTY_SETID ,COUNTERPARTY ,BUSINESS_DATE ,BANK_SETID ,BANK_CD ,BANK_ACCT_KEY ,CURRENCY_CD ,SETTLEMENT_ID FROM PS_STL_ID_CPTY_VW0 WHERE NET_STATUS='O'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 COUNTERPARTY_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given dealing counterparty.
3 COUNTERPARTY Character(5) VARCHAR2(5) NOT NULL Represents a treasury dealing counterpart.
4 SETTLEMENT_DT Date(10) DATE The settlement date for a given cash -based transaction, or the start date for a Treasury Deal.
5 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.
6 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code
7 BANK_ACCT_KEY Character(4) VARCHAR2(4) NOT NULL A user defined unique identifier that facilitates the identification of a given account with a given bank
8 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
9 SETTLEMENT_ID Character(5) VARCHAR2(5) NOT NULL A unique key identifier that represents the settlement instructions for a given bank/counterparty and acc