| Table Name: | MPSysArchivePatternTree |
| View Name: | MARISysArchivePatternTree |
| Group: | |
| Description: | Definition to tag and place documents into DMS-Trees |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| ArchivePatternTreeID | ArchivePatternTreeID INT Primary |
||
| ArchivePatternID | ArchivePatternID INT Index |
MPSysArchivePattern.ArchivePatternID | |
| TreeName | TreeName NVARCHAR (100) |
||
| TreeOrder | TreeOrder INT Index |
||
| TreeOptions | TreeOptions INT |
||
| ArchiveOptions | ArchiveOptions INT |
||
| AccessMode | AccessMode INT |
||
| AccessRead | AccessRead BIGINT |
||
| AccessChange | AccessChange BIGINT |
||
| AccessInsert | AccessInsert BIGINT |
||
| AccessDelete | AccessDelete BIGINT |
||
| AccessAll | AccessAll BIGINT |
||
| 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 |
| Table | Description |
|---|---|
| MPSysArchivePatternTreeLine | Definition to tag and place documents into DMS-Trees details |