| Table Name: | MPEquipmentDetails |
| View Name: | MARIEquipmentDetails |
| Group: | Group: Equipment |
| Description: | Equipment: Master Data "date from" based |
| ClassID: | 465. See Overview of ClassIDs by table. |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| EquipmentCode | EquipmentCode NVARCHAR (20) Primary |
MPEquipment.EquipmentCode | |
| ValidFrom | ValidFrom Datetime Primary |
||
| ValidTo | ValidTo Datetime Index |
||
| Status | Status INT |
1=Active,0=Destroyed/broken,2=borrowed/hired | clsImportEquipmentMaster_eEquipmentMasterStatus |
| Quantity | Quantity NUMERIC(19,6) |
Number of Equipment of the same type like 100 shovels | |
| UseSerialNumber | UseSerialNumber SMALLINT (0=false,-1=true) |
||
| BusinessUnit | BusinessUnit INT |
MPSetupGeschaeftsbereich.GeschaeftsbereichID | |
| CompanyID | CompanyID SMALLINT Index |
MPSysConnections.CompanyID (WHERE ConnectionType=6) | |
| Responsible1 | Responsible1 NVARCHAR (20) |
MPPersonenstamm.Personalnummer | |
| Responsible2 | Responsible2 NVARCHAR (20) |
MPPersonenstamm.Personalnummer | |
| DrivingEmployee | DrivingEmployee NVARCHAR (20) |
MPPersonenstamm.Personalnummer | |
| TimeBookingMode | TimeBookingMode INT |
||
| ProfitCenter | ProfitCenter NVARCHAR (20) |
OOCR.OcrCode (WHERE [DimCode]=1) | |
| OcrCode2 | OcrCode2 NVARCHAR (20) |
OOCR.OcrCode (WHERE [DimCode]=2) | |
| OcrCode3 | OcrCode3 NVARCHAR (20) |
OOCR.OcrCode (WHERE [DimCode]=3) | |
| OcrCode4 | OcrCode4 NVARCHAR (20) |
OOCR.OcrCode (WHERE [DimCode]=4) | |
| OcrCode5 | OcrCode5 NVARCHAR (20) |
OOCR.OcrCode (WHERE [DimCode]=5) | |
| ProjectCode | ProjectCode NVARCHAR (20) |
OPRJ.PrjCode | |
| AsstNum | AsstNum NVARCHAR (50) |
OITM.ItemCode (WHERE [ItemType]='F') | |
| VendorCardCode | VendorCardCode NVARCHAR (20) |
ORCD.CardCode | |
| ItemCode | ItemCode NVARCHAR (50) Index |
OITM.ItemCode | |
| WarehouseHandlingMode | WarehouseHandlingMode INT |
||
| WareHouseCode | WareHouseCode NVARCHAR (20) |
OWHS.WhsCode | |
| LocationID | LocationID INT |
MPGruppen.GruppenID (WHERE GruppenArt=10506) | |
| InsuranceID | InsuranceID INT |
MPGruppen.GruppenID (WHERE GruppenArt=10507) | |
| CustomerLocationTreeElementID | CustomerLocationTreeElementID INT Index |
MPCustomerLocationTreeElement.CustomerLocationTreeElementID | |
| CalendarId | CalendarId INT Index |
MPKalender.KalenderID | |
| MaintenanceProject | MaintenanceProject NVARCHAR (20) |
MPProjektstamm.Projektnummer | |
| MaintenanceContractID | MaintenanceContractID INT |
MPVKVertraege.VertragsID | |
| MaintenanceContractPosition | MaintenanceContractPosition INT |
MPVKVertraegePositionen.Vertragsposition | |
| MaintenancePhaseID | MaintenancePhaseID INT |
MPProjektPhasen.PhasenID | |
| HireCardCode | HireCardCode NVARCHAR (20) Index |
OCRD.CardCode | |
| HirePurchaseProcess | HirePurchaseProcess INT |
MPEKVertraege.VertragsID | |
| HirePurchaseProcessPos | HirePurchaseProcessPos INT |
MPEKVertraegePositionen.Vertragsposition | |
| Group1 | Group1 INT |
not used | MPGruppen.GruppenID (WHERE GruppenArt=10503) |
| Group2 | Group2 INT |
not used | MPGruppen.GruppenID (WHERE GruppenArt=10504) |
| Group3 | Group3 INT |
not used | MPGruppen.GruppenID (WHERE GruppenArt=10505) |
| MPLocationID | MPLocationID INT Index |
MPLocation.LocationID | |
| SLA_ID | SLA_ID INT Index |
MPHotlineSLA.SLA_ID | |
| ERPResourceCode | ERPResourceCode NVARCHAR (20) |
ORSC.ResCode | |
| CreateDate | CreateDate Datetime |
||
| CreateUser | CreateUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| ChangeDate | ChangeDate Datetime |
||
| ChangeUser | ChangeUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| UpdateStamp | UpdateStamp INT |