TRD_DETAIL_TEO1(SQL Table) |
Index Back |
|---|---|
CCU TEO temp tableCCU temporary table for TRD_DETAIL_TR |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EO_PROCESS_INST | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | TRD_TRADE_ID | Character(12) | VARCHAR2(12) NOT NULL | Trade ID |
| 4 | TRANSACTION_LINE | Number(3,0) | SMALLINT NOT NULL | The separate and distinct base instrument type components of a given deal transaction. |
| 5 | 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 |
| 6 | OPT_EXERCISE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
The option exercise type.
A=American B=Bermudan E=European |
| 7 | OPT_EXERCISE_INTO | Character(1) | VARCHAR2(1) NOT NULL |
Allows the user to select the method in which a given option transaction will be exercised.
A=Delivery of Payoff C=Cash Difference |
| 8 | OPT_PURCHASE_WRITE | Character(1) | VARCHAR2(1) NOT NULL |
Describes whether the dealer is purchasing or writing a given option transaction.
P=Purchase W=Write |
| 9 | OPT_PUT_CALL | Character(1) | VARCHAR2(1) NOT NULL |
Describes whether a given option transaction reflects a short or long position.
C=Call P=Put |
| 10 | OPT_PUTCALL_DESCR | Character(40) | VARCHAR2(40) NOT NULL | Description for a put or call option transaction. |
| 11 | OPT_STRIKE_VARIES | Character(1) | VARCHAR2(1) NOT NULL |
Allows the user to designate that a given option transaction's strike rate can vary o
Y/N Table Edit |
| 12 | OPT_STRIKE_RATE | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | "The strike |
| 13 | OPT_INT_RATE_CAP | Character(1) | VARCHAR2(1) NOT NULL |
An indicator for the type of option. Cap/floor or an option on a swap (swaption).
B=Binary Cap/Floor N=Swaption Y=Cap / Floor |
| 14 | CONTINGENT_UPON | Character(2) | VARCHAR2(2) NOT NULL |
Instrument field for future. Indicates its line is currently 'underlying' another line. That is this security, say a T-Bond, will not be in position as a live instrument unless (06) the future (T-Bond Future) that it underlies is settled physically or (04) the option (Option on T-Bond) is exercised.
04=Option 06=Future |
| 15 | OPT_TRANSACT_LINE | Number(3,0) | SMALLINT NOT NULL | Points to the line in a deal which the current line underlies. That is, the line number pointed to by this field must be either exercised or settled physically for the line containing this field to become 'real'. |
| 16 | RATE_RESET_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Describes whether a given deal transaction is subject to a fixed or floating interest rate.
FL=Floating FX=Fixed |
| 17 | RATE_RESET_TYPE_2 | Character(2) | VARCHAR2(2) NOT NULL |
Describes whether a given deal transaction is subject to a fixed or floating interest rate for the sec
FL=Floating FX=Fixed |
| 18 | TRANSACTION_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | The nominal or actual deal transaction amount. |
| 19 | TRANSACTION_AMT_2 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | The nominal transaction amount for the second leg of a deal transacation. |
| 20 | TRANSACT_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL |
"The nominal
Prompt Table: CURRENCY_CD_TBL |
| 21 | TRANS_CURRENCY_2 | Character(3) | VARCHAR2(3) NOT NULL |
"The nominal
Prompt Table: CURRENCY_CD_TBL |
| 22 | PRICE_PERCENT_PAR | Number(14,8) | DECIMAL(13,8) NOT NULL | The percentage of par value of which a financial instrument is priced when booked into the system. |
| 23 | TRANSACTION_PRICE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | The preferred business price for a given deal transaction. |
| 24 | EXP_SETTLEMENT_DT | Date(10) | DATE | Expected Settlement Date |
| 25 | TRANSACTION_RATE | Number(16,8) | DECIMAL(15,8) NOT NULL | The applicable interest rate for a given deal transaction. |
| 26 | TRANSACTION_RATE_2 | Number(16,8) | DECIMAL(15,8) NOT NULL | The applicable interest rate for the second leg of a given deal transaction. |
| 27 | ASSET_LIABILITY | Character(1) | VARCHAR2(1) NOT NULL |
Whether the deal transaction leg represents an asset or a liability
A=Asset L=Liability |
| 28 | ASSET_LIABILITY_2 | Character(1) | VARCHAR2(1) NOT NULL |
Whether the deal transaction leg represents an asset or a liability for the second leg
A=Asset L=Liability |
| 29 | RT_RATE_INDEX | Character(10) | VARCHAR2(10) NOT NULL |
Market Rate Index
Default Value: BUS_UNIT_TBL_GL.TR_RVL_RATE_INDEX Prompt Table: RT_INDEX_TBL |
| 30 | RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
Default Value: BUS_UNIT_TBL_GL.TR_RVL_RT_TYPE |
| 31 | RT_RATE | Number(16,8) | DECIMAL(15,8) NOT NULL | Market Rate |
| 32 | RT_RATE_2 | Number(16,8) | DECIMAL(15,8) NOT NULL | Market Rate |
| 33 | FLOATING_MKT_CD | Character(10) | VARCHAR2(10) NOT NULL |
The code used as a key for obtaining market rates for interest rates and futures prices.
Prompt Table: TRX_RT_RESET_CD |
| 34 | FLOATING_MKT_CD_2 | Character(10) | VARCHAR2(10) NOT NULL |
A unique key identifier that describes a floating rate index basis associated with the second leg of a
Prompt Table: TRX_RT_RESET_CD |
| 35 | FLT_MARGIN_OP | Character(1) | VARCHAR2(1) NOT NULL |
1st floating margin operation, +/- or *//
*=Multiply By +=Add |
| 36 | FLT_MARGIN_OP_2 | Character(1) | VARCHAR2(1) NOT NULL |
1st floating margin operation, +/- or *//
*=Multiply By +=Add |
| 37 | FLOATING_MARGIN | Signed Number(13,8) | DECIMAL(11,8) NOT NULL | The supplemental interest rate |
| 38 | FLOATING_MARGIN_2 | Signed Number(13,8) | DECIMAL(11,8) NOT NULL | The supplemental interest rate |
| 39 | FLT2_MARGIN_OP | Character(1) | VARCHAR2(1) NOT NULL |
Floating margin operations, +/- or *//
*=Multiply By +=Add |
| 40 | FLT2_MARGIN_OP_2 | Character(1) | VARCHAR2(1) NOT NULL |
Floating margin operation, +/- or *//
*=Multiply By +=Add |
| 41 | FLOATING2_MARGIN | Signed Number(13,8) | DECIMAL(11,8) NOT NULL | The supplemental interest rate |
| 42 | FLOATING2_MARGIN_2 | Signed Number(13,8) | DECIMAL(11,8) NOT NULL | The supplemental interest rate |
| 43 | COMMODITY_CD | Character(10) | VARCHAR2(10) NOT NULL |
Commodity Code
Prompt Table: COMMOD_CODE |
| 44 | EXCHG_CD | Character(6) | VARCHAR2(6) NOT NULL |
Trading exchange code
Prompt Table: TRX_EXCHANGE_CD |
| 45 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage Prompt Table: UNITS_TBL |
| 46 | QUANTITY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Qty Interface |
| 47 | COMMODITY_RT_INDEX | Character(10) | VARCHAR2(10) NOT NULL |
The code used as a key for obtaining market rates for Commodity Prices
Prompt Table: RT_INDEX_COM_VW |
| 48 | EQUITY_ID | Character(10) | VARCHAR2(10) NOT NULL | Equity Identification Number - used to identify an equity in the system. the number is system generated and used for technical purposes only. |
| 49 | EQUITY_SYMBOL | Character(15) | VARCHAR2(15) NOT NULL | Ticker symbol to identify an equity on the exchange that it is traded on |
| 50 | SPOT_RATE_MULT | Number(16,8) | DECIMAL(15,8) NOT NULL |
An internal convention utilized for determing whether a currency exchange spot rate is stored ei
Default Value: 1 |
| 51 | SPOT_RATE_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL |
An internal convention utilized for determing whether a currency exchange spot rate is stored either
Default Value: 1 |
| 52 | FORWARD_RATE_MULT | Number(16,8) | DECIMAL(15,8) NOT NULL |
An internal convention utilized for determing whether a currency exchange forward rate is
Default Value: 1 |
| 53 | FORWARD_RATE_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL |
An internal convention utilized for determing whether a currency exchange forward rate is stor
Default Value: 1 |
| 54 | SPOT_RT_LEG1_MULT | Number(16,8) | DECIMAL(15,8) NOT NULL |
An internal convention utilized for determing whether a currency exchange spot rate is stored
Default Value: 1 |
| 55 | SPOT_RT_LEG1_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL |
An internal convention utilized for determing whether a currency exchange spot rate is stored eit
Default Value: 1 |
| 56 | FWD_RT_LEG1_MULT | Number(16,8) | DECIMAL(15,8) NOT NULL |
An internal convention utilized for determing whether a currency exchange forward rate is s
Default Value: 1 |
| 57 | FWD_RT_LEG1_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL |
An internal convention utilized for determing whether a currency exchange forward rate is store
Default Value: 1 |
| 58 | SPOT_RT_LEG2_MULT | Number(16,8) | DECIMAL(15,8) NOT NULL |
An internal convention utilized for determing whether a currency exchange spot rate is stored
Default Value: 1 |
| 59 | SPOT_RT_LEG2_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL |
An internal convention utilized for determing whether a currency exchange spot rate is stored eit
Default Value: 1 |
| 60 | FWD_RT_LEG2_MULT | Number(16,8) | DECIMAL(15,8) NOT NULL |
An internal convention utilized for determing whether a currency exchange forward rate is s
Default Value: 1 |
| 61 | FWD_RT_LEG2_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL |
An internal convention utilized for determing whether a currency exchange forward rate is store
Default Value: 1 |
| 62 | ANCHOR_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL |
The base currency of the business unit that generates a given deal transaction.
Default Value: BUS_UNIT_TBL_GL.BASE_CURRENCY Prompt Table: CURRENCY_CD_TBL |
| 63 | ANCHOR_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Principal amount of a given deal transaction denominated in the anchor currency. |
| 64 | NBR_OF_CONTRACTS | Signed Number(18,4) | DECIMAL(16,4) NOT NULL | This is the number of future contracts associated with a deal |
| 65 | TICK_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | The amount or value of each increment (tick) of a futures contract. |
| 66 | UNDERLYING_CCY | Character(3) | VARCHAR2(3) NOT NULL | Underlying Currency |
| 67 | SETTLEMENT_CCY | Character(3) | VARCHAR2(3) NOT NULL | Settlement Currency |
| 68 | TICK_MIN_INTERVAL | Signed Number(12,8) | DECIMAL(10,8) NOT NULL | The miinimum interval amount from one price or rate quote to the next. Fractions, like 1/32 should be entered in decimal format. |
| 69 | MARGIN_MIN_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Minimummargin amount for an exchange traded futures contract. |
| 70 | MARGIN_INITIAL_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Initial margin amount for an exchange traded futures contract. |
| 71 | DELIVERY_YEAR | Number(4,0) | SMALLINT NOT NULL | Delivery Year |
| 72 | MONTHCD | Character(2) | VARCHAR2(2) NOT NULL |
Month
01=01 - January 02=02 - February 03=03 - March 04=04 - April 05=05 - May 06=06 - June 07=07 - July 08=08 - August 09=09 - September 10=10 - October 11=11 - November 12=12 - December |
| 73 | LAST_TRADE_DT | Date(10) | DATE | The last date on which a deal can be traded. |
| 74 | FIRST_DELIVERY_DT | Date(10) | DATE | Physical date of position. |
| 75 | FIRST_TRADE_DT | Date(10) | DATE | The lfirst date on which a deal can be traded. |
| 76 | LAST_DELIVERY_DT | Date(10) | DATE | Last delivery date for a contract . |
| 77 | PAY_BANK_SETID | Character(5) | VARCHAR2(5) NOT NULL | The PeopleSoft tableset ID for a bank on the disbursing side of a settlement transaction. |
| 78 | PAY_BANK_CD_CUST | Character(5) | VARCHAR2(5) NOT NULL | Represents the owning counterparty of a given internal account slated to pay out a settlement. |
| 79 | PAY_BANK_CD | Character(5) | VARCHAR2(5) NOT NULL |
The bank for the disbursing side of a settlement transaction.
Prompt Table: BANK_TR_BANK_VW |
| 80 | PAY_BANK_ACCT_KEY | Character(4) | VARCHAR2(4) NOT NULL |
The bank account for the disbursing side of a settlement transaction.
Prompt Table: BANK_TR_ACTP_VW |
| 81 | PAY_BNK_ID_NBR | Character(20) | VARCHAR2(20) NOT NULL | The alphanumeric bank identifier associated with a bank on the disbursing side of a settlement trans |
| 82 | PAY_BANK_ACCT_NUM | Character(35) | VARCHAR2(35) NOT NULL | The bank account number for the disbursing side of a settlement transaction. |
| 83 | PAY_SETTLEMENT_ID | Character(5) | VARCHAR2(5) NOT NULL |
Represents the settlement instructions identifier associated with the submitter of a
Prompt Table: BANK_SETL_CP_VW |
| 84 | REC_BANK_SETID | Character(5) | VARCHAR2(5) NOT NULL | The PeopleSoft tableset ID for a bank on the receiving side of a settlement transaction. |
| 85 | REC_BANK_CD_CUST | Character(5) | VARCHAR2(5) NOT NULL | Represents the owning counterparty of a given internal account slated to receive a settlement. |
| 86 | REC_BANK_CD | Character(5) | VARCHAR2(5) NOT NULL |
The bank for the receiving side of a settlement transaction.
Prompt Table: BANK_TR_BANK_VW |
| 87 | REC_BANK_ACCT_KEY | Character(4) | VARCHAR2(4) NOT NULL |
The bank account for the receiving side of a settlement transaction.
Prompt Table: BANK_TR_ACTR_VW |
| 88 | REC_BNK_ID_NBR | Character(20) | VARCHAR2(20) NOT NULL | The alphanumeric bank identifier associated with a bank on the receiving side of a settlement transa |
| 89 | REC_BANK_ACCT_NUM | Character(35) | VARCHAR2(35) NOT NULL | The bank account number for the receiving side of a settlement transaction. |
| 90 | REC_SETTLEMENT_ID | Character(5) | VARCHAR2(5) NOT NULL |
The settlement instructions associated with the bank and account on the receiving side
Prompt Table: STL_INSTR_R_VW |
| 91 | LAST_MAINT_DTTM | DateTime(26) | TIMESTAMP | A system generated value that reflects the date and time a transaction was last modified |
| 92 | LAST_MAINT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Last Maintained By Operator ID |
| 93 | EO_FROM_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |