BUSINESS_UNITTREASURY_PORTFOLIOTREAS_HEADER_ID01=Under Negotiation
02=Sample
03=Open
04=Matured
05=Deactivated
06=Rejected
07=Sold / Bought back
08=Forecasted
09=Partially Sold/Bought Back
TRX_DEAL_FAV_VW(SQL View) |
Index Back |
|---|---|
View over trx_headerView of trx_header_tr deals, grouped by portfolio. |
| SELECT business_unit , treasury_portfolio , treas_header_id , descr150_mixed , deal_status , instrument_type FROM PS_TRX_HEADER_TR |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | TREASURY_PORTFOLIO |
Character(15) | VARCHAR2(15) NOT NULL | A unique key identifier for a position portfolio that may be associated with a given deal transaction. |
| 3 | TREAS_HEADER_ID |
Character(12) | VARCHAR2(12) NOT NULL | The unique key identifier for a given deal transaction. |
| 4 | DESCR150_MIXED | Character(150) | VARCHAR2(150) NOT NULL | Description |
| 5 | DEAL_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Represents the specific state or point in the life cycle of a deal transaction.
01=Under Negotiation 02=Sample 03=Open 04=Matured 05=Deactivated 06=Rejected 07=Sold / Bought back 08=Forecasted 09=Partially Sold/Bought Back |
| 6 | INSTRUMENT_TYPE | Character(10) | VARCHAR2(10) NOT NULL | Instrument type |