| View Name: | MARISysDocSeries |
| Based on table: | MPSysDocSeries |
| Group: | |
| Description: | System: Numberseries for ProjectManagement documents |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| MPDocType | MPDocType INT Primary |
||
| Series | Series INT Primary |
||
| Company | CompanyID INT Primary |
MARISysConnections.Company (WHERE ConnectionType=6) | |
| SeriesName | SeriesName NVARCHAR (50) |
||
| InitialNum | InitialNum INT |
||
| NextNumber | NextNumber INT |
||
| PrefixText | PrefixText NVARCHAR (20) |
||
| SuffixText | SuffixText NVARCHAR (20) |
||
| Blocked | Blocked SMALLINT (0=false,-1=true) |
||
| CreateUser | ErstanlageID NVARCHAR (4) |
MARIUser.CreateUser (WHERE BenutzerTyp=1) | |
| CreateDate | Erstanlage Datetime |
||
| ChangeUser | AenderungID NVARCHAR (4) |
MARIUser.ChangeUser (WHERE BenutzerTyp=1) | |
| ChangeDate | Aenderung Datetime |
||
| UpdateStamp | UpdateStamp INT |