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_A_BOND_ISSUES#

Source

View Text - Preformatted


select AUDIT_DATE_STORED AUDIT_DATE_STORED, AUDIT_INDICATOR AUDIT_INDICATOR, AUTHORISED AUTHORISED, BOND_ISSUE_CODE BOND_ISSUE_CODE, BOND_OR_DEBENTURE_ISSUE BOND_OR_DEBENTURE_ISSUE, CALC_TYPE CALC_TYPE, COUPON_RATE COUPON_RATE, COUPON_TYPE COUPON_TYPE, CREATED_BY CREATED_BY, CREATED_ON CREATED_ON, CURRENCY CURRENCY, DESCRIPTION DESCRIPTION, FIRST_COUPON_DATE FIRST_COUPON_DATE, ISSUER ISSUER, MATURITY_DATE MATURITY_DATE, NO_OF_COUPONS_PER_YEAR NO_OF_COUPONS_PER_YEAR, RIC_CODE RIC_CODE, RISK_GROUP RISK_GROUP, UPDATED_BY UPDATED_BY, UPDATED_ON UPDATED_ON, YEAR_BASIS YEAR_BASIS, YEAR_CALC_TYPE YEAR_CALC_TYPE, ACCRUED_INT_YEAR_CALC_BASIS ACCRUED_INT_YEAR_CALC_BASIS, FORCE_MONTH_END_COUPONS FORCE_MONTH_END_COUPONS, COMMENCE_DATE COMMENCE_DATE, LAST_COUPON_DATE LAST_COUPON_DATE, SETTLEMENT_BASIS SETTLEMENT_BASIS, SECURITY_ID SECURITY_ID, PRICE_ROUNDING PRICE_ROUNDING, YIELD_ROUNDING YIELD_ROUNDING, PRICE_ROUND_TYPE PRICE_ROUND_TYPE, YIELD_ROUND_TYPE YIELD_ROUND_TYPE, CALC_ROUNDING CALC_ROUNDING, PRICING_MODEL PRICING_MODEL, MARKET_DATA_SET MARKET_DATA_SET, MARGIN MARGIN, 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 from "XTR"."XTR_A_BOND_ISSUES"

View Text - HTML Formatted

SELECT AUDIT_DATE_STORED AUDIT_DATE_STORED
, AUDIT_INDICATOR AUDIT_INDICATOR
, AUTHORISED AUTHORISED
, BOND_ISSUE_CODE BOND_ISSUE_CODE
, BOND_OR_DEBENTURE_ISSUE BOND_OR_DEBENTURE_ISSUE
, CALC_TYPE CALC_TYPE
, COUPON_RATE COUPON_RATE
, COUPON_TYPE COUPON_TYPE
, CREATED_BY CREATED_BY
, CREATED_ON CREATED_ON
, CURRENCY CURRENCY
, DESCRIPTION DESCRIPTION
, FIRST_COUPON_DATE FIRST_COUPON_DATE
, ISSUER ISSUER
, MATURITY_DATE MATURITY_DATE
, NO_OF_COUPONS_PER_YEAR NO_OF_COUPONS_PER_YEAR
, RIC_CODE RIC_CODE
, RISK_GROUP RISK_GROUP
, UPDATED_BY UPDATED_BY
, UPDATED_ON UPDATED_ON
, YEAR_BASIS YEAR_BASIS
, YEAR_CALC_TYPE YEAR_CALC_TYPE
, ACCRUED_INT_YEAR_CALC_BASIS ACCRUED_INT_YEAR_CALC_BASIS
, FORCE_MONTH_END_COUPONS FORCE_MONTH_END_COUPONS
, COMMENCE_DATE COMMENCE_DATE
, LAST_COUPON_DATE LAST_COUPON_DATE
, SETTLEMENT_BASIS SETTLEMENT_BASIS
, SECURITY_ID SECURITY_ID
, PRICE_ROUNDING PRICE_ROUNDING
, YIELD_ROUNDING YIELD_ROUNDING
, PRICE_ROUND_TYPE PRICE_ROUND_TYPE
, YIELD_ROUND_TYPE YIELD_ROUND_TYPE
, CALC_ROUNDING CALC_ROUNDING
, PRICING_MODEL PRICING_MODEL
, MARKET_DATA_SET MARKET_DATA_SET
, MARGIN MARGIN
, 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
FROM "XTR"."XTR_A_BOND_ISSUES"