| Table Name: | MPEinheiten |
| View Name: | MARIUnits |
| Group: | |
| Description: | Unit of measurement basic setting |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| EinheitID | UnitCodeID INT Primary |
OLGT.UnitCode OWGT.UnitCode | |
| EinheitTyp | MeasurementType INT |
||
| EinheitKuerzel | UnitAbbreviation NVARCHAR (10) |
||
| EinheitName | UnitName NVARCHAR (50) |
||
| VolumenBezeichnung | VolumeDesignation NVARCHAR (10) |
||
| FaktorZuMillimeter | Factor2Millimeter NUMERIC(19,6) |
||
| GewichtZuMilligramm | Weight2Milligramm NUMERIC(19,6) |
||
| 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 |
|---|---|
| MPArbeitspaket | Workpackages desribe combinations of time an material, invoice do the customer in qm, cubic meter The table MPVKVertrage with VertragsArt=22 will be used to store the company link The table MPVKVertragePositionen will be used to store the itemcodes/Services and detailed settings |
| MPProjektArbeitspaketerfassungWerte | Work Packages progress reporting by structure element |
| MPProjektAufmassStrukturDimensionen | Measurement strucutre definition: Used dimensions |
| MPProjektAufmassStrukturWerte | Measurement strucutre definition: Measurement values |
| MPVKVertraegePositionenAufmassDimensionen | Contract Position Workpackage definition: Dimension |
| MPVKVertraegePositionenAufmassWerte | Contract Position Workpackage definition: Values |