TRX_PAYMENT_VW

(SQL View)
 Index Back

Treas Deal Interest Dates View

This view will provide all the fields from interest table and master id from the trx header table.

SELECT I.BUSINESS_UNIT ,I.TREAS_HEADER_ID ,I.TRANSACTION_LINE ,I.NOMINAL_DT ,I.TRX_PAYMENT_TYPE ,I.TRANSACTION_LEG ,I.SEQ_NBR ,I.INTEREST_DT ,I.PAYMENT_DT ,I.QUASI_COUPON_DT_SW ,I.PRINCIPAL_BALANCE ,I.OVERRIDE_AMT_SW ,I.PAYMENT_AMT ,I.PRINCIPAL_PAYMENT ,I.INTEREST_PAYMENT ,I.AMORT_MTHD_FACTOR ,I.CURRENCY_CD FROM PS_TRX_INTEREST_TR I

  • Parent record: TRX_DETAIL_TR

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 TREAS_HEADER_ID Character(12) VARCHAR2(12) NOT NULL The unique key identifier for a given deal transaction.
    3 TRANSACTION_LINE Number(3,0) SMALLINT NOT NULL The separate and distinct base instrument type components of a given deal transaction.
    4 NOMINAL_DT Date(10) DATE The nominal (non-adjusted) date for a given deal transaction cash flow.
    5 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
    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 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
    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

    11 PRINCIPAL_BALANCE Signed Number(28,3) DECIMAL(26,3) NOT NULL The notional principal balance of a given deal transaction at commencement.
    12 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

    13 PAYMENT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the amount of a customer payment.
    14 PRINCIPAL_PAYMENT Signed Number(28,3) DECIMAL(26,3) NOT NULL Payment that goes towards paying the principal.
    15 INTEREST_PAYMENT Signed Number(28,3) DECIMAL(26,3) NOT NULL Payment that goes towards paying the interest.
    16 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.
    17 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code