VIEW: XTR.XTR_R_ROLLOVER_TRANSACTIONS#

Source

View Text - Preformatted

select ACCEPTOR_CODE ACCEPTOR_CODE, ACCEPTOR_NAME ACCEPTOR_NAME, ACCRUAL_FROM ACCRUAL_FROM, ACCRUAL_TO ACCRUAL_TO, ACCUM_INTEREST ACCUM_INTEREST, ACCUM_INTEREST_BF ACCUM_INTEREST_BF, ACCUM_INTEREST_BF_HCE ACCUM_INTEREST_BF_HCE, ACCUM_INTEREST_HCE ACCUM_INTEREST_HCE, ACCUM_INT_ACCOUNT_NO ACCUM_INT_ACCOUNT_NO, ACCUM_INT_ACTION ACCUM_INT_ACTION, ACCUM_INT_AMOUNT_TYPE ACCUM_INT_AMOUNT_TYPE, ACTION_STATUS ACTION_STATUS, ADJUSTED_BALANCE ADJUSTED_BALANCE, ARCHIVE_BY ARCHIVE_BY, ARCHIVE_DATE ARCHIVE_DATE, ATTACHMENT_EXISTS ATTACHMENT_EXISTS, AUDIT_INDICATOR AUDIT_INDICATOR, BALANCE_OUT BALANCE_OUT, BALANCE_OUT_BF BALANCE_OUT_BF, BALANCE_OUT_BF_HCE BALANCE_OUT_BF_HCE, BALANCE_OUT_HCE BALANCE_OUT_HCE, BAL_OS_ACCOUNT_NO BAL_OS_ACCOUNT_NO, BKGE_SETTLED_REFERENCE BKGE_SETTLED_REFERENCE, BROKERAGE_AMOUNT BROKERAGE_AMOUNT, BROKERAGE_AMOUNT_HCE BROKERAGE_AMOUNT_HCE, BROKERAGE_CODE BROKERAGE_CODE, BROKERAGE_RATE BROKERAGE_RATE, CLIENT_ADVICE CLIENT_ADVICE, CLIENT_CODE CLIENT_CODE, COMMENTS COMMENTS, COMPANY_CODE COMPANY_CODE, CPARTY_ADVICE CPARTY_ADVICE, CPARTY_CODE CPARTY_CODE, CREATED_BY CREATED_BY, CREATED_ON CREATED_ON, CROSS_REF_TO_TRANS CROSS_REF_TO_TRANS, CURRENCY CURRENCY, DATE_RECEIVED DATE_RECEIVED, DEALER_CODE DEALER_CODE, DEAL_DATE DEAL_DATE, DEAL_LINKING_CODE DEAL_LINKING_CODE, DEAL_NUMBER DEAL_NUMBER, DEAL_SUBTYPE DEAL_SUBTYPE, DEAL_TYPE DEAL_TYPE, DRAWER_CODE DRAWER_CODE, DRAWER_NAME DRAWER_NAME, DUAL_AUTHORISATION_BY DUAL_AUTHORISATION_BY, DUAL_AUTHORISATION_ON DUAL_AUTHORISATION_ON, ENDORSER_CODE ENDORSER_CODE, ENDORSER_NAME ENDORSER_NAME, EXPECTED_BALANCE_BF EXPECTED_BALANCE_BF, EXPECTED_BALANCE_OUT EXPECTED_BALANCE_OUT, EXTERNAL_COMMENTS EXTERNAL_COMMENTS, EXTERNAL_CPARTY_NO EXTERNAL_CPARTY_NO, FID_TAX FID_TAX, FID_TAX_HCE FID_TAX_HCE, INTEREST INTEREST, INTEREST_FREQ INTEREST_FREQ, INTEREST_HCE INTEREST_HCE, INTEREST_RATE INTEREST_RATE, INTEREST_SETTLED INTEREST_SETTLED, INTEREST_SETTLEMENT_TYPE INTEREST_SETTLEMENT_TYPE, INTERNAL_TICKET_NO INTERNAL_TICKET_NO, ISSUER_ADVICE ISSUER_ADVICE, LIMIT_CODE LIMIT_CODE, MATURITY_DATE MATURITY_DATE, NI_PROFIT_LOSS NI_PROFIT_LOSS, NI_PROFIT_LOSS_HCE NI_PROFIT_LOSS_HCE, NI_RENEG_DATE NI_RENEG_DATE, NO_OF_DAYS NO_OF_DAYS, OLD_PRODUCT_TYPE OLD_PRODUCT_TYPE, PARCEL_SPLIT_NO PARCEL_SPLIT_NO, PARENT_PARTY PARENT_PARTY, PI_AMOUNT_DUE PI_AMOUNT_DUE, PI_AMOUNT_RECEIVED PI_AMOUNT_RECEIVED, PORTFOLIO_CODE PORTFOLIO_CODE, PRINCIPAL_ACCOUNT_NO PRINCIPAL_ACCOUNT_NO, PRINCIPAL_ACTION PRINCIPAL_ACTION, PRINCIPAL_ADJUST PRINCIPAL_ADJUST, PRINCIPAL_ADJUST_HCE PRINCIPAL_ADJUST_HCE, PRINCIPAL_AMOUNT_TYPE PRINCIPAL_AMOUNT_TYPE, PRINTED_CPARTY_ADVICE PRINTED_CPARTY_ADVICE, PRINTED_REDEMPTION_YN PRINTED_REDEMPTION_YN, PRINTED_YN PRINTED_YN, PRODUCT_TYPE PRODUCT_TYPE, QUICK_INPUT QUICK_INPUT, RATE_EFFECTIVE_CREATED RATE_EFFECTIVE_CREATED, RENEG_ONLY_LETTER RENEG_ONLY_LETTER, REPAY_AMOUNT REPAY_AMOUNT, REPAY_AMOUNT_HCE REPAY_AMOUNT_HCE, SECURITY_TYPE SECURITY_TYPE, SETTLEMENT_TYPE SETTLEMENT_TYPE, SETTLE_DATE SETTLE_DATE, SETTLE_TERM_INTEREST SETTLE_TERM_INTEREST, START_DATE START_DATE, STATUS_CODE STATUS_CODE, TAX_AMOUNT TAX_AMOUNT, TAX_AMOUNT_HCE TAX_AMOUNT_HCE, TAX_CODE TAX_CODE, TAX_RATE TAX_RATE, TAX_SETTLED_REFERENCE TAX_SETTLED_REFERENCE, TRANSACTION_NUMBER TRANSACTION_NUMBER, TRANS_CLOSEOUT_NO TRANS_CLOSEOUT_NO, UPDATED_BY UPDATED_BY, UPDATED_ON UPDATED_ON, YEAR_BASIS YEAR_BASIS, YEAR_CALC_TYPE YEAR_CALC_TYPE, RATE_FIXING_DATE RATE_FIXING_DATE from "XTR"."XTR_R_ROLLOVER_TRANSACTIONS"

