| Table Name: | MPLeistung |
| View Name: | MARIServices |
| Group: | Group: Services |
| Description: | Service Master: Master Data Header Line (Without company assignment) The table MPVKVertrage with VertragsArt=6 will be used to store the company link The table MPVKVertragePositionen will be used to store the itemcodes and detailed settings |
| ClassID: | 68. See Overview of ClassIDs by table. |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| Leistungsnummer | ServiceNumber NVARCHAR (20) Primary |
||
| Matchcode | Matchcode NVARCHAR (50) Index |
||
| Gruppe | ServiceGroup1 INT |
MPGruppen.GruppenID (WHERE GruppenArt=10004) clsImportGroups_eGroupType |
|
| Gruppe2 | ServiceGroup2 INT |
MPGruppen.GruppenID (WHERE GruppenArt=10043) clsImportGroups_eGroupType |
|
| Gruppe3 | ServiceGroup3 INT |
MPGruppen.GruppenID (WHERE GruppenArt=10044) clsImportGroups_eGroupType |
|
| OptionMemo | OptionMemo NTEXT |
||
| Standardphase | StandardPhase NVARCHAR (40) |
MPProjektPhasen.PhasenID | |
| InAktiv | Inactive SMALLINT (0=false,-1=true) Index |
Hide dataset | |
| 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 |
|---|---|
| MPDocumentDraftPosition | Positions based on the order of the paper document |
| MPEKVertraegePositionen | Purchase Process: PO Process Position (equivilant to contract position) |
| MPEquipmentCategorySubject | EquipmentCategory: Standard cost types for categories |
| MPEquipmentSubjectRates | Equipment: Specific cost rates |
| MPLeistungPool | Service Master: Master Data Pool link |
| MPPersonenLeistungen | Employee Master: Linked services |
| MPProjektPlanungsZeilen | Planning: Master Planning lines |
| MPProjektPlanungsZeilenLog | Planning: Master Planning lines History |
| MPVKVertraegePositionen | Contract Management: Contract positions (also service master positions) |
| MPWorkItemPosition | Positions for Service Task, Internal Service Task, Result Task, Serice Plan, Qualification (Plan+Task), AP Audit (+Plan+Task), Training Cource |