SETIDCOUNTERPARTYPrompt Table: BANK_TR_CPTY_VW
DEALER_OPRIDTR_CNTCT_CPTY_V(SQL View) |
Index Back |
|---|---|
Bank/Counterparty Contact |
| SELECT setid , bank_cd , contact_id , name FROM PS_TR_CONTACT_TBL |
| # | 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.
Prompt Table: BANK_TR_CPTY_VW |
| 3 | DEALER_OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A system generated value that reflects the operator that originally created and saved a given deal tran |
| 4 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |