| Table Name: | MPWorkItemResources |
| View Name: | MARIWorkItemResources |
| Group: | Group: WorkItem |
| Description: | Employees or Equipment necessary for the tasks |
| ClassID: | 372. See Overview of ClassIDs by table. |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| WorkItemResourceID | WorkItemResourceID INT Primary |
||
| WorkItemID | WorkItemID INT Index |
MPWorkItem.WorkItemID | |
| ResourceKey | ResourceKey NVARCHAR (20) |
||
| ResourceType | ResourceType INT |
||
| ResourceInfoText | ResourceInfoText NVARCHAR (50) |
||
| TravelExpenseTrip | TravelExpenseTrip INT |
||
| Quantity | Quantity INT |
||
| ContractPosition | ContractPositionID INT |
MPVKVertraegePositionen.Vertragsposition | |
| ContractPositionType | ContractPositionType INT |
101=item at fixed price | |
| ResourceOrder | ResourceOrder INT |
||
| ResourceGroup | ResourceGroup INT |
GrupenArt=10680 | MPGruppen.GruppenID (WHERE GrupenArt=10680) |
| Memo | Memo NTEXT |
||
| Link1 | Link1 NVARCHAR (20) |
||
| Option1 | Option1 INT |
||
| Option2 | Option2 INT |