| View Name: | MARISysReports |
| Based on table: | MPSysReports |
| Group: | Group: TempReportDocumentHeader |
| Description: | Reporting: User Report definition |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| UserReportID | UserReportID INT Primary |
||
| ReportName | Bezeichnung NVARCHAR (50) Unique |
||
| Description | Beschreibung NVARCHAR (255) |
||
| ReportType | ReportTyp SMALLINT |
||
| GroupId | Gruppe INT |
||
| ReportClassID | MReportClassID INT Index |
||
| FileName | FileName NVARCHAR (255) |
||
| PathTyp | PathTyp SMALLINT |
||
| ReportPath | ReportPath NVARCHAR (255) |
MARIDocuments.ReportPath | |
| UserCode | Benutzer NVARCHAR (4) |
MARIUser.UserCode (WHERE BenutzerTyp=1) | |
| Rights | Rechte BIGINT |
MARIUserGroups.Rights (WHERE BenutzerTyp=1) | |
| RightsCustomerUser | KundenRechte BIGINT |
MARIUserGroups.RightsCustomerUser (WHERE BenutzerTyp=1) | |
| RightsWebLAN | RechteWebLAN BIGINT |
MARIUserGroups.RightsWebLAN (WHERE BenutzerTyp=1) | |
| RightsWebWAN | RechteWebWAN BIGINT |
MARIUserGroups.RightsWebWAN (WHERE BenutzerTyp=1) | |
| ReportMajor | ReportMajor SMALLINT |
||
| ReportMinor | ReportMinor SMALLINT |
||
| SQLSourceTyp | SQLSourceTyp INT |
||
| SQLDevice | SQLDevice INT |
||
| SQLSource | SQLSource NTEXT |
||
| FlagTranslate | FlaggTranslate INT |
||
| UserTableID | TableID INT Index |
||
| Printer | Printer NVARCHAR (100) |
||
| Prtr1st | Prtr1st NVARCHAR (100) |
||
| Use1stPrtr | Use1stPrtr SMALLINT (0=false,-1=true) |
||
| PrintSizeID | PrintSizeID INT Index |
MARISysReportSize.PrintSizeID | |
| NumCopy | NumCopy INT |
||
| SysClassFilter | SysClassFilter NVARCHAR (50) |
||
| HTMLRenderSettings | HTMLRenderSettings NTEXT |
||
| FilterMode | FilterMode INT |
||
| FilterID | FilterID INT Index |
MARISysFilterDefinitionFilter.FilterID | |
| DMSMode | DMSMode INT |
||
| EInvoiceMode | EInvoiceMode INT |
||
| CompanyFilter | MandantenFilter INT |
||
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MARIQualityProcess | QualityProcess Definition |
| MARITrainingExams | Training Module: List of exams |
| MARITrainingGrade | Training Module: List of grades |
| MARISysReportsLanguage | Reporting: User Report definition translation of crystal reports objects |
| MARIBookPrint | Project Dokumentation: Print Defnition Head |
| MARIPurchaseProcessDocumentEInvoice | Purchase Process: Extra Information peparing an electronic document |
| MARIContractDocumentEInvoice | Contract Management: Additional information for PEPPOL |
| MARIContainerCategory | Container Categtrory to manage special settings |