[Home] [Help]
View: EDW_PVT_LEVEL_COLUMNS_MD_V
View Text
SELECT ITEM.ELEMENTID COLUMN_ID
, ITEM.NAME COLUMN_NAME
, ITEM.LONGNAME LOGICAL_NAME
, ITEM.OWNINGRELATION LEVEL_ID
, DATA.NAME DATA_TYPE
, ITEM.LENGTH LENGTH
, ITEM.DESCRIPTION DESCRIPTION
FROM CMPITEM_V ITEM
, CMPDATATYPE_V DATA
WHERE DATA.ELEMENTID=ITEM.DOMAIN
Columns
Name |
COLUMN_ID |
COLUMN_NAME |
LOGICAL_NAME |
LEVEL_ID |
DATA_TYPE |
LENGTH |
DESCRIPTION |