TRX_SELBUY_TEO1(SQL Table) |
Index Back |
---|---|
CCU TEO temp tableCCU 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 |