View Text - HTML Formatted

SELECT ACCEPTOR_CODE ACCEPTOR_CODE
, ACCEPTOR_NAME ACCEPTOR_NAME
, ACCRUAL_FROM ACCRUAL_FROM
, ACCRUAL_TO ACCRUAL_TO
, ACCUM_INTEREST ACCUM_INTEREST
, ACCUM_INTEREST_BF ACCUM_INTEREST_BF
, ACCUM_INTEREST_BF_HCE ACCUM_INTEREST_BF_HCE
, ACCUM_INTEREST_HCE ACCUM_INTEREST_HCE
, ACCUM_INT_ACCOUNT_NO ACCUM_INT_ACCOUNT_NO
, ACCUM_INT_ACTION ACCUM_INT_ACTION
, ACCUM_INT_AMOUNT_TYPE ACCUM_INT_AMOUNT_TYPE
, ACTION_STATUS ACTION_STATUS
, ADJUSTED_BALANCE ADJUSTED_BALANCE
, ARCHIVE_BY ARCHIVE_BY
, ARCHIVE_DATE ARCHIVE_DATE
, ATTACHMENT_EXISTS ATTACHMENT_EXISTS
, AUDIT_INDICATOR AUDIT_INDICATOR
, BALANCE_OUT BALANCE_OUT
, BALANCE_OUT_BF BALANCE_OUT_BF
, BALANCE_OUT_BF_HCE BALANCE_OUT_BF_HCE
, BALANCE_OUT_HCE BALANCE_OUT_HCE
, BAL_OS_ACCOUNT_NO BAL_OS_ACCOUNT_NO
, BKGE_SETTLED_REFERENCE BKGE_SETTLED_REFERENCE
, BROKERAGE_AMOUNT BROKERAGE_AMOUNT
, BROKERAGE_AMOUNT_HCE BROKERAGE_AMOUNT_HCE
, BROKERAGE_CODE BROKERAGE_CODE
, BROKERAGE_RATE BROKERAGE_RATE
, CLIENT_ADVICE CLIENT_ADVICE
, CLIENT_CODE CLIENT_CODE
, COMMENTS COMMENTS
, COMPANY_CODE COMPANY_CODE
, CPARTY_ADVICE CPARTY_ADVICE
, CPARTY_CODE CPARTY_CODE
, CREATED_BY CREATED_BY
, CREATED_ON CREATED_ON
, CROSS_REF_TO_TRANS CROSS_REF_TO_TRANS
, CURRENCY CURRENCY
, DATE_RECEIVED DATE_RECEIVED
, DEALER_CODE DEALER_CODE
, DEAL_DATE DEAL_DATE
, DEAL_LINKING_CODE DEAL_LINKING_CODE
, DEAL_NUMBER DEAL_NUMBER
, DEAL_SUBTYPE DEAL_SUBTYPE
, DEAL_TYPE DEAL_TYPE
, DRAWER_CODE DRAWER_CODE
, DRAWER_NAME DRAWER_NAME
, DUAL_AUTHORISATION_BY DUAL_AUTHORISATION_BY
, DUAL_AUTHORISATION_ON DUAL_AUTHORISATION_ON
, ENDORSER_CODE ENDORSER_CODE
, ENDORSER_NAME ENDORSER_NAME
, EXPECTED_BALANCE_BF EXPECTED_BALANCE_BF
, EXPECTED_BALANCE_OUT EXPECTED_BALANCE_OUT
, EXTERNAL_COMMENTS EXTERNAL_COMMENTS
, EXTERNAL_CPARTY_NO EXTERNAL_CPARTY_NO
, FID_TAX FID_TAX
, FID_TAX_HCE FID_TAX_HCE
, INTEREST INTEREST
, INTEREST_FREQ INTEREST_FREQ
, INTEREST_HCE INTEREST_HCE
, INTEREST_RATE INTEREST_RATE
, INTEREST_SETTLED INTEREST_SETTLED
, INTEREST_SETTLEMENT_TYPE INTEREST_SETTLEMENT_TYPE
, INTERNAL_TICKET_NO INTERNAL_TICKET_NO
, ISSUER_ADVICE ISSUER_ADVICE
, LIMIT_CODE LIMIT_CODE
, MATURITY_DATE MATURITY_DATE
, NI_PROFIT_LOSS NI_PROFIT_LOSS
, NI_PROFIT_LOSS_HCE NI_PROFIT_LOSS_HCE
, NI_RENEG_DATE NI_RENEG_DATE
, NO_OF_DAYS NO_OF_DAYS
, OLD_PRODUCT_TYPE OLD_PRODUCT_TYPE
, PARCEL_SPLIT_NO PARCEL_SPLIT_NO
, PARENT_PARTY PARENT_PARTY
, PI_AMOUNT_DUE PI_AMOUNT_DUE
, PI_AMOUNT_RECEIVED PI_AMOUNT_RECEIVED
, PORTFOLIO_CODE PORTFOLIO_CODE
, PRINCIPAL_ACCOUNT_NO PRINCIPAL_ACCOUNT_NO
, PRINCIPAL_ACTION PRINCIPAL_ACTION
, PRINCIPAL_ADJUST PRINCIPAL_ADJUST
, PRINCIPAL_ADJUST_HCE PRINCIPAL_ADJUST_HCE
, PRINCIPAL_AMOUNT_TYPE PRINCIPAL_AMOUNT_TYPE
, PRINTED_CPARTY_ADVICE PRINTED_CPARTY_ADVICE
, PRINTED_REDEMPTION_YN PRINTED_REDEMPTION_YN
, PRINTED_YN PRINTED_YN
, PRODUCT_TYPE PRODUCT_TYPE
, QUICK_INPUT QUICK_INPUT
, RATE_EFFECTIVE_CREATED RATE_EFFECTIVE_CREATED
, RENEG_ONLY_LETTER RENEG_ONLY_LETTER
, REPAY_AMOUNT REPAY_AMOUNT
, REPAY_AMOUNT_HCE REPAY_AMOUNT_HCE
, SECURITY_TYPE SECURITY_TYPE
, SETTLEMENT_TYPE SETTLEMENT_TYPE
, SETTLE_DATE SETTLE_DATE
, SETTLE_TERM_INTEREST SETTLE_TERM_INTEREST
, START_DATE START_DATE
, STATUS_CODE STATUS_CODE
, TAX_AMOUNT TAX_AMOUNT
, TAX_AMOUNT_HCE TAX_AMOUNT_HCE
, TAX_CODE TAX_CODE
, TAX_RATE TAX_RATE
, TAX_SETTLED_REFERENCE TAX_SETTLED_REFERENCE
, TRANSACTION_NUMBER TRANSACTION_NUMBER
, TRANS_CLOSEOUT_NO TRANS_CLOSEOUT_NO
, UPDATED_BY UPDATED_BY
, UPDATED_ON UPDATED_ON
, YEAR_BASIS YEAR_BASIS
, YEAR_CALC_TYPE YEAR_CALC_TYPE
, RATE_FIXING_DATE RATE_FIXING_DATE
FROM "XTR"."XTR_R_ROLLOVER_TRANSACTIONS"