| View Name: | MARISysLock |
| Based on table: | MPSysLock |
| Group: | Group: SysMessages |
| Description: | System: logical lock of master data |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| MPUser | MPUser NVARCHAR (4) Primary |
MARIUser.MPUser (WHERE BenutzerTyp=1) | |
| NTUser | NTUser NVARCHAR (50) Primary |
||
| Computer | Computer NVARCHAR (128) Primary |
||
| PID | PID INT Primary |
||
| ClassID | ClassID INT Primary |
ClassID | |
| ClassKey | ClassKey NVARCHAR (50) Primary |
||
| LockTyp | LockTyp SMALLINT Primary |
||
| LockMode | LockMode SMALLINT Primary |
||
| SubClassID | SubClassID INT Primary |
ClassID | |
| SubClassKey | SubClassKey NVARCHAR (20) Primary |
||
| FormHandle | FormHandle INT |
||
| ApplicationID | AppID INT |
||
| LockStart | LockStart Datetime |
||
| LockStamp | LockStamp Datetime |
||
| Message | Message NVARCHAR (255) |
| Table | Description |
|---|---|
| MARISysLogBook | System: Change log by SQL Triggers (Table information) |