VIEW: XTR.XTR_A_DEALS#

Source

View Text - Preformatted

select ACCEPTOR_CODE ACCEPTOR_CODE, ACCEPTOR_NAME ACCEPTOR_NAME, ACCRUAL_FROM ACCRUAL_FROM, ACCRUAL_TO ACCRUAL_TO, ACCRUED_INTEREST_PRICE ACCRUED_INTEREST_PRICE, ACTION_STATUS ACTION_STATUS, ARCHIVE_BY ARCHIVE_BY, ARCHIVE_DATE ARCHIVE_DATE, AUDIT_DATE_STORED AUDIT_DATE_STORED, AUDIT_INDICATOR AUDIT_INDICATOR, ATTACHMENT_EXISTS ATTACHMENT_EXISTS, BASE_DATE BASE_DATE, BASE_RATE BASE_RATE, BKGE_SETTLED_REFERENCE BKGE_SETTLED_REFERENCE, BOND_ISSUE BOND_ISSUE, BOND_PROFIT_LOSS BOND_PROFIT_LOSS, BOND_RENEG_DATE BOND_RENEG_DATE, BOND_RESALE_DATE BOND_RESALE_DATE, BOND_SALE_DATE BOND_SALE_DATE, BROKER BROKER, BROKERAGE_AMOUNT BROKERAGE_AMOUNT, BROKERAGE_AMOUNT_HCE BROKERAGE_AMOUNT_HCE, BROKERAGE_CODE BROKERAGE_CODE, BROKERAGE_CURRENCY BROKERAGE_CURRENCY, BROKERAGE_RATE BROKERAGE_RATE, BUY_ACCOUNT_NO BUY_ACCOUNT_NO, BUY_AMOUNT BUY_AMOUNT, BUY_HCE_AMOUNT BUY_HCE_AMOUNT, CALC_BASIS CALC_BASIS, CAPITAL_PRICE CAPITAL_PRICE, CAP_OR_FLOOR CAP_OR_FLOOR, CLIENT_ADVICE CLIENT_ADVICE, CLIENT_CODE CLIENT_CODE, CLIENT_REF CLIENT_REF, COMMENCE_DATE COMMENCE_DATE, COMMENTS COMMENTS, COMPANY_CODE COMPANY_CODE, CONTRACT_COMMISSION CONTRACT_COMMISSION, CONTRACT_FEES CONTRACT_FEES, CONTRACT_NOS CONTRACT_NOS, CONTRACT_RATE CONTRACT_RATE, COUPON_ACTION COUPON_ACTION, COUPON_RATE COUPON_RATE, CPARTY_ADVICE CPARTY_ADVICE, CPARTY_CODE CPARTY_CODE, CPARTY_REF CPARTY_REF, CREATED_BY CREATED_BY, CREATED_ON CREATED_ON, CTY_CCY CTY_CCY, CUM_COUPON_DATE CUM_COUPON_DATE, CURRENCY CURRENCY, CURRENCY_BUY CURRENCY_BUY, CURRENCY_SELL CURRENCY_SELL, DEALER_CODE DEALER_CODE, DEAL_DATE DEAL_DATE, DEAL_LINKING_CODE DEAL_LINKING_CODE, DEAL_NO DEAL_NO, DEAL_SUBTYPE DEAL_SUBTYPE, DEAL_TYPE DEAL_TYPE, DISCOUNT DISCOUNT, 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, ENTER_INTO_SWAP ENTER_INTO_SWAP, EXCHANGE_CODE EXCHANGE_CODE, EXERCISE EXERCISE, EXPIRY_DATE EXPIRY_DATE, EXTERNAL_COMMENTS EXTERNAL_COMMENTS, EXTERNAL_CPARTY_NO EXTERNAL_CPARTY_NO, FACE_VALUE_AMOUNT FACE_VALUE_AMOUNT, FACE_VALUE_HCE_AMOUNT FACE_VALUE_HCE_AMOUNT, FIRST_REVAL FIRST_REVAL, FIXED_OR_FLOATING_RATE FIXED_OR_FLOATING_RATE, FIXED_TERM_MY FIXED_TERM_MY, FORWARD_HCE_AMOUNT FORWARD_HCE_AMOUNT, FRA_DESCRIPTION FRA_DESCRIPTION, FREQUENCY FREQUENCY, FXD_DEAL_NO FXD_DEAL_NO, FXO_DEAL_NO FXO_DEAL_NO, FX_COVER_CROSS_REF FX_COVER_CROSS_REF, FX_PD_DEAL_NO FX_PD_DEAL_NO, FX_REVALUED_ON_DATE FX_REVALUED_ON_DATE, FX_RO_DEAL_NO FX_RO_DEAL_NO, FX_SUBSIDIARY_BALANCE_AMOUNT FX_SUBSIDIARY_BALANCE_AMOUNT, FX_WHOLESALE_REF FX_WHOLESALE_REF, INSERT_FOR_CASHFLOW INSERT_FOR_CASHFLOW, INTEREST_AMOUNT INTEREST_AMOUNT, INTEREST_CUTOFF INTEREST_CUTOFF, INTEREST_HCE_AMOUNT INTEREST_HCE_AMOUNT, INTEREST_RATE INTEREST_RATE, INTERNAL_TICKET_NO INTERNAL_TICKET_NO, INT_SWAP_REF INT_SWAP_REF, KNOCK_EXECUTED_BY KNOCK_EXECUTED_BY, KNOCK_EXECUTED_ON KNOCK_EXECUTED_ON, KNOCK_INSERT_TYPE KNOCK_INSERT_TYPE, KNOCK_LEVEL KNOCK_LEVEL, KNOCK_TYPE KNOCK_TYPE, LIMIT_AMOUNT LIMIT_AMOUNT, LIMIT_CODE LIMIT_CODE, MARGIN MARGIN, MATURITY_ACCOUNT_NO MATURITY_ACCOUNT_NO, MATURITY_AMOUNT MATURITY_AMOUNT, MATURITY_BALANCE_AMOUNT MATURITY_BALANCE_AMOUNT, MATURITY_BALANCE_HCE_AMOUNT MATURITY_BALANCE_HCE_AMOUNT, MATURITY_DATE MATURITY_DATE, MATURITY_HCE_AMOUNT MATURITY_HCE_AMOUNT, NEXT_COUPON_DATE NEXT_COUPON_DATE, NI_DEAL_NO NI_DEAL_NO, NI_PROFIT_LOSS NI_PROFIT_LOSS, NO_OF_DAYS NO_OF_DAYS, OPTION_AMOUNT OPTION_AMOUNT, OPTION_COMMENCEMENT OPTION_COMMENCEMENT, OPTION_HCE_AMOUNT OPTION_HCE_AMOUNT, OPTION_POINTS OPTION_POINTS, OPTION_TYPE OPTION_TYPE, PAYMENT_FREQ PAYMENT_FREQ, PAYMENT_SCHEDULE_CODE PAYMENT_SCHEDULE_CODE, PI_AMOUNT_DUE PI_AMOUNT_DUE, PORTFOLIO_AMOUNT PORTFOLIO_AMOUNT, PORTFOLIO_CODE PORTFOLIO_CODE, PREMIUM_ACCOUNT_NO PREMIUM_ACCOUNT_NO, PREMIUM_ACTION PREMIUM_ACTION, PREMIUM_AMOUNT PREMIUM_AMOUNT, PREMIUM_AMOUNT_TYPE PREMIUM_AMOUNT_TYPE, PREMIUM_CURRENCY PREMIUM_CURRENCY, PREMIUM_DATE PREMIUM_DATE, PREMIUM_HCE_AMOUNT PREMIUM_HCE_AMOUNT, PREMIUM_NO_OF_DAYS PREMIUM_NO_OF_DAYS, PRINCIPAL_SETTLED_BY PRINCIPAL_SETTLED_BY, PRINTED_CPARTY_ADVICE PRINTED_CPARTY_ADVICE, PRINTED_YN PRINTED_YN, PRODUCT_TYPE PRODUCT_TYPE, QUICK_INPUT QUICK_INPUT, RATE_BASIS RATE_BASIS, REF_CCY REF_CCY, RENEG_DATE RENEG_DATE, RISKPARTY_CODE RISKPARTY_CODE, RISKPARTY_LIMIT_CODE RISKPARTY_LIMIT_CODE, SECURITY_NAME SECURITY_NAME, SELL_ACCOUNT_NO SELL_ACCOUNT_NO, SELL_AMOUNT SELL_AMOUNT, SELL_HCE_AMOUNT SELL_HCE_AMOUNT, SETTLE_ACCOUNT_NO SETTLE_ACCOUNT_NO, SETTLE_ACTION SETTLE_ACTION, SETTLE_AMOUNT SETTLE_AMOUNT, SETTLE_AMOUNT_TYPE SETTLE_AMOUNT_TYPE, SETTLE_DATE SETTLE_DATE, SETTLE_DUAL_AUTHORISATION_BY SETTLE_DUAL_AUTHORISATION_BY, SETTLE_DUAL_AUTHORISATION_ON SETTLE_DUAL_AUTHORISATION_ON, SETTLE_HCE_AMOUNT SETTLE_HCE_AMOUNT, SETTLE_NO_OF_DAYS SETTLE_NO_OF_DAYS, SETTLE_RATE SETTLE_RATE, SPOT_RATE_ON_VALUATION SPOT_RATE_ON_VALUATION, START_ACCOUNT_NO START_ACCOUNT_NO, START_AMOUNT START_AMOUNT, START_DATE START_DATE, START_HCE_AMOUNT START_HCE_AMOUNT, STATUS_CODE STATUS_CODE, SWAP_DEPO_ADJUSTMENT SWAP_DEPO_ADJUSTMENT, SWAP_DEPO_FLAG SWAP_DEPO_FLAG, SWAP_DEPO_INT_RATE SWAP_DEPO_INT_RATE, SWAP_DEPO_TOTAL_RECEIPT SWAP_DEPO_TOTAL_RECEIPT, SWAP_REF SWAP_REF, SYNTHETIC_PRINTED_YN SYNTHETIC_PRINTED_YN, TAX_AMOUNT TAX_AMOUNT, TAX_AMOUNT_HCE TAX_AMOUNT_HCE, TAX_CODE TAX_CODE, TAX_RATE TAX_RATE, TAX_SETTLED_REFERENCE TAX_SETTLED_REFERENCE, TERM_MY TERM_MY, TOTAL_PRICE TOTAL_PRICE, TRANSACTION_CROSS_REF TRANSACTION_CROSS_REF, TRANSACTION_NO TRANSACTION_NO, TRANSACTION_RATE TRANSACTION_RATE, UPDATED_BY UPDATED_BY, UPDATED_ON UPDATED_ON, VALUE_DATE VALUE_DATE, YEAR_BASIS YEAR_BASIS, YEAR_CALC_TYPE YEAR_CALC_TYPE, YIELD_AMOUNT YIELD_AMOUNT, YIELD_HCE_AMOUNT YIELD_HCE_AMOUNT, RATE_FIXING_DATE RATE_FIXING_DATE, SECURITY_ID SECURITY_ID, EXERCISE_PRICE EXERCISE_PRICE, PRICING_MODEL PRICING_MODEL, MARKET_DATA_SET MARKET_DATA_SET, INITIAL_FAIR_VALUE INITIAL_FAIR_VALUE, EXCHANGE_RATE_ONE EXCHANGE_RATE_ONE, EXCHANGE_RATE_TWO EXCHANGE_RATE_TWO, FIRST_REVAL_BATCH_ID FIRST_REVAL_BATCH_ID, LAST_REVAL_BATCH_ID LAST_REVAL_BATCH_ID, 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, PROFIT_LOSS PROFIT_LOSS, FX_RO_PD_RATE FX_RO_PD_RATE, FX_M1_DEAL_NO FX_M1_DEAL_NO, PREPAID_INTEREST PREPAID_INTEREST, DAY_COUNT_TYPE DAY_COUNT_TYPE, SETTLE_DAY_COUNT_TYPE SETTLE_DAY_COUNT_TYPE, ROUNDING_TYPE ROUNDING_TYPE, SETTLE_ROUNDING_TYPE SETTLE_ROUNDING_TYPE from "XTR"."XTR_A_DEALS"

View Text - HTML Formatted

SELECT ACCEPTOR_CODE ACCEPTOR_CODE
, ACCEPTOR_NAME ACCEPTOR_NAME
, ACCRUAL_FROM ACCRUAL_FROM
, ACCRUAL_TO ACCRUAL_TO
, ACCRUED_INTEREST_PRICE ACCRUED_INTEREST_PRICE
, ACTION_STATUS ACTION_STATUS
, ARCHIVE_BY ARCHIVE_BY
, ARCHIVE_DATE ARCHIVE_DATE
, AUDIT_DATE_STORED AUDIT_DATE_STORED
, AUDIT_INDICATOR AUDIT_INDICATOR
, ATTACHMENT_EXISTS ATTACHMENT_EXISTS
, BASE_DATE BASE_DATE
, BASE_RATE BASE_RATE
, BKGE_SETTLED_REFERENCE BKGE_SETTLED_REFERENCE
, BOND_ISSUE BOND_ISSUE
, BOND_PROFIT_LOSS BOND_PROFIT_LOSS
, BOND_RENEG_DATE BOND_RENEG_DATE
, BOND_RESALE_DATE BOND_RESALE_DATE
, BOND_SALE_DATE BOND_SALE_DATE
, BROKER BROKER
, BROKERAGE_AMOUNT BROKERAGE_AMOUNT
, BROKERAGE_AMOUNT_HCE BROKERAGE_AMOUNT_HCE
, BROKERAGE_CODE BROKERAGE_CODE
, BROKERAGE_CURRENCY BROKERAGE_CURRENCY
, BROKERAGE_RATE BROKERAGE_RATE
, BUY_ACCOUNT_NO BUY_ACCOUNT_NO
, BUY_AMOUNT BUY_AMOUNT
, BUY_HCE_AMOUNT BUY_HCE_AMOUNT
, CALC_BASIS CALC_BASIS
, CAPITAL_PRICE CAPITAL_PRICE
, CAP_OR_FLOOR CAP_OR_FLOOR
, CLIENT_ADVICE CLIENT_ADVICE
, CLIENT_CODE CLIENT_CODE
, CLIENT_REF CLIENT_REF
, COMMENCE_DATE COMMENCE_DATE
, COMMENTS COMMENTS
, COMPANY_CODE COMPANY_CODE
, CONTRACT_COMMISSION CONTRACT_COMMISSION
, CONTRACT_FEES CONTRACT_FEES
, CONTRACT_NOS CONTRACT_NOS
, CONTRACT_RATE CONTRACT_RATE
, COUPON_ACTION COUPON_ACTION
, COUPON_RATE COUPON_RATE
, CPARTY_ADVICE CPARTY_ADVICE
, CPARTY_CODE CPARTY_CODE
, CPARTY_REF CPARTY_REF
, CREATED_BY CREATED_BY
, CREATED_ON CREATED_ON
, CTY_CCY CTY_CCY
, CUM_COUPON_DATE CUM_COUPON_DATE
, CURRENCY CURRENCY
, CURRENCY_BUY CURRENCY_BUY
, CURRENCY_SELL CURRENCY_SELL
, DEALER_CODE DEALER_CODE
, DEAL_DATE DEAL_DATE
, DEAL_LINKING_CODE DEAL_LINKING_CODE
, DEAL_NO DEAL_NO
, DEAL_SUBTYPE DEAL_SUBTYPE
, DEAL_TYPE DEAL_TYPE
, DISCOUNT DISCOUNT
, 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
, ENTER_INTO_SWAP ENTER_INTO_SWAP
, EXCHANGE_CODE EXCHANGE_CODE
, EXERCISE EXERCISE
, EXPIRY_DATE EXPIRY_DATE
, EXTERNAL_COMMENTS EXTERNAL_COMMENTS
, EXTERNAL_CPARTY_NO EXTERNAL_CPARTY_NO
, FACE_VALUE_AMOUNT FACE_VALUE_AMOUNT
, FACE_VALUE_HCE_AMOUNT FACE_VALUE_HCE_AMOUNT
, FIRST_REVAL FIRST_REVAL
, FIXED_OR_FLOATING_RATE FIXED_OR_FLOATING_RATE
, FIXED_TERM_MY FIXED_TERM_MY
, FORWARD_HCE_AMOUNT FORWARD_HCE_AMOUNT
, FRA_DESCRIPTION FRA_DESCRIPTION
, FREQUENCY FREQUENCY
, FXD_DEAL_NO FXD_DEAL_NO
, FXO_DEAL_NO FXO_DEAL_NO
, FX_COVER_CROSS_REF FX_COVER_CROSS_REF
, FX_PD_DEAL_NO FX_PD_DEAL_NO
, FX_REVALUED_ON_DATE FX_REVALUED_ON_DATE
, FX_RO_DEAL_NO FX_RO_DEAL_NO
, FX_SUBSIDIARY_BALANCE_AMOUNT FX_SUBSIDIARY_BALANCE_AMOUNT
, FX_WHOLESALE_REF FX_WHOLESALE_REF
, INSERT_FOR_CASHFLOW INSERT_FOR_CASHFLOW
, INTEREST_AMOUNT INTEREST_AMOUNT
, INTEREST_CUTOFF INTEREST_CUTOFF
, INTEREST_HCE_AMOUNT INTEREST_HCE_AMOUNT
, INTEREST_RATE INTEREST_RATE
, INTERNAL_TICKET_NO INTERNAL_TICKET_NO
, INT_SWAP_REF INT_SWAP_REF
, KNOCK_EXECUTED_BY KNOCK_EXECUTED_BY
, KNOCK_EXECUTED_ON KNOCK_EXECUTED_ON
, KNOCK_INSERT_TYPE KNOCK_INSERT_TYPE
, KNOCK_LEVEL KNOCK_LEVEL
, KNOCK_TYPE KNOCK_TYPE
, LIMIT_AMOUNT LIMIT_AMOUNT
, LIMIT_CODE LIMIT_CODE
, MARGIN MARGIN
, MATURITY_ACCOUNT_NO MATURITY_ACCOUNT_NO
, MATURITY_AMOUNT MATURITY_AMOUNT
, MATURITY_BALANCE_AMOUNT MATURITY_BALANCE_AMOUNT
, MATURITY_BALANCE_HCE_AMOUNT MATURITY_BALANCE_HCE_AMOUNT
, MATURITY_DATE MATURITY_DATE
, MATURITY_HCE_AMOUNT MATURITY_HCE_AMOUNT
, NEXT_COUPON_DATE NEXT_COUPON_DATE
, NI_DEAL_NO NI_DEAL_NO
, NI_PROFIT_LOSS NI_PROFIT_LOSS
, NO_OF_DAYS NO_OF_DAYS
, OPTION_AMOUNT OPTION_AMOUNT
, OPTION_COMMENCEMENT OPTION_COMMENCEMENT
, OPTION_HCE_AMOUNT OPTION_HCE_AMOUNT
, OPTION_POINTS OPTION_POINTS
, OPTION_TYPE OPTION_TYPE
, PAYMENT_FREQ PAYMENT_FREQ
, PAYMENT_SCHEDULE_CODE PAYMENT_SCHEDULE_CODE
, PI_AMOUNT_DUE PI_AMOUNT_DUE
, PORTFOLIO_AMOUNT PORTFOLIO_AMOUNT
, PORTFOLIO_CODE PORTFOLIO_CODE
, PREMIUM_ACCOUNT_NO PREMIUM_ACCOUNT_NO
, PREMIUM_ACTION PREMIUM_ACTION
, PREMIUM_AMOUNT PREMIUM_AMOUNT
, PREMIUM_AMOUNT_TYPE PREMIUM_AMOUNT_TYPE
, PREMIUM_CURRENCY PREMIUM_CURRENCY
, PREMIUM_DATE PREMIUM_DATE
, PREMIUM_HCE_AMOUNT PREMIUM_HCE_AMOUNT
, PREMIUM_NO_OF_DAYS PREMIUM_NO_OF_DAYS
, PRINCIPAL_SETTLED_BY PRINCIPAL_SETTLED_BY
, PRINTED_CPARTY_ADVICE PRINTED_CPARTY_ADVICE
, PRINTED_YN PRINTED_YN
, PRODUCT_TYPE PRODUCT_TYPE
, QUICK_INPUT QUICK_INPUT
, RATE_BASIS RATE_BASIS
, REF_CCY REF_CCY
, RENEG_DATE RENEG_DATE
, RISKPARTY_CODE RISKPARTY_CODE
, RISKPARTY_LIMIT_CODE RISKPARTY_LIMIT_CODE
, SECURITY_NAME SECURITY_NAME
, SELL_ACCOUNT_NO SELL_ACCOUNT_NO
, SELL_AMOUNT SELL_AMOUNT
, SELL_HCE_AMOUNT SELL_HCE_AMOUNT
, SETTLE_ACCOUNT_NO SETTLE_ACCOUNT_NO
, SETTLE_ACTION SETTLE_ACTION
, SETTLE_AMOUNT SETTLE_AMOUNT
, SETTLE_AMOUNT_TYPE SETTLE_AMOUNT_TYPE
, SETTLE_DATE SETTLE_DATE
, SETTLE_DUAL_AUTHORISATION_BY SETTLE_DUAL_AUTHORISATION_BY
, SETTLE_DUAL_AUTHORISATION_ON SETTLE_DUAL_AUTHORISATION_ON
, SETTLE_HCE_AMOUNT SETTLE_HCE_AMOUNT
, SETTLE_NO_OF_DAYS SETTLE_NO_OF_DAYS
, SETTLE_RATE SETTLE_RATE
, SPOT_RATE_ON_VALUATION SPOT_RATE_ON_VALUATION
, START_ACCOUNT_NO START_ACCOUNT_NO
, START_AMOUNT START_AMOUNT
, START_DATE START_DATE
, START_HCE_AMOUNT START_HCE_AMOUNT
, STATUS_CODE STATUS_CODE
, SWAP_DEPO_ADJUSTMENT SWAP_DEPO_ADJUSTMENT
, SWAP_DEPO_FLAG SWAP_DEPO_FLAG
, SWAP_DEPO_INT_RATE SWAP_DEPO_INT_RATE
, SWAP_DEPO_TOTAL_RECEIPT SWAP_DEPO_TOTAL_RECEIPT
, SWAP_REF SWAP_REF
, SYNTHETIC_PRINTED_YN SYNTHETIC_PRINTED_YN
, TAX_AMOUNT TAX_AMOUNT
, TAX_AMOUNT_HCE TAX_AMOUNT_HCE
, TAX_CODE TAX_CODE
, TAX_RATE TAX_RATE
, TAX_SETTLED_REFERENCE TAX_SETTLED_REFERENCE
, TERM_MY TERM_MY
, TOTAL_PRICE TOTAL_PRICE
, TRANSACTION_CROSS_REF TRANSACTION_CROSS_REF
, TRANSACTION_NO TRANSACTION_NO
, TRANSACTION_RATE TRANSACTION_RATE
, UPDATED_BY UPDATED_BY
, UPDATED_ON UPDATED_ON
, VALUE_DATE VALUE_DATE
, YEAR_BASIS YEAR_BASIS
, YEAR_CALC_TYPE YEAR_CALC_TYPE
, YIELD_AMOUNT YIELD_AMOUNT
, YIELD_HCE_AMOUNT YIELD_HCE_AMOUNT
, RATE_FIXING_DATE RATE_FIXING_DATE
, SECURITY_ID SECURITY_ID
, EXERCISE_PRICE EXERCISE_PRICE
, PRICING_MODEL PRICING_MODEL
, MARKET_DATA_SET MARKET_DATA_SET
, INITIAL_FAIR_VALUE INITIAL_FAIR_VALUE
, EXCHANGE_RATE_ONE EXCHANGE_RATE_ONE
, EXCHANGE_RATE_TWO EXCHANGE_RATE_TWO
, FIRST_REVAL_BATCH_ID FIRST_REVAL_BATCH_ID
, LAST_REVAL_BATCH_ID LAST_REVAL_BATCH_ID
, 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
, PROFIT_LOSS PROFIT_LOSS
, FX_RO_PD_RATE FX_RO_PD_RATE
, FX_M1_DEAL_NO FX_M1_DEAL_NO
, PREPAID_INTEREST PREPAID_INTEREST
, DAY_COUNT_TYPE DAY_COUNT_TYPE
, SETTLE_DAY_COUNT_TYPE SETTLE_DAY_COUNT_TYPE
, ROUNDING_TYPE ROUNDING_TYPE
, SETTLE_ROUNDING_TYPE SETTLE_ROUNDING_TYPE
FROM "XTR"."XTR_A_DEALS"