| Table Name: | MPLeistungPool |
| View Name: | MARIServicePools |
| Group: | Group: Services |
| Description: | Service Master: Master Data Pool link |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| Leistungsnummer | ServiceNumber NVARCHAR (20) Primary |
MPLeistung.Leistungsnummer | |
| RessourcenNummer | ResourcePoolID NVARCHAR (20) Primary |
MPRessourcenPool.RessourcenNummer | |
| PlanungsTyp | PlanningType SMALLINT |
||
| Prioritaet | Priority SMALLINT |
||
| Erstanlage | CreateDate Datetime |
||
| Aenderung | ChangeDate Datetime |
||
| AenderungID | ChangeUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| OptionMemo | OptionMemo NTEXT |
||
| UpdateStamp | UpdateStamp INT |