MPSysFilterDefinitionFilter

Table Name:	MPSysFilterDefinitionFilter
View Name:	MARISysFilterDefinitionFilter
Group:
Description:	Definition of dynamic filter forms - field definition

Field	View(engl.field)/Type	Related
FilterFieldID	FilterFieldID INT Primary
FilterID	FilterID INT Index	MPSysFilterDefinition.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)	MPBenutzer.Benutzer (WHERE BenutzerTyp=1)
ChangeDate	ChangeDate Datetime
ChangeUser	ChangeUser NVARCHAR (4)	MPBenutzer.Benutzer (WHERE BenutzerTyp=1)

Table	Description
MPSysFilterDefinitionGroup	Definition of dynamic filter forms - Tabs
MPSysFilterDefinitionValues	User Values for filter forms, with different names
MPSysReports	Reporting: User Report definition
MPSysUserQuery	System: User Defined Queries

MARIProject Database Structure