BUSINESS_UNITPrompt Table: SP_BU_GL_NONVW
TREAS_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_UNDO_VW(SQL View) |
Index Back |
|---|---|
View for Component InterfaceView for Component Interface |
| SELECT BUSINESS_UNIT , TREAS_HEADER_ID , DEAL_STATUS , INSTRUMENT_TYPE , TRANSACTION_DT 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
Prompt Table: SP_BU_GL_NONVW |
| 2 | TREAS_HEADER_ID |
Character(12) | VARCHAR2(12) NOT NULL | The unique key identifier for a given deal transaction. |
| 3 | 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 |
| 4 | INSTRUMENT_TYPE | Character(10) | VARCHAR2(10) NOT NULL | Instrument type |
| 5 | TRANSACTION_DT | Date(10) | DATE | Transaction date (often used as trade date) |