| Table Name: | MPDokumente |
| View Name: | MARIDocuments |
| Group: | |
| Description: | Documents linked in the Folder tabs of the master data |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| DocID | DocID INT Primary |
||
| VersionsID | VersionID INT |
||
| Datei | FileName NVARCHAR (255) |
||
| Pfad | PathName NVARCHAR (255) |
||
| MIMETyp | MimeType NVARCHAR (100) |
||
| Document_type | Document_type NVARCHAR (128) |
file extension .pdf or .gif | |
| Quelle | Source INT Index |
ClassID | |
| Erstanlage | CreateDate Datetime |
||
| ErstanlageID | CreateUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| DokumentDatum | DocDate Datetime |
||
| CheckOutState | CheckOutState INT |
||
| CheckOutUser | CheckOutUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| CheckOutDate | CheckOutDate Datetime |
||
| CheckOutMachine | CheckOutMachine NVARCHAR (50) |
||
| CheckOutPathFile | CheckOutPathFile NVARCHAR (255) |
||
| AenderungsText | ChangeText NVARCHAR (255) |
||
| DocumentHash | DocumentHashCode NVARCHAR (32) |
||
| Dokument | Document Image |
||
| ThumbNail | ThumbNail Image |
||
| ThumbHeight | ThumbHeight INT |
||
| ThumbWidth | ThumbWidth INT |
||
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MPBuchSeitenElement | Project Dokumentation: Book Page Content Element |
| MPBuchSeitenElementArchiv | Project Dokumentation: Book Page Content Element Archive |
| MPDokumenteVersionen | Revision History of a document |
| MPEKVertraegeBelegeDruck | Purchase Process: Print history |
| MPEquipmentSubjectBooking | Time/Costbooking on Equipment data |
| MPHotlineAnfrageAnhang | Support Module: Issue tracking: Issue line for comments, documents, emails, etc. |
| MPHotlineProduktKunde | Support Module: Support Product: Customer Product Link |
| MPNewsletterMaster | Newsletter Design Template |
| MPProjektArbeitspaketerfassung | Work Packages progress reporting by day |
| MPProjektArtikelerfassung | Time Keeping: ProjectTimeKeepingItems: For items used in a project each entry is stored in this table. This table is also linked to the header: MPProjectBuchungskopf |
| MPProjektBuchungserfassung | Time Keeping: ProjectTimeKeepingLines: One line per entry of an employee used for each project type |
| MPProjektBuchungserfassungBericht | Time Keeping: Link Week Report of employee or for customer |
| MPReise2ZeileDokumente | Travel Expenses Module: Trip receipt line (document link for scanned documents) |
| MPSammelmappe | Master Data Folder Documents |
| MPSammelmappeBaum | Master Data Folder Search Tree |
| MPSysAddOns | Manage Programm Add Ons in MARI |
| MPSysImportDefSpaltenRegeln | System Table: Text Field Mapping for data import Extra rules |
| MPSysKundenSprachenMandant | System: Languages linked to SBO company languages |
| MPSysMessages | System: eMail System (Header) |
| MPSysMessagesAttachment | System: eMail System (Attachments) |
| MPSysMessagesAttachmentFilter | System: eMail System (Filter for the Email In module) |
| MPSysReports | Reporting: User Report definition |
| MPVKVertraegeBelegeDruck | Contract Management: Print History |
| MPXcelsiusFiles | Xcelsius: Source Files for one Film |
| MPXcelsiusFilms | Xcelsius: one flash film |