MARISysFilterDefinitionFilter

View Name:	MARISysFilterDefinitionFilter
Based on table:	MPSysFilterDefinitionFilter
Group:
Description:	Definition of dynamic filter forms - field definition

Field	Table(Germ.field)/Type	Related
FilterFieldID	FilterFieldID INT Primary
FilterID	FilterID INT Index	MARISysFilterDefinition.FilterID
UseType	UseType INT
DBFieldType	DBFieldType INT
DBFieldSize	DBFieldSize INT
DBFieldName	DBFieldName NVARCHAR (255)
ControlType	ControlType INT
FromToMode	FromToMode INT
Description	Description NVARCHAR (255)
DescriptionID	DescriptionID INT Index
LineOrder	LineOrder INT
ControlClassID	ControlClassID INT Index	ClassID
RowSourceType	RowSourceType INT
RowSource	RowSource NTEXT
RowSourceDevice	RowSourceDevice INT
ControlMandatory	ControlMandatory SMALLINT
ControlVisible	ControlVisible SMALLINT
FilterGroup	FilterGroup INT
ReportFormularMode	ReportFormularMode INT
LinkFilterFieldID	LinkFilterFieldID INT Index
LinkFilterSysClassValue	LinkFilterSysClassValue NVARCHAR (100)
ValidationTyp	ValidationTyp INT
ValidationDefRange1	ValidationDefRange1 INT
ValidationRange1	ValidationRange1 INT
ValidationDefRange2	ValidationDefRange2 INT
ValidationRange2	ValidationRange2 INT
ValidationSQL1	ValidationSQL1 NTEXT
ValidationSQL2	ValidationSQL2 NTEXT
ValidationMessage	ValidationMessage NVARCHAR (255)
CreateDate	CreateDate Datetime
CreateUser	CreateUser NVARCHAR (4)	MARIUser.CreateUser (WHERE BenutzerTyp=1)
ChangeDate	ChangeDate Datetime
ChangeUser	ChangeUser NVARCHAR (4)	MARIUser.ChangeUser (WHERE BenutzerTyp=1)

Table	Description
MARISysReports	Reporting: User Report definition
MARISysUserQuery	System: User Defined Queries
MARISysFilterDefinitionGroup	Definition of dynamic filter forms - Tabs
MARISysFilterDefinitionValues	User Values for filter forms, with different names

MARIProject Database Structure