VIEW: BEN.BEN_EXT_DATA_ELMT#

Source

View Text - Preformatted

select EXT_DATA_ELMT_ID EXT_DATA_ELMT_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, TTL_FNCTN_CD TTL_FNCTN_CD, TTL_COND_OPER_CD TTL_COND_OPER_CD, TTL_COND_VAL TTL_COND_VAL, TTL_SUM_EXT_DATA_ELMT_ID TTL_SUM_EXT_DATA_ELMT_ID, TTL_COND_EXT_DATA_ELMT_ID TTL_COND_EXT_DATA_ELMT_ID, EXT_FLD_ID EXT_FLD_ID, XEL_ATTRIBUTE_CATEGORY XEL_ATTRIBUTE_CATEGORY, XEL_ATTRIBUTE1 XEL_ATTRIBUTE1, XEL_ATTRIBUTE2 XEL_ATTRIBUTE2, XEL_ATTRIBUTE3 XEL_ATTRIBUTE3, XEL_ATTRIBUTE4 XEL_ATTRIBUTE4, XEL_ATTRIBUTE5 XEL_ATTRIBUTE5, XEL_ATTRIBUTE6 XEL_ATTRIBUTE6, XEL_ATTRIBUTE7 XEL_ATTRIBUTE7, XEL_ATTRIBUTE8 XEL_ATTRIBUTE8, XEL_ATTRIBUTE9 XEL_ATTRIBUTE9, XEL_ATTRIBUTE10 XEL_ATTRIBUTE10, XEL_ATTRIBUTE11 XEL_ATTRIBUTE11, XEL_ATTRIBUTE12 XEL_ATTRIBUTE12, XEL_ATTRIBUTE13 XEL_ATTRIBUTE13, XEL_ATTRIBUTE14 XEL_ATTRIBUTE14, XEL_ATTRIBUTE15 XEL_ATTRIBUTE15, XEL_ATTRIBUTE16 XEL_ATTRIBUTE16, XEL_ATTRIBUTE17 XEL_ATTRIBUTE17, XEL_ATTRIBUTE18 XEL_ATTRIBUTE18, XEL_ATTRIBUTE19 XEL_ATTRIBUTE19, XEL_ATTRIBUTE20 XEL_ATTRIBUTE20, XEL_ATTRIBUTE21 XEL_ATTRIBUTE21, XEL_ATTRIBUTE22 XEL_ATTRIBUTE22, XEL_ATTRIBUTE23 XEL_ATTRIBUTE23, XEL_ATTRIBUTE24 XEL_ATTRIBUTE24, XEL_ATTRIBUTE25 XEL_ATTRIBUTE25, XEL_ATTRIBUTE26 XEL_ATTRIBUTE26, XEL_ATTRIBUTE27 XEL_ATTRIBUTE27, XEL_ATTRIBUTE28 XEL_ATTRIBUTE28, XEL_ATTRIBUTE29 XEL_ATTRIBUTE29, XEL_ATTRIBUTE30 XEL_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, NAME NAME, DATA_ELMT_TYP_CD DATA_ELMT_TYP_CD, DATA_ELMT_RL DATA_ELMT_RL, FRMT_MASK_CD FRMT_MASK_CD, STRING_VAL STRING_VAL, DFLT_VAL DFLT_VAL, MAX_LENGTH_NUM MAX_LENGTH_NUM, JUST_CD JUST_CD, LEGISLATION_CODE LEGISLATION_CODE, XML_TAG_NAME XML_TAG_NAME, DEFINED_BALANCE_ID DEFINED_BALANCE_ID, ZD_EDITION_NAME ZD_EDITION_NAME from "BEN"."BEN_EXT_DATA_ELMT"

View Text - HTML Formatted

SELECT EXT_DATA_ELMT_ID EXT_DATA_ELMT_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, TTL_FNCTN_CD TTL_FNCTN_CD
, TTL_COND_OPER_CD TTL_COND_OPER_CD
, TTL_COND_VAL TTL_COND_VAL
, TTL_SUM_EXT_DATA_ELMT_ID TTL_SUM_EXT_DATA_ELMT_ID
, TTL_COND_EXT_DATA_ELMT_ID TTL_COND_EXT_DATA_ELMT_ID
, EXT_FLD_ID EXT_FLD_ID
, XEL_ATTRIBUTE_CATEGORY XEL_ATTRIBUTE_CATEGORY
, XEL_ATTRIBUTE1 XEL_ATTRIBUTE1
, XEL_ATTRIBUTE2 XEL_ATTRIBUTE2
, XEL_ATTRIBUTE3 XEL_ATTRIBUTE3
, XEL_ATTRIBUTE4 XEL_ATTRIBUTE4
, XEL_ATTRIBUTE5 XEL_ATTRIBUTE5
, XEL_ATTRIBUTE6 XEL_ATTRIBUTE6
, XEL_ATTRIBUTE7 XEL_ATTRIBUTE7
, XEL_ATTRIBUTE8 XEL_ATTRIBUTE8
, XEL_ATTRIBUTE9 XEL_ATTRIBUTE9
, XEL_ATTRIBUTE10 XEL_ATTRIBUTE10
, XEL_ATTRIBUTE11 XEL_ATTRIBUTE11
, XEL_ATTRIBUTE12 XEL_ATTRIBUTE12
, XEL_ATTRIBUTE13 XEL_ATTRIBUTE13
, XEL_ATTRIBUTE14 XEL_ATTRIBUTE14
, XEL_ATTRIBUTE15 XEL_ATTRIBUTE15
, XEL_ATTRIBUTE16 XEL_ATTRIBUTE16
, XEL_ATTRIBUTE17 XEL_ATTRIBUTE17
, XEL_ATTRIBUTE18 XEL_ATTRIBUTE18
, XEL_ATTRIBUTE19 XEL_ATTRIBUTE19
, XEL_ATTRIBUTE20 XEL_ATTRIBUTE20
, XEL_ATTRIBUTE21 XEL_ATTRIBUTE21
, XEL_ATTRIBUTE22 XEL_ATTRIBUTE22
, XEL_ATTRIBUTE23 XEL_ATTRIBUTE23
, XEL_ATTRIBUTE24 XEL_ATTRIBUTE24
, XEL_ATTRIBUTE25 XEL_ATTRIBUTE25
, XEL_ATTRIBUTE26 XEL_ATTRIBUTE26
, XEL_ATTRIBUTE27 XEL_ATTRIBUTE27
, XEL_ATTRIBUTE28 XEL_ATTRIBUTE28
, XEL_ATTRIBUTE29 XEL_ATTRIBUTE29
, XEL_ATTRIBUTE30 XEL_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
, NAME NAME
, DATA_ELMT_TYP_CD DATA_ELMT_TYP_CD
, DATA_ELMT_RL DATA_ELMT_RL
, FRMT_MASK_CD FRMT_MASK_CD
, STRING_VAL STRING_VAL
, DFLT_VAL DFLT_VAL
, MAX_LENGTH_NUM MAX_LENGTH_NUM
, JUST_CD JUST_CD
, LEGISLATION_CODE LEGISLATION_CODE
, XML_TAG_NAME XML_TAG_NAME
, DEFINED_BALANCE_ID DEFINED_BALANCE_ID
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "BEN"."BEN_EXT_DATA_ELMT"