| Table Name: | MPSysFormFieldOptions |
| View Name: | MARISysFormFieldOptions |
| Group: | |
| Description: | System Table: Manage defaults and visibility of fieds in web forms |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| Application | Application INT Primary |
||
| FormName | FormName NVARCHAR (100) Primary |
||
| FormMode | FormMode INT Primary |
||
| ControlName | ControlName NVARCHAR (50) Primary |
||
| ClassID | ClassID INT Primary |
ClassID to distinguish Ticket, Task, Idea, DevTask, HP Task | |
| ControlType | ControlType INT |
||
| VisibilityMode | VisibilityMode INT |
||
| MandatoryMode | MandatoryMode INT |
||
| PrefillRule | PrefillRule INT |
||
| PrefillQueryID | PrefillQueryID INT |
||
| ValidationRule | ValidationRule INT |
||
| ValidationQueryID | ValidationQueryID INT |
||
| CreateDate | CreateDate Datetime |
||
| CreateUser | CreateUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| ChangeDate | ChangeDate Datetime |
||
| ChangeUser | ChangeUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| UserHint | UserHint NTEXT |