| Table Name: | MPSetupMengenFormel |
| View Name: | MARISetupQuantityFormular |
| Group: | |
| Description: | Quantity Formular Head |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| MengenFormelID | QuantityFormularID INT Primary |
||
| FormelBezeichnung | FormularDescription NVARCHAR (100) |
||
| FormelMode | FormularMode SMALLINT |
||
| Mandant | Company SMALLINT |
MPSysConnections.CompanyID (WHERE ConnectionType=6) | |
| Druckanzeige | PrintField NTEXT |
||
| Ikone | Icon INT |
||
| AnzahlEinheit | QuantityCountUnit NVARCHAR (20) |
||
| ZaehleinheitAnzahl | LaodByQuantityCount SMALLINT (0=false,-1=true) |
||
| GruppenID | GroupID INT Index |
||
| Memo | Memo NTEXT |
||
| InAktiv | Inactive SMALLINT (0=false,-1=true) Index |
||
| Erstanlage | CreateDate Datetime |
||
| ErstanlageID | CreateUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| Aenderung | ChangeDate Datetime |
||
| AenderungID | ChangeUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MPArtikelGruppenKennzeichen | Item Groups: Additional fields for maintenance and purchase order |
| MPArtikelKennzeichen | Item Master: Additional fields for maintenance and purchase order |
| MPEKVertraegeBelegePositionen | Purchase Process: Purchase Document (Positions) |
| MPEKVertraegePositionen | Purchase Process: PO Process Position (equivilant to contract position) |
| 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 |
| MPSetupMengenFormelFelder | Quantity Formular Lines |
| MPTmpRptPrintPositionen | Reporting: Temporary Table: Document Positions |
| MPVKVertraegeBelegePositionen | Contract Management: Document Positions |
| MPVKVertraegePositionen | Contract Management: Contract positions (also service master positions) |