TRX_AF_HDR_VW(SQL View) |
Index Back |
|---|---|
deal approval trans. record.Treasury transaction record for deal approval using AF. |
| SELECT A.BUSINESS_UNIT , A.TREAS_HEADER_ID , A.INSTRUMENT_TYPE ,A.TRANSACTION_DT , A.INSTRMNT_TEMPLATE , A.COUNTERPARTY ,A.PREAPPV_SW ,A.DEALER_OPRID ,A.TREASURY_PORTFOLIO ,B.INSTRMNT_BASE_TYPE ,B.TRANSACT_CURRENCY ,B.TRANSACT_PROCEEDS ,B.TRANSACTION_AMT FROM PS_TRX_HEADER_TR A , PS_TRX_DETAIL_TR B WHERE A.BUSINESS_UNIT= B.BUSINESS_UNIT AND A.TREAS_HEADER_ID=B.TREAS_HEADER_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT |
| 2 | TREAS_HEADER_ID |
Character(12) | VARCHAR2(12) NOT NULL |
The unique key identifier for a given deal transaction.
Default Value: NEXT |
| 3 | INSTRUMENT_TYPE |
Character(10) | VARCHAR2(10) NOT NULL | Instrument type |
| 4 | TRANSACTION_DT | Date(10) | DATE NOT NULL | Transaction date (often used as trade date) |
| 5 | INSTRMNT_TEMPLATE | Character(10) | VARCHAR2(10) NOT NULL | A unique key identifier associated with an instrument that describes a separate template version of a pre |
| 6 | COUNTERPARTY | Character(5) | VARCHAR2(5) NOT NULL | Represents a treasury dealing counterpart. |
| 7 | PREAPPV_SW | Character(1) | VARCHAR2(1) NOT NULL | Allows the user to indicate that a deal transaction has been submitted for review via workflow process |
| 8 | 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 |
| 9 | 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. |
| 10 | INSTRMNT_BASE_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Instrument base type used as a building block for Treasury deals
01=Interest Rate Physical 02=Interest Rate Swap 03=FX Deal Physical 04=Option 05=Option - Binary Payoff 06=Futures Contract 07=Commodity 08=Generic Instrument 09=Equity |
| 11 | TRANSACT_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | "The nominal |
| 12 | TRANSACT_PROCEEDS | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | The amount of funds that changes hands when a deal is complete. |
| 13 | TRANSACTION_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | The nominal or actual deal transaction amount. |