VIEW: XTR.XTR_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, FIRST_REVAL_BATCH_ID FIRST_REVAL_BATCH_ID, LAST_REVAL_BATCH_ID LAST_REVAL_BATCH_ID, CURRENCY_EXCHANGE_RATE CURRENCY_EXCHANGE_RATE, INITIAL_FAIR_VALUE INITIAL_FAIR_VALUE, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ALL_IN_RATE ALL_IN_RATE, AVERAGE_EXCHANGE_RATE AVERAGE_EXCHANGE_RATE, BACK_END_BROKERAGE_AMOUNT BACK_END_BROKERAGE_AMOUNT, ORIG_COUPON_AMOUNT ORIG_COUPON_AMOUNT, QUANTITY QUANTITY, ORIGINAL_AMOUNT ORIGINAL_AMOUNT, FIRST_TRANSACTION_FLAG FIRST_TRANSACTION_FLAG, PRINCIPAL_TAX_CODE PRINCIPAL_TAX_CODE, PRINCIPAL_TAX_RATE PRINCIPAL_TAX_RATE, PRINCIPAL_TAX_AMOUNT PRINCIPAL_TAX_AMOUNT, PRINCIPAL_TAX_SETTLED_REF PRINCIPAL_TAX_SETTLED_REF, PREPAID_INTEREST PREPAID_INTEREST, INTEREST_REFUND INTEREST_REFUND, ORG_TRANS_NO ORG_TRANS_NO, COUPON_DUE_DATE COUPON_DUE_DATE, PRINCIPAL_ACCT_USE_ID PRINCIPAL_ACCT_USE_ID, ACCUM_INT_ACCT_USE_ID ACCUM_INT_ACCT_USE_ID, BAL_OS_ACCT_USE_ID BAL_OS_ACCT_USE_ID from "XTR"."XTR_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
, FIRST_REVAL_BATCH_ID FIRST_REVAL_BATCH_ID
, LAST_REVAL_BATCH_ID LAST_REVAL_BATCH_ID
, CURRENCY_EXCHANGE_RATE CURRENCY_EXCHANGE_RATE
, INITIAL_FAIR_VALUE INITIAL_FAIR_VALUE
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ALL_IN_RATE ALL_IN_RATE
, AVERAGE_EXCHANGE_RATE AVERAGE_EXCHANGE_RATE
, BACK_END_BROKERAGE_AMOUNT BACK_END_BROKERAGE_AMOUNT
, ORIG_COUPON_AMOUNT ORIG_COUPON_AMOUNT
, QUANTITY QUANTITY
, ORIGINAL_AMOUNT ORIGINAL_AMOUNT
, FIRST_TRANSACTION_FLAG FIRST_TRANSACTION_FLAG
, PRINCIPAL_TAX_CODE PRINCIPAL_TAX_CODE
, PRINCIPAL_TAX_RATE PRINCIPAL_TAX_RATE
, PRINCIPAL_TAX_AMOUNT PRINCIPAL_TAX_AMOUNT
, PRINCIPAL_TAX_SETTLED_REF PRINCIPAL_TAX_SETTLED_REF
, PREPAID_INTEREST PREPAID_INTEREST
, INTEREST_REFUND INTEREST_REFUND
, ORG_TRANS_NO ORG_TRANS_NO
, COUPON_DUE_DATE COUPON_DUE_DATE
, PRINCIPAL_ACCT_USE_ID PRINCIPAL_ACCT_USE_ID
, ACCUM_INT_ACCT_USE_ID ACCUM_INT_ACCT_USE_ID
, BAL_OS_ACCT_USE_ID BAL_OS_ACCT_USE_ID
FROM "XTR"."XTR_ROLLOVER_TRANSACTIONS"