| View Name: | MARISysUserFields |
| Based on table: | MPSysUserFields |
| Group: | Group: SysUserTable |
| Description: | System: User-defined fields: Additional fields by master data |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| ClassID | ClassID INT Primary |
ClassID | |
| FieldName | Field NVARCHAR (50) Primary |
||
| Description | Description NVARCHAR (50) |
||
| Type | Type SMALLINT |
||
| FieldSize | Size SMALLINT |
||
| Locked | Locked SMALLINT (0=false,-1=true) |
||
| ReadOnly | ReadOnly SMALLINT (0=false,-1=true) |
||
| OrderID | OrderID SMALLINT Index |
||
| ActionType | ActionTyp SMALLINT |
||
| RowSourceType | RowSourceType INT |
||
| RowSourceConnection | RowSourceConnection INT |
||
| RowSource | RowSource NTEXT |
||
| 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) |
||
| LinkTable | LinkTable NVARCHAR (50) |
||
| LinkTableField | LinkTableField NVARCHAR (50) |
||
| LinkTableCondition | LinkTableCondition NVARCHAR (100) |
||
| LinkClassID | LinkClassID INT Index |
ClassID | |
| LinkClassIDSource | LinkClassIDSource INT |
||
| LinkCompanyField | LinkCompanyField NVARCHAR (100) |
||
| LinkCompanyMode | LinkCompanyMode INT |
||
| FieldNameEN | FieldNameEN NVARCHAR (50) |
||
| FieldNameLangID | FieldNameLangID NVARCHAR (50) Index |
||
| Group1 | Group1 INT |
MARISysUserFieldsGroup.Group1 | |
| Group2 | Group2 INT |
MARISysUserFieldsGroup.Group2 | |
| Group3 | Group3 INT |
MARISysUserFieldsGroup.Group3 | |
| Group4 | Group4 INT |
MARISysUserFieldsGroup.Group4 | |
| Group5 | Group5 INT |
MARISysUserFieldsGroup.Group5 | |
| FullTextIndexMode | FullTextIndexMode INT |
||
| DefaultValue | DefaultValue NVARCHAR (255) |
||
| StyleFormat | StyleFormat INT |