| View Name: | MARISysArchivePatternTreeLine |
| Based on table: | MPSysArchivePatternTreeLine |
| Group: | |
| Description: | Definition to tag and place documents into DMS-Trees details |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| ArchivePatternTreeLineID | ArchivePatternTreeLineID INT Primary |
||
| ArchivePatternTreeID | ArchivePatternTreeID INT Index |
MARISysArchivePatternTree.ArchivePatternTreeID | |
| ArchivePatternID | ArchivePatternID INT Index |
MARISysArchivePattern.ArchivePatternID | |
| LineOrder | LineOrder INT Index |
||
| ElementMode | ElementMode INT |
||
| ElementFunction | ElementFunction INT |
||
| ElementFunctionValue | ElementFunctionValue NVARCHAR (255) |
||
| ElementValue | ElementValue NTEXT |
||
| 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 |