VIEW: XTR.XTR_A_MASTER_CURRENCIES#

Source

View Text - Preformatted

select AUDIT_DATE_STORED AUDIT_DATE_STORED, AUDIT_INDICATOR AUDIT_INDICATOR, AUTHORISED AUTHORISED, CALCULATE_HOLS_YEARS CALCULATE_HOLS_YEARS, CREATED_BY CREATED_BY, CREATED_ON CREATED_ON, CURRENCY CURRENCY, CURRENT_SPOT_RATE CURRENT_SPOT_RATE, DIVIDE_OR_MULTIPLY DIVIDE_OR_MULTIPLY, FX_SEQ_NO FX_SEQ_NO, HCE_RATE HCE_RATE, IR_SEQ_NO IR_SEQ_NO, LAST_TRANSACTION_CHANGED LAST_TRANSACTION_CHANGED, MAXIMUM_BAND MAXIMUM_BAND, MAX_DAYS_CONTRACT MAX_DAYS_CONTRACT, MINIMUM_BAND MINIMUM_BAND, NAME NAME, NET_FX_EXPOSURE NET_FX_EXPOSURE, RATE_DATE RATE_DATE, ROUNDING_FACTOR ROUNDING_FACTOR, SPOT_DATE SPOT_DATE, UPDATED_BY UPDATED_BY, UPDATED_ON UPDATED_ON, USD_BASE_CURR_BID_RATE USD_BASE_CURR_BID_RATE, USD_BASE_CURR_OFFER_RATE USD_BASE_CURR_OFFER_RATE, USD_QUOTED_SPOT USD_QUOTED_SPOT, UTILISED_AMOUNT UTILISED_AMOUNT, YEAR_BASIS YEAR_BASIS, IG_YEAR_BASIS IG_YEAR_BASIS from "XTR"."XTR_A_MASTER_CURRENCIES"

View Text - HTML Formatted

SELECT AUDIT_DATE_STORED AUDIT_DATE_STORED
, AUDIT_INDICATOR AUDIT_INDICATOR
, AUTHORISED AUTHORISED
, CALCULATE_HOLS_YEARS CALCULATE_HOLS_YEARS
, CREATED_BY CREATED_BY
, CREATED_ON CREATED_ON
, CURRENCY CURRENCY
, CURRENT_SPOT_RATE CURRENT_SPOT_RATE
, DIVIDE_OR_MULTIPLY DIVIDE_OR_MULTIPLY
, FX_SEQ_NO FX_SEQ_NO
, HCE_RATE HCE_RATE
, IR_SEQ_NO IR_SEQ_NO
, LAST_TRANSACTION_CHANGED LAST_TRANSACTION_CHANGED
, MAXIMUM_BAND MAXIMUM_BAND
, MAX_DAYS_CONTRACT MAX_DAYS_CONTRACT
, MINIMUM_BAND MINIMUM_BAND
, NAME NAME
, NET_FX_EXPOSURE NET_FX_EXPOSURE
, RATE_DATE RATE_DATE
, ROUNDING_FACTOR ROUNDING_FACTOR
, SPOT_DATE SPOT_DATE
, UPDATED_BY UPDATED_BY
, UPDATED_ON UPDATED_ON
, USD_BASE_CURR_BID_RATE USD_BASE_CURR_BID_RATE
, USD_BASE_CURR_OFFER_RATE USD_BASE_CURR_OFFER_RATE
, USD_QUOTED_SPOT USD_QUOTED_SPOT
, UTILISED_AMOUNT UTILISED_AMOUNT
, YEAR_BASIS YEAR_BASIS
, IG_YEAR_BASIS IG_YEAR_BASIS
FROM "XTR"."XTR_A_MASTER_CURRENCIES"