| View Name: | MARIResourcePoolBPTeam |
| Based on table: | MPRessourcenGPTeam |
| Group: | Group: ResourcePoolBPTeamCapacity |
| 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 | |
| CardCodeAddressLineNum | CardCodeAdressLineNum INT |
CRD1.LineNum | |
| Responsible | Verantwortlicher NVARCHAR (20) |
See MPRessourcenGBTeamLeitung | MARIEmployeeMaster.Responsible |
| SecondManager | Vertreter NVARCHAR (20) |
See MPRessourcenGBTeamLeitung | MARIEmployeeMaster.SecondManager |
| PlanCapacity | Plankapazitaet NUMERIC(19,6) |
||
| PurchaseItem | Einkaufsartikel NVARCHAR (50) |
OITM.ItemCode | |
| GroupID1 | GruppenID1 INT |
MARIGroups.GroupID1 (WHERE Gruppenart=10706) | |
| GroupID2 | GruppenID2 INT |
MARIGroups.GroupID2 (WHERE Gruppenart=10707) | |
| GroupID3 | GruppenID3 INT |
MARIGroups.GroupID3 (WHERE Gruppenart=10708) | |
| 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) | |
| Inactive | InAktiv SMALLINT (0=false,-1=true) Index |
||
| Memo | Memo NTEXT |
||
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MARIResourcePoolBPTeamManager | External Resource Management |
| MARIResourcePoolBPTeamCapacity | External Resource Capacity of employees |
| MARIResourcePoolBPTeamCostRates | Cost rates for external resource team |
| MARIResourcePoolBPTeamLink | Link between resource pool and external resource team |