Table CRYSTAL_FIELDS

Crystal Fields metadata.

Column Name	Data Type	Description
CRYSTAL_DOCUMENT_ID	int	Foreign key to CRYSTAL_DOCUMENTS.ID
CRYSTAL_TABLE_ID	int	Foreign key to CRYSTAL_TABLES.ID
DESCRIPTION	varchar	Description of the field
FIELD_CLASS	varchar	Class of the field (number, string)
FORMULA_FORM	varchar	Formula form of the field
FORMULA_TEXT	nvarchar	Formula text of the field
HEADING_TEXT	varchar	Heading text used for the field
ID	int	Internal MetaMiner DB id
IS_ALLOW_MULTIPLE_VALUE	bit	Does the field allow multiple values?
IS_ALLOW_NULL	bit	Does the field allow null values?
IS_GROUPNAME_FIELD	bit	Is this a group name field?
IS_OPTIONAL_PROMPT	bit	Are prompts optional?
IS_RECURRING	bit	Is it a recurring field?
IS_UNIVERSE_OBJECT	bit	Is the field a universe object?
IS_USED_IN_CALC_OR_FRMLA	bit	Is the field used in a calculation or formula?
IS_USED_IN_REPORT	bit	Is the field used in the report?
IS_USED_WHERE_CLAUSE	bit	Is the field used in the where clause?
KIND	varchar	The type of the object, equivalent to SI_KIND in the CMS/Query Builder
LENGTH	int	Field length
LONG_NAME	varchar	Field long name
NAME	varchar	The name of the object, in many cases the equivalent of SI_ID in the CMS/Query Builder when referring to a base CMS object type (USERS, SEMANTICLAYER etc.)
REPORT_NAME	varchar	Field report name
SHORT_NAME	varchar	Field short name
SUMMARIZED_FIELD	varchar	Summarized field
SUMMARY_OPERATION	varchar	Summary operation
TABLE_ALIAS	varchar	Table alias
TYPE	varchar	Type
VALUE_RANGE_KIND	varchar	Value range kind