CPTY_DEALERPrompt Table: TRX_HEADER_TR
TRX_DEALER_VW(SQL View) |
Index Back |
|---|---|
List of DealersView stores the list of dealers for all the deals entered. |
| SELECT DISTINCT cpty_dealer FROM PS_TRX_HEADER_TR WHERE cpty_dealer <> ' ' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CPTY_DEALER |
Character(10) | VARCHAR2(10) NOT NULL |
The assigned external dealer or trader associated with a given dealing counterparty.
Prompt Table: TRX_HEADER_TR |