| View Name: | MARISysArchivePatternTree |
| Based on table: | MPSysArchivePatternTree |
| Group: | |
| Description: | Definition to tag and place documents into DMS-Trees |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| ArchivePatternTreeID | ArchivePatternTreeID INT Primary |
||
| ArchivePatternID | ArchivePatternID INT Index |
MARISysArchivePattern.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) |
MARIUser.CreateUser (WHERE BenutzerTyp=1) | |
| ChangeDate | ChangeDate Datetime |
||
| ChangeUser | ChangeUser NVARCHAR (4) |
MARIUser.ChangeUser (WHERE BenutzerTyp=1) | |
| Memo | Memo NTEXT |
| Table | Description |
|---|---|
| MARISysArchivePatternTreeLine | Definition to tag and place documents into DMS-Trees details |