eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: XTR.XTR_ACCRLS_AMORT#

Source

View Text - Preformatted


select DEAL_NO DEAL_NO, TRANS_NO TRANS_NO, PERIOD_FROM PERIOD_FROM, PERIOD_TO PERIOD_TO, COMPANY_CODE COMPANY_CODE, DEAL_TYPE DEAL_TYPE, DEAL_SUBTYPE DEAL_SUBTYPE, CPARTY_CODE CPARTY_CODE, CURRENCY CURRENCY, PRODUCT_TYPE PRODUCT_TYPE, PORTFOLIO_CODE PORTFOLIO_CODE, AMOUNT_TYPE AMOUNT_TYPE, ACTION_CODE ACTION_CODE, TRANSACTION_AMOUNT TRANSACTION_AMOUNT, ACTUAL_START_DATE ACTUAL_START_DATE, ACTUAL_MATURITY_DATE ACTUAL_MATURITY_DATE, INTEREST_RATE INTEREST_RATE, NO_OF_DAYS NO_OF_DAYS, YEAR_BASIS YEAR_BASIS, ACCRLS_AMOUNT ACCRLS_AMOUNT, FIRST_ACCRUAL_INDIC FIRST_ACCRUAL_INDIC, TRANSFERED_ON TRANSFERED_ON, REVERSAL_DATE REVERSAL_DATE, CREATED_ON CREATED_ON, CREATED_BY CREATED_BY, ACCRLS_AMOUNT_BAL ACCRLS_AMOUNT_BAL, EFFECTIVE_CALCULATED_VALUE EFFECTIVE_CALCULATED_VALUE, AUTHORIZE_JOURNAL_CREATION AUTHORIZE_JOURNAL_CREATION, JOURNAL_CREATED JOURNAL_CREATED, BATCH_ID BATCH_ID, CALC_FACE_VALUE CALC_FACE_VALUE, EFFINT_ACCRLS_AMOUNT_BAL EFFINT_ACCRLS_AMOUNT_BAL from "XTR"."XTR_ACCRLS_AMORT"

View Text - HTML Formatted

SELECT DEAL_NO DEAL_NO
, TRANS_NO TRANS_NO
, PERIOD_FROM PERIOD_FROM
, PERIOD_TO PERIOD_TO
, COMPANY_CODE COMPANY_CODE
, DEAL_TYPE DEAL_TYPE
, DEAL_SUBTYPE DEAL_SUBTYPE
, CPARTY_CODE CPARTY_CODE
, CURRENCY CURRENCY
, PRODUCT_TYPE PRODUCT_TYPE
, PORTFOLIO_CODE PORTFOLIO_CODE
, AMOUNT_TYPE AMOUNT_TYPE
, ACTION_CODE ACTION_CODE
, TRANSACTION_AMOUNT TRANSACTION_AMOUNT
, ACTUAL_START_DATE ACTUAL_START_DATE
, ACTUAL_MATURITY_DATE ACTUAL_MATURITY_DATE
, INTEREST_RATE INTEREST_RATE
, NO_OF_DAYS NO_OF_DAYS
, YEAR_BASIS YEAR_BASIS
, ACCRLS_AMOUNT ACCRLS_AMOUNT
, FIRST_ACCRUAL_INDIC FIRST_ACCRUAL_INDIC
, TRANSFERED_ON TRANSFERED_ON
, REVERSAL_DATE REVERSAL_DATE
, CREATED_ON CREATED_ON
, CREATED_BY CREATED_BY
, ACCRLS_AMOUNT_BAL ACCRLS_AMOUNT_BAL
, EFFECTIVE_CALCULATED_VALUE EFFECTIVE_CALCULATED_VALUE
, AUTHORIZE_JOURNAL_CREATION AUTHORIZE_JOURNAL_CREATION
, JOURNAL_CREATED JOURNAL_CREATED
, BATCH_ID BATCH_ID
, CALC_FACE_VALUE CALC_FACE_VALUE
, EFFINT_ACCRLS_AMOUNT_BAL EFFINT_ACCRLS_AMOUNT_BAL
FROM "XTR"."XTR_ACCRLS_AMORT"