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