| View Name: | MARIDocuments |
| Based on table: | MPDokumente |
| Group: | |
| Description: | Documents linked in the Folder tabs of the master data |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| DocID | DocID INT Primary |
||
| VersionID | VersionsID INT |
||
| FileName | Datei NVARCHAR (255) |
||
| PathName | Pfad NVARCHAR (255) |
||
| MimeType | MIMETyp NVARCHAR (100) |
||
| Document_type | Document_type NVARCHAR (128) |
file extension .pdf or .gif | |
| Source | Quelle INT Index |
ClassID | |
| CreateDate | Erstanlage Datetime |
||
| CreateUser | ErstanlageID NVARCHAR (4) |
MARIUser.CreateUser (WHERE BenutzerTyp=1) | |
| DocDate | DokumentDatum Datetime |
||
| CheckOutState | CheckOutState INT |
||
| CheckOutUser | CheckOutUser NVARCHAR (4) |
MARIUser.CheckOutUser (WHERE BenutzerTyp=1) | |
| CheckOutDate | CheckOutDate Datetime |
||
| CheckOutMachine | CheckOutMachine NVARCHAR (50) |
||
| CheckOutPathFile | CheckOutPathFile NVARCHAR (255) |
||
| ChangeText | AenderungsText NVARCHAR (255) |
||
| DocumentHashCode | DocumentHash NVARCHAR (32) |
||
| Document | Dokument Image |
||
| ThumbNail | ThumbNail Image |
||
| ThumbHeight | ThumbHeight INT |
||
| ThumbWidth | ThumbWidth INT |
||
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MARIPurchaseProcessDocumentPrint | Purchase Process: Print history |
| MARISupportIssueLine | Support Module: Issue tracking: Issue line for comments, documents, emails, etc. |
| MARISupportProductCustomer | Support Module: Support Product: Customer Product Link |
| MARIProjectItemBooking | 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 |
| MARIProjectTimeKeepingLines | Time Keeping: ProjectTimeKeepingLines: One line per entry of an employee used for each project type |
| MARITravelTripLineDocument | Travel Expenses Module: Trip receipt line (document link for scanned documents) |
| MARIFolderDocuments | Master Data Folder Documents |
| MARISysCustomerLanguagesCompany | System: Languages linked to SBO company languages |
| MARISysMessages | System: eMail System (Header) |
| MARISysMessagesAttachment | System: eMail System (Attachments) |
| MARISysMessagesAttachmentFilter | System: eMail System (Filter for the Email In module) |
| MARISysReports | Reporting: User Report definition |
| MARIContractDocumentPrintHistory | Contract Management: Print History |
| MARISysImportDefColumnsRules | System Table: Text Field Mapping for data import Extra rules |
| MARIEquipmentSubjectBooking | Time/Costbooking on Equipment data |
| MARIXcelsiusFiles | Xcelsius: Source Files for one Film |
| MARIXcelsiusFilms | Xcelsius: one flash film |
| MARIDocumentsVersions | Revision History of a document |
| MARIProjectTimeKeepingReport | Time Keeping: Link Week Report of employee or for customer |
| MARIFolderDocumentTree | Master Data Folder Search Tree |
| MARINewsletterMaster | Newsletter Design Template |
| MARISysAddOns | Manage Programm Add Ons in MARI |
| MARIProjectWorkPackageEntry | Work Packages progress reporting by day |
| MARIBookPageElements | Project Dokumentation: Book Page Content Element |
| MARIBookPageElementArchive | Project Dokumentation: Book Page Content Element Archive |