| Table Name: | MPSysUserFields |
| View Name: | MARISysUserFields |
| Group: | Group: SysUserTable |
| Description: | System: User-defined fields: Additional fields by master data |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| ClassID | ClassID INT Primary |
ClassID | |
| Field | FieldName NVARCHAR (50) Primary |
||
| Description | Description NVARCHAR (50) |
||
| Type | Type SMALLINT |
||
| Size | FieldSize SMALLINT |
||
| Locked | Locked SMALLINT (0=false,-1=true) |
||
| ReadOnly | ReadOnly SMALLINT (0=false,-1=true) |
||
| OrderID | OrderID SMALLINT Index |
||
| ActionTyp | ActionType 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 |
MPSysUserFieldsGroup. | |
| Group2 | Group2 INT |
MPSysUserFieldsGroup. | |
| Group3 | Group3 INT |
MPSysUserFieldsGroup. | |
| Group4 | Group4 INT |
MPSysUserFieldsGroup. | |
| Group5 | Group5 INT |
MPSysUserFieldsGroup. | |
| FullTextIndexMode | FullTextIndexMode INT |
||
| DefaultValue | DefaultValue NVARCHAR (255) |
||
| StyleFormat | StyleFormat INT |