| Table Name: | MPArbeitspaket |
| View Name: | MARIWorkPackage |
| Group: | |
| Description: | 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 |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| ArbeitspaketNumber | WorkpackageNumber NVARCHAR (20) Primary |
||
| Matchcode | Matchcode NVARCHAR (100) Index |
||
| Dimension | Dimension INT |
||
| BasisEinheitMenge | BaseUnitQuantity NUMERIC(19,6) |
||
| EinheitID | UnitCodeID INT Index |
MPEinheiten.EinheitID | |
| Aufmasstyp | MeasurementType INT |
||
| Gruppe1 | Group1 INT |
MPGruppen.GruppenID (WHERE GruppenArt=10700) | |
| Gruppe2 | Group2 INT |
MPGruppen.GruppenID (WHERE GruppenArt=10701) | |
| Gruppe3 | Group3 INT |
MPGruppen.GruppenID (WHERE GruppenArt=10702) | |
| 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 |
|---|---|
| MPEKVertraegePositionen | Purchase Process: PO Process Position (equivilant to contract position) |
| MPVKVertraegePositionen | Contract Management: Contract positions (also service master positions) |