| View Name: | MARISetupQuantityFormular |
| Based on table: | MPSetupMengenFormel |
| Group: | |
| Description: | Quantity Formular Head |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| QuantityFormularID | MengenFormelID INT Primary |
||
| FormularDescription | FormelBezeichnung NVARCHAR (100) |
||
| FormularMode | FormelMode SMALLINT |
||
| Company | Mandant SMALLINT |
MARISysConnections.Company (WHERE ConnectionType=6) | |
| PrintField | Druckanzeige NTEXT |
||
| Icon | Ikone INT |
||
| QuantityCountUnit | AnzahlEinheit NVARCHAR (20) |
||
| LaodByQuantityCount | ZaehleinheitAnzahl SMALLINT (0=false,-1=true) |
||
| GroupID | GruppenID INT Index |
||
| Memo | Memo NTEXT |
||
| Inactive | InAktiv SMALLINT (0=false,-1=true) Index |
||
| CreateDate | Erstanlage Datetime |
||
| CreateUser | ErstanlageID NVARCHAR (4) |
MARIUser.CreateUser (WHERE BenutzerTyp=1) | |
| ChangeDate | Aenderung Datetime |
||
| ChangeUser | AenderungID NVARCHAR (4) |
MARIUser.ChangeUser (WHERE BenutzerTyp=1) | |
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MARIItemGroupProperties | Item Groups: Additional fields for maintenance and purchase order |
| MARIItemProperties | Item Master: Additional fields for maintenance and purchase order |
| MARIPurchaseProcessDocumentPositions | Purchase Process: Purchase Document (Positions) |
| MARIPurchaseProcessPositions | Purchase Process: PO Process Position (equivilant to contract position) |
| 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 |
| MARITempReportDocumentPos | Reporting: Temporary Table: Document Positions |
| MARIContractDocumentPositions | Contract Management: Document Positions |
| MARIContractPositions | Contract Management: Contract positions (also service master positions) |
| MARISetupQuantityFormularField | Quantity Formular Lines |