BUSINESS_UNITTREAS_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_ID_VW(SQL View) |
Index Back |
|---|---|
View over trx_headerView of trx_header_tr deals, grouped by portfolio. |
| SELECT H.business_unit , H.treas_header_id , H.instrument_type , H.deal_status , H.descr150_mixed FROM PS_TRX_HEADER_TR H WHERE H.deal_status IN ('03', '07', '09') AND H.treasury_portfolio = ' ' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | TREAS_HEADER_ID |
Character(12) | VARCHAR2(12) NOT NULL | The unique key identifier for a given deal transaction. |
| 3 | INSTRUMENT_TYPE | Character(10) | VARCHAR2(10) NOT NULL | Instrument type |
| 4 | 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 |
| 5 | DESCR150_MIXED | Character(150) | VARCHAR2(150) NOT NULL | Description |