| Table Name: | MPRessourcenGPTeam |
| View Name: | MARIResourcePoolBPTeam |
| Group: | |
| Description: | External resource team (Supplier, customer) |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| GPTeamCode | BPTeamCode NVARCHAR (20) Primary |
||
| GPTeamType | BPTeamType INT Index |
||
| Bezeichnung | Description NVARCHAR (50) Index |
||
| Mandant | Company SMALLINT Index |
MPSysConnections.CompanyID (WHERE ConnectionType=6) | |
| CardCode | CardCode NVARCHAR (20) Index |
OCRD.CardCode | |
| Verantwortlicher | Responsible NVARCHAR (20) |
MPPersonenstamm.Personalnummer | |
| Vertreter | SecondManager NVARCHAR (20) |
MPPersonenstamm.Personalnummer | |
| Plankapazitaet | PlanCapacity NUMERIC(19,6) |
||
| Einkaufsartikel | PurchaseItem NVARCHAR (50) |
OITM.ItemCode | |
| GruppenID1 | GroupID1 INT |
||
| GruppenID2 | GroupID2 INT |
||
| GruppenID3 | GroupID3 INT |
||
| AnsprechpartnerID | ContactPerson INT |
OCPR.CntctCode | |
| eMail NVARCHAR (200) |
|||
| Ikone | Icon INT |
||
| Farbe | Color INT |
||
| Erstanlage | CreateDate Datetime |
||
| ErstanlageID | CreateUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| Aenderung | ChangeDate Datetime |
||
| AenderungID | ChangeUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| InAktiv | InAktiv SMALLINT (0=false,-1=true) Index |
||
| Memo | Memo NTEXT |
||
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MPRessourcenGPTeamKostensaetze | Cost rates for external resource team |
| MPRessourcenGPTeamLink | Link between resource pool and external resource team |