SETIDCOUNTERPARTYBANK_CONTACT_VW(SQL View) |
Index Back |
|---|---|
Bank Contact View |
| SELECT A.SETID , B.COUNTERPARTY , B.BANK_ACCOUNT_NUM , A.CONTACT_ID FROM PS_BANK_ACCT_CNTCT A , PS_BANK_ACCT_CPTY B WHERE A.SETID = B.SETID AND A.BANK_CD = B.BANK_CD AND A.BANK_CD_CPTY = B.BANK_CD_CPTY AND A.BANK_ACCT_KEY = B.BANK_ACCT_KEY |
| # | 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 | BANK_ACCOUNT_NUM | Character(35) | VARCHAR2(35) NOT NULL | The literal unique identifier associated with a given bank/counterparty account. |
| 4 | CONTACT_ID | Character(15) | VARCHAR2(15) NOT NULL | Contact Identifier for Treasury Contacts |