SETIDCOUNTERPARTYPAY_CURRENCY_CDSETTLEMENT_IDLANGUAGE_CDBNK_STL_C_LNG_V(SQL View) |
Index Back |
|---|---|
Counterparty Settlements (Pay)Counterparty Settlement Instructions used for Payments |
| 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 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | COUNTERPARTY |
Character(5) | VARCHAR2(5) NOT NULL | Represents a treasury dealing counterpart. |
| 3 | PAY_CURRENCY_CD |
Character(3) | VARCHAR2(3) NOT NULL | The holding currency for a bank account on the disbursing side of a settlement 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 |