| Table Name: | MPSysReports |
| View Name: | MARISysReports |
| Group: | Group: TempReportDocumentHeader |
| Description: | Reporting: User Report definition |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| UserReportID | UserReportID INT Primary |
||
| Bezeichnung | ReportName NVARCHAR (50) Unique |
||
| Beschreibung | Description NVARCHAR (255) |
||
| ReportTyp | ReportType SMALLINT |
||
| Gruppe | GroupId INT |
||
| MReportClassID | ReportClassID INT Index |
||
| FileName | FileName NVARCHAR (255) |
||
| PathTyp | PathTyp SMALLINT |
||
| ReportPath | ReportPath NVARCHAR (255) |
MPDokumente.DocID | |
| Benutzer | UserCode NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| Rechte | Rights BIGINT |
MPBenutzergruppen.Gruppe (WHERE BenutzerTyp=1) | |
| KundenRechte | RightsCustomerUser BIGINT |
MPBenutzergruppen.Gruppe (WHERE BenutzerTyp=1) | |
| RechteWebLAN | RightsWebLAN BIGINT |
MPBenutzergruppen.Gruppe (WHERE BenutzerTyp=1) | |
| RechteWebWAN | RightsWebWAN BIGINT |
MPBenutzergruppen.Gruppe (WHERE BenutzerTyp=1) | |
| ReportMajor | ReportMajor SMALLINT |
||
| ReportMinor | ReportMinor SMALLINT |
||
| SQLSourceTyp | SQLSourceTyp INT |
||
| SQLDevice | SQLDevice INT |
||
| SQLSource | SQLSource NTEXT |
||
| FlaggTranslate | FlagTranslate INT |
||
| TableID | UserTableID INT Index |
||
| Printer | Printer NVARCHAR (100) |
||
| Prtr1st | Prtr1st NVARCHAR (100) |
||
| Use1stPrtr | Use1stPrtr SMALLINT (0=false,-1=true) |
||
| PrintSizeID | PrintSizeID INT Index |
MPSysReportSize.PrintSizeID | |
| NumCopy | NumCopy INT |
||
| SysClassFilter | SysClassFilter NVARCHAR (50) |
||
| HTMLRenderSettings | HTMLRenderSettings NTEXT |
||
| FilterMode | FilterMode INT |
||
| FilterID | FilterID INT Index |
MPSysFilterDefinitionFilter.FilterID | |
| DMSMode | DMSMode INT |
||
| EInvoiceMode | EInvoiceMode INT |
||
| MandantenFilter | CompanyFilter INT |
||
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MPBuchdruck | Project Dokumentation: Print Defnition Head |
| MPEKVertraegeBelegeEInvoice | Purchase Process: Extra Information peparing an electronic document |
| MPGebindeKategorie | Container Categtrory to manage special settings |
| MPQualityProcess | QualityProcess Definition |
| MPSysReportsLanguage | Reporting: User Report definition translation of crystal reports objects |
| MPTrainingExams | Training Module: List of exams |
| MPTrainingGrade | Training Module: List of grades |
| MPVKVertraegeBelegeEInvoice | Contract Management: Additional information for PEPPOL |