| Table Name: | MPSysMasterProperties |
| View Name: | MARISysMasterProperties |
| Group: | Group: SysMasterProperties |
| Description: | Property Settings for master data (Contract Person, Employees, Service Tasks, Events) |
| ClassID: | 564. See Overview of ClassIDs by table. |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| PropertyID | PropertyID INT Primary |
Unique ID Referenced by MPSysMasterPropertyLink | |
| PropertyStack | PropertyStack INT Index |
MPSysMasterPropertyStack.PropertyStack | |
| PropertyName | PropertyName NVARCHAR (50) |
Visible property name | |
| PropertyComment | PropertyComment NVARCHAR (100) |
||
| Indent | Indent INT |
Indent starts at 0 | |
| Position | Position INT Index |
Visible order of the properties | |
| ParentPropertyID | ParentPropertyID INT Index |
Will point to parent Indent-1 (not used to build hierarchy) | MPSysMasterProperties.PropertyID |
| Parent0 | Parent0 INT Index |
parent indent 0 | MPSysMasterProperties.PropertyID |
| Parent1 | Parent1 INT Index |
parent indent 1 | MPSysMasterProperties.PropertyID |
| Parent2 | Parent2 INT Index |
parent indent 2 | MPSysMasterProperties.PropertyID |
| Parent3 | Parent3 INT Index |
parent indent 3 | MPSysMasterProperties.PropertyID |
| Parent4 | Parent4 INT Index |
parent indent 4 | MPSysMasterProperties.PropertyID |
| Parent5 | Parent5 INT Index |
parent indent 5 | MPSysMasterProperties.PropertyID |
| Parent6 | Parent6 INT Index |
parent indent 6 | MPSysMasterProperties.PropertyID |
| Parent7 | Parent7 INT Index |
parent indent 7 | MPSysMasterProperties.PropertyID |
| Parent8 | Parent8 INT Index |
parent indent 8 | MPSysMasterProperties.PropertyID |
| Parent9 | Parent9 INT Index |
parent indent 9 | MPSysMasterProperties.PropertyID |
| UsageType | UsageType INT |
Leave=1, Branch=2 | clsImportSysMasterProperties_eSysMasterPropertyUsageType |
| UsageFlag | UsageFlag INT |
Flag for the use in selected dimensions. See enum | clsImportSysMasterProperties_eSysMasterPropertyUsageDimensionFlag |
| ChildSelectionMode | ChildSelectionMode SMALLINT |
||
| PropertyTag | PropertyTag NVARCHAR (100) |
||
| CreateDate | CreateDate Datetime |
||
| CreateUser | CreateUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| ChangeDate | ChangeDate Datetime |
||
| ChangeUser | ChangeUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| Memo | Memo NTEXT |
||
| InActive | InActive SMALLINT (0=false,-1=true) |
||
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MPSysMasterProperties | Property Settings for master data (Contract Person, Employees, Service Tasks, Events) |
| MPSysMasterPropertyLink | Link between Dimension (ClassID) and a SysMasterProperty. See MPSysMasterProperty.UsageFlag for the used linked dimensions. |