| Table Name: | MPSysDocSeries |
| View Name: | MARISysDocSeries |
| Group: | |
| Description: | System: Numberseries for ProjectManagement documents |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| MPDocType | MPDocType INT Primary |
||
| Series | Series INT Primary |
||
| CompanyID | Company INT Primary |
MPSysConnections.CompanyID (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) |
||
| ErstanlageID | CreateUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| Erstanlage | CreateDate Datetime |
||
| AenderungID | ChangeUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| Aenderung | ChangeDate Datetime |
||
| UpdateStamp | UpdateStamp INT |