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