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