Table Name:alert_table
Table Number:4301
Group:
Description:Lists tables that can have alerts on them. Also, query information for them.
Flags: 
Baseline/Custom:Custom
Fields:
Field NameCommon TypeDatabase TypeGeneric Field IDArray SizeDefaultFlagsCommentField Used in Views
alias_nameCHARvarchar 80 USER_DEFINED Alias of table/view name  
col1CHARvarchar 80 USER_DEFINED Column 1 to query  
col2CHARvarchar 80 USER_DEFINED Column 2 to query  
col3CHARvarchar 80 USER_DEFINED Column 3 to query  
col4CHARvarchar 80 USER_DEFINED Column 4 to query  
col5CHARvarchar 80 USER_DEFINED Column 5 to query  
devLONGint151  USER_DEFINED, ALLOW_NULL Row version number for mobile distribution purposes  
lbl1CHARvarchar 80 USER_DEFINED Label of column 1  
lbl2CHARvarchar 80 USER_DEFINED Label of column 2  
lbl3CHARvarchar 80 USER_DEFINED Label of column 3  
lbl4CHARvarchar 80 USER_DEFINED Label of column 4  
lbl5CHARvarchar 80 USER_DEFINED Label of column 5  
num_query_colsLONGint   USER_DEFINED Number of query columns to use for this object.  
objidLONGint3  USER_DEFINED Internal Record number  
objid_columnCHARvarchar 80 USER_DEFINED Name of column that has objid (views only)  
out_col1CHARvarchar 80 USER_DEFINED Column 1 to display  
out_col2CHARvarchar 80 USER_DEFINED Column 2 to display  
out_lbl1CHARvarchar 80 USER_DEFINED Label of output column 1  
out_lbl2CHARvarchar 80 USER_DEFINED Label of output column 2  
table_or_viewCHARvarchar 80 USER_DEFINED Name of table or view to query  
Relations:
RelationTypeTarget ObjectInverse RelationCommentFlagsMTM TableUsed in Views
Indexes: (Defined in Clarify Schema)
Index NameFieldsFlags
Indexes (Defined in Database):
Index NameFieldsAdditional Information
objindexobjidclustered, unique located on PRIMARY
Referenced in Views:
View IDView NameTables
My Recent Objects
alert_table