TRX_SELBUY_TEO1

(SQL Table)
Index Back

CCU TEO temp table

CCU temporary table for TRX_SELLBUY_MTC

# 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 INSTRUMENT_TYPE Character(10) VARCHAR2(10) NOT NULL Instrument type
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 TREAS_HEADER_ID Character(12) VARCHAR2(12) NOT NULL The unique key identifier for a given deal transaction.

Prompt Table: TRX_HEADER_VW1

7 SETTLEMENT_DT Date(10) DATE The settlement date for a given cash -based transaction, or the start date for a Treasury Deal.
8 SALE_TRANS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Unwind Par Amount
9 SALE_PRICE_PERCENT Number(14,8) DECIMAL(13,8) NOT NULL The percentage of Unwind par value of which a financial instrument is priced when booked into the system.
10 SALE_PRICE Signed Number(28,3) DECIMAL(26,3) NOT NULL The sales price for a buy/sellback transaction.
11 SALE_PURCH_INT Signed Number(28,3) DECIMAL(26,3) NOT NULL The amount of accrued interest associated with an instrument when the same is acquired.
12 PURCH_INT_SOURCE Character(1) VARCHAR2(1) NOT NULL Whether purchased interest was input by user or calculated by system.
S=System Supplied
U=User Supplied
13 SALE_PROCEEDS Signed Number(28,3) DECIMAL(26,3) NOT NULL The received sales proceeds for a buy/sellback transaction.
14 SALE_UBV_SOURCE Character(1) VARCHAR2(1) NOT NULL Whether UBV was input by user or calculated by system.
S=System Supplied
U=User Supplied
15 SALE_CURRENT_VALUE Signed Number(28,3) DECIMAL(26,3) NOT NULL The subject accounting value for a buy/sellback transaction.
16 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL

17 SALE_UPB Signed Number(28,3) DECIMAL(26,3) NOT NULL Unwind Principal Balance (Original Par Amount if no amortization OR Unamortized Principal Balance)
18 AMORT_DISC_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Represents the discount amount deducted from the par price of a given deal transaction such as a bond.
19 UNAMORT_DISC_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Represents the Unamortized discount amount deducted from the par price of a given deal transaction such as a bond.
20 SALE_PRO_PERCENT Number(14,8) DECIMAL(13,8) NOT NULL The percentage of Unwind par value of which a financial instrument is priced when booked into the system.
21 WRITEOFF_UNAM Signed Number(28,3) DECIMAL(26,3) NOT NULL Represents the discount amount deducted from the par price of a given deal transaction such as a bond.
22 SALE_FEE_BALANCE Signed Number(28,3) DECIMAL(26,3) NOT NULL Represents Fee Balance on Deal Fees
23 AMORT_FEE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Represents Amortized Fee Balance on Deal Fees
24 UNAMORT_FEE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Represents Unamortized Fee Balance on Deal Fees
25 WRITEOFF_FEE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Represents Unamortized Fee Balance on Deal Fees
26 GAIN_LOSS Signed Number(28,3) DECIMAL(26,3) NOT NULL Retirement Gain/Loss
27 LAST_MAINT_DTTM DateTime(26) TIMESTAMP A system generated value that reflects the date and time a transaction was last modified
28 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID

Prompt Table: OPRID_VW

29 EO_FROM_CURRENCY Character(3) VARCHAR2(3) NOT NULL Currency Code