| Table Name: | MPRessourcenGPKapazitaet |
| View Name: | MARIResourcePoolBPTeamCapacity |
| Group: | Group: ResourcePoolBPTeamCapacity |
| Description: | External Resource Capacity of employees |
| ClassID: | 769. See Overview of ClassIDs by table. |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| GPTeamCodeKapaID | BPTeamCodeCapaID INT Primary |
||
| GPTeamCode | BPTeamCode NVARCHAR (20) Index |
||
| GueltigAb | ValidFrom INT Index |
MPPerioden.PeriodeJahr | |
| GueltigBis | ValidTo INT |
MPPerioden.PeriodeJahr | |
| RessourcenNummer | ResourcePoolID NVARCHAR (20) Index |
MPRessourcenPool.RessourcenNummer | |
| PlanungsTyp | PlanningType SMALLINT |
clsImportPlanning_ePlanningType | |
| Prioritaet | Priority SMALLINT |
||
| Kenntnisse | Knowledge NVARCHAR (200) |
||
| Kapazitaet | Capacity SMALLINT |
||
| Erstanlage | CreateDate Datetime |
||
| ErstanlageID | CreateUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| Aenderung | ChangeDate Datetime |
||
| AenderungID | ChangeUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| Memo | Memo NTEXT |
||
| OptionMemo | OptionMemo NTEXT |
||
| UpdateStamp | UpdateStamp INT |