| View Name: | MARIUnits |
| Based on table: | MPEinheiten |
| Group: | |
| Description: | Unit of measurement basic setting |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| UnitCodeID | EinheitID INT Primary |
OLGT.UnitCode OWGT.UnitCode | |
| MeasurementType | EinheitTyp INT |
||
| UnitAbbreviation | EinheitKuerzel NVARCHAR (10) |
||
| UnitName | EinheitName NVARCHAR (50) |
||
| VolumeDesignation | VolumenBezeichnung NVARCHAR (10) |
||
| Factor2Millimeter | FaktorZuMillimeter NUMERIC(19,6) |
||
| Weight2Milligramm | GewichtZuMilligramm NUMERIC(19,6) |
||
| 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 |
|---|---|
| MARIWorkPackage | 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 |
| MARIProjectWorkPackageEntryValues | Work Packages progress reporting by structure element |
| MARIProjectMeasurementStructureDimension | Measurement strucutre definition: Used dimensions |
| MARIProjectMeasurementStructureValues | Measurement strucutre definition: Measurement values |
| MARIContractPositionMeasurementDimension | Contract Position Workpackage definition: Dimension |
| MARIContractPositionMeasurementValues | Contract Position Workpackage definition: Values |