| View Name: | MARIServices |
| Based on table: | MPLeistung |
| 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 | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| ServiceNumber | Leistungsnummer NVARCHAR (20) Primary |
||
| Matchcode | Matchcode NVARCHAR (50) Index |
||
| ServiceGroup1 | Gruppe INT |
MARIGroups.ServiceGroup1 (WHERE GruppenArt=10004) clsImportGroups_eGroupType |
|
| ServiceGroup2 | Gruppe2 INT |
MARIGroups.ServiceGroup2 (WHERE GruppenArt=10043) clsImportGroups_eGroupType |
|
| ServiceGroup3 | Gruppe3 INT |
MARIGroups.ServiceGroup3 (WHERE GruppenArt=10044) clsImportGroups_eGroupType |
|
| OptionMemo | OptionMemo NTEXT |
||
| StandardPhase | Standardphase NVARCHAR (40) |
MARIProjectPhases.StandardPhase | |
| Inactive | InAktiv SMALLINT (0=false,-1=true) Index |
Hide dataset | |
| 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) |
| MARIServicePools | Service Master: Master Data Pool link |
| MARIEmployeesService | Employee Master: Linked services |
| MARIProjectPlanningLines | Planning: Master Planning lines |
| MARIContractPositions | Contract Management: Contract positions (also service master positions) |
| MARIEquipmentCategorySubject | EquipmentCategory: Standard cost types for categories |
| MARIEquipmentSubjectRates | Equipment: Specific cost rates |
| MARIDocumentDraftPosition | Positions based on the order of the paper document |
| MARIWorkItemPosition | Positions for Service Task, Internal Service Task, Result Task, Serice Plan, Qualification (Plan+Task), AP Audit (+Plan+Task), Training Cource |
| MARIProjectPlanningLinesLog | Planning: Master Planning lines History |