TRX_INT_TR_TEO1(SQL Table) |
Index Back |
|---|---|
CCU TEO temp tableCCU temporary table for TRX_INTEREST_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 | TREAS_HEADER_ID | Character(12) | VARCHAR2(12) NOT NULL | The unique key identifier for a given deal transaction. |
| 4 | TRANSACTION_LINE | Number(3,0) | SMALLINT NOT NULL | The separate and distinct base instrument type components of a given deal transaction. |
| 5 | NOMINAL_DT | Date(10) | DATE | The nominal (non-adjusted) date for a given deal transaction cash flow. |
| 6 | TRANSACTION_LEG | Number(1,0) | SMALLINT NOT NULL |
The separate and distinct business positions of a given deal transaction line.
1=Pay Leg 2=Receive Leg |
| 7 | TRX_PAYMENT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Decides that the payment is towards the interest on the loan or a part of the principal amount of the loan. For a future the code indicates the margin type.
I=Interest Payment P=Paydown R=Drawdown X=Exchange at Rate Reset Default Value: I |
| 8 | INTEREST_DT | Date(10) | DATE | The business date for an interest period in a deal transaction. |
| 9 | PAYMENT_DT | Date(10) | DATE | Payment Date |
| 10 | QUASI_COUPON_DT_SW | Character(1) | VARCHAR2(1) NOT NULL |
"An internal switch that indicates that an accrual
N=Normal period coupon, not odd Y=Is included in odd length Y/N Table Edit Default Value: N |
| 11 | RESET_RATE_SET | Character(1) | VARCHAR2(1) NOT NULL |
Allows the user to indicate that a floating rate for a particular cash flow has been ascertained and e
N=Rate Not Set Y=Reset Rate Set Y/N Table Edit |
| 12 | TRANSACTION_RATE | Number(16,8) | DECIMAL(15,8) NOT NULL | The applicable interest rate for a given deal transaction. |
| 13 | RATE_RESET_DT | Date(10) | DATE | The date that an interest rate quoted in the market is captured for purposes of calculating interest |
| 14 | PRINCIPAL_BALANCE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | The notional principal balance of a given deal transaction at commencement. |
| 15 | OVERRIDE_AMT_SW | Character(1) | VARCHAR2(1) NOT NULL |
Allows the user to override the system generated interest rate amount for a given variable rate deal
Y/N Table Edit Default Value: N |
| 16 | PAYMENT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Specifies the amount of a customer payment. |
| 17 | PRINCIPAL_PAYMENT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Payment that goes towards paying the principal. |
| 18 | INTEREST_PAYMENT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Payment that goes towards paying the interest. |
| 19 | AMORT_MTHD_FACTOR | Signed Number(24,20) | DECIMAL(22,20) NOT NULL | Factor that has to be applied to calculate the amortizing cashflow for the corresponding period. |
| 20 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 21 | EO_FROM_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |