VIEW: BEN.BEN_VRBL_MTCHG_RT_F#

Source

View Text - Preformatted

select VRBL_MTCHG_RT_ID VRBL_MTCHG_RT_ID, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, NO_MX_PCT_OF_PY_NUM_FLAG NO_MX_PCT_OF_PY_NUM_FLAG, NO_MX_AMT_OF_PY_NUM_FLAG NO_MX_AMT_OF_PY_NUM_FLAG, NO_MX_MTCH_AMT_FLAG NO_MX_MTCH_AMT_FLAG, ORDR_NUM ORDR_NUM, CNTNU_MTCH_AFTR_MAX_RL_FLAG CNTNU_MTCH_AFTR_MAX_RL_FLAG, FROM_PCT_VAL FROM_PCT_VAL, VRBL_RT_PRFL_ID VRBL_RT_PRFL_ID, VMR_ATTRIBUTE_CATEGORY VMR_ATTRIBUTE_CATEGORY, VMR_ATTRIBUTE1 VMR_ATTRIBUTE1, VMR_ATTRIBUTE2 VMR_ATTRIBUTE2, VMR_ATTRIBUTE3 VMR_ATTRIBUTE3, VMR_ATTRIBUTE4 VMR_ATTRIBUTE4, VMR_ATTRIBUTE5 VMR_ATTRIBUTE5, VMR_ATTRIBUTE6 VMR_ATTRIBUTE6, VMR_ATTRIBUTE7 VMR_ATTRIBUTE7, VMR_ATTRIBUTE8 VMR_ATTRIBUTE8, VMR_ATTRIBUTE9 VMR_ATTRIBUTE9, VMR_ATTRIBUTE10 VMR_ATTRIBUTE10, VMR_ATTRIBUTE11 VMR_ATTRIBUTE11, VMR_ATTRIBUTE12 VMR_ATTRIBUTE12, VMR_ATTRIBUTE13 VMR_ATTRIBUTE13, VMR_ATTRIBUTE14 VMR_ATTRIBUTE14, VMR_ATTRIBUTE15 VMR_ATTRIBUTE15, VMR_ATTRIBUTE16 VMR_ATTRIBUTE16, VMR_ATTRIBUTE17 VMR_ATTRIBUTE17, VMR_ATTRIBUTE18 VMR_ATTRIBUTE18, VMR_ATTRIBUTE19 VMR_ATTRIBUTE19, VMR_ATTRIBUTE20 VMR_ATTRIBUTE20, VMR_ATTRIBUTE21 VMR_ATTRIBUTE21, VMR_ATTRIBUTE22 VMR_ATTRIBUTE22, VMR_ATTRIBUTE23 VMR_ATTRIBUTE23, VMR_ATTRIBUTE24 VMR_ATTRIBUTE24, VMR_ATTRIBUTE25 VMR_ATTRIBUTE25, VMR_ATTRIBUTE26 VMR_ATTRIBUTE26, VMR_ATTRIBUTE27 VMR_ATTRIBUTE27, VMR_ATTRIBUTE28 VMR_ATTRIBUTE28, VMR_ATTRIBUTE29 VMR_ATTRIBUTE29, VMR_ATTRIBUTE30 VMR_ATTRIBUTE30, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, TO_PCT_VAL TO_PCT_VAL, MX_PCT_OF_PY_NUM MX_PCT_OF_PY_NUM, PCT_VAL PCT_VAL, MX_MTCH_AMT MX_MTCH_AMT, MX_AMT_OF_PY_NUM MX_AMT_OF_PY_NUM, MN_MTCH_AMT MN_MTCH_AMT, MTCHG_RT_CALC_RL MTCHG_RT_CALC_RL from "BEN"."BEN_VRBL_MTCHG_RT_F"

View Text - HTML Formatted

SELECT VRBL_MTCHG_RT_ID VRBL_MTCHG_RT_ID
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, NO_MX_PCT_OF_PY_NUM_FLAG NO_MX_PCT_OF_PY_NUM_FLAG
, NO_MX_AMT_OF_PY_NUM_FLAG NO_MX_AMT_OF_PY_NUM_FLAG
, NO_MX_MTCH_AMT_FLAG NO_MX_MTCH_AMT_FLAG
, ORDR_NUM ORDR_NUM
, CNTNU_MTCH_AFTR_MAX_RL_FLAG CNTNU_MTCH_AFTR_MAX_RL_FLAG
, FROM_PCT_VAL FROM_PCT_VAL
, VRBL_RT_PRFL_ID VRBL_RT_PRFL_ID
, VMR_ATTRIBUTE_CATEGORY VMR_ATTRIBUTE_CATEGORY
, VMR_ATTRIBUTE1 VMR_ATTRIBUTE1
, VMR_ATTRIBUTE2 VMR_ATTRIBUTE2
, VMR_ATTRIBUTE3 VMR_ATTRIBUTE3
, VMR_ATTRIBUTE4 VMR_ATTRIBUTE4
, VMR_ATTRIBUTE5 VMR_ATTRIBUTE5
, VMR_ATTRIBUTE6 VMR_ATTRIBUTE6
, VMR_ATTRIBUTE7 VMR_ATTRIBUTE7
, VMR_ATTRIBUTE8 VMR_ATTRIBUTE8
, VMR_ATTRIBUTE9 VMR_ATTRIBUTE9
, VMR_ATTRIBUTE10 VMR_ATTRIBUTE10
, VMR_ATTRIBUTE11 VMR_ATTRIBUTE11
, VMR_ATTRIBUTE12 VMR_ATTRIBUTE12
, VMR_ATTRIBUTE13 VMR_ATTRIBUTE13
, VMR_ATTRIBUTE14 VMR_ATTRIBUTE14
, VMR_ATTRIBUTE15 VMR_ATTRIBUTE15
, VMR_ATTRIBUTE16 VMR_ATTRIBUTE16
, VMR_ATTRIBUTE17 VMR_ATTRIBUTE17
, VMR_ATTRIBUTE18 VMR_ATTRIBUTE18
, VMR_ATTRIBUTE19 VMR_ATTRIBUTE19
, VMR_ATTRIBUTE20 VMR_ATTRIBUTE20
, VMR_ATTRIBUTE21 VMR_ATTRIBUTE21
, VMR_ATTRIBUTE22 VMR_ATTRIBUTE22
, VMR_ATTRIBUTE23 VMR_ATTRIBUTE23
, VMR_ATTRIBUTE24 VMR_ATTRIBUTE24
, VMR_ATTRIBUTE25 VMR_ATTRIBUTE25
, VMR_ATTRIBUTE26 VMR_ATTRIBUTE26
, VMR_ATTRIBUTE27 VMR_ATTRIBUTE27
, VMR_ATTRIBUTE28 VMR_ATTRIBUTE28
, VMR_ATTRIBUTE29 VMR_ATTRIBUTE29
, VMR_ATTRIBUTE30 VMR_ATTRIBUTE30
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, TO_PCT_VAL TO_PCT_VAL
, MX_PCT_OF_PY_NUM MX_PCT_OF_PY_NUM
, PCT_VAL PCT_VAL
, MX_MTCH_AMT MX_MTCH_AMT
, MX_AMT_OF_PY_NUM MX_AMT_OF_PY_NUM
, MN_MTCH_AMT MN_MTCH_AMT
, MTCHG_RT_CALC_RL MTCHG_RT_CALC_RL
FROM "BEN"."BEN_VRBL_MTCHG_RT_F"