BUSINESS_UNITTRD_TRADE_IDINSTRUMENT_TYPEINSTRMNT_TEMPLATETREAS_HEADER_IDPrompt Table: TRX_HEADER_VW1
S=System Supplied
U=User Supplied
S=System Supplied
U=User Supplied
Prompt Table: CURRENCY_CD_TBL
Prompt Table: OPRID_VW
TRX_SELLBUY_MTC(SQL Table) |
Index Back |
|---|---|
Sell/Buy back Match |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | TRD_TRADE_ID |
Character(12) | VARCHAR2(12) NOT NULL | Trade ID |
| 3 | INSTRUMENT_TYPE |
Character(10) | VARCHAR2(10) NOT NULL | Instrument type |
| 4 | 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 |
| 5 | TREAS_HEADER_ID |
Character(12) | VARCHAR2(12) NOT NULL |
The unique key identifier for a given deal transaction.
Prompt Table: TRX_HEADER_VW1 |
| 6 | SETTLEMENT_DT | Date(10) | DATE | The settlement date for a given cash -based transaction, or the start date for a Treasury Deal. |
| 7 | SALE_TRANS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Unwind Par Amount |
| 8 | 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. |
| 9 | SALE_PRICE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | The sales price for a buy/sellback transaction. |
| 10 | 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. |
| 11 | 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 |
| 12 | SALE_PROCEEDS | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | The received sales proceeds for a buy/sellback transaction. |
| 13 | 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 |
| 14 | SALE_CURRENT_VALUE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | The subject accounting value for a buy/sellback transaction. |
| 15 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 16 | SALE_UPB | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Unwind Principal Balance (Original Par Amount if no amortization OR Unamortized Principal Balance) |
| 17 | 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. |
| 18 | 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. |
| 19 | 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. |
| 20 | 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. |
| 21 | SALE_FEE_BALANCE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Represents Fee Balance on Deal Fees |
| 22 | AMORT_FEE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Represents Amortized Fee Balance on Deal Fees |
| 23 | UNAMORT_FEE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Represents Unamortized Fee Balance on Deal Fees |
| 24 | WRITEOFF_FEE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Represents Unamortized Fee Balance on Deal Fees |
| 25 | GAIN_LOSS | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Retirement Gain/Loss |
| 26 | LAST_MAINT_DTTM | DateTime(26) | TIMESTAMP | A system generated value that reflects the date and time a transaction was last modified |
| 27 | LAST_MAINT_OPRID | Character(30) | VARCHAR2(30) NOT NULL |
Last Maintained By Operator ID
Prompt Table: OPRID_VW |