| View Name: | MARIEquipmentDetails |
| Based on table: | MPEquipmentDetails |
| Group: | Group: Equipment |
| Description: | Equipment: Master Data "date from" based |
| ClassID: | 465. See Overview of ClassIDs by table. |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| EquipmentCode | EquipmentCode NVARCHAR (20) Primary |
MARIEquipmentMaster.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 |
MARIBusinessUnitMaster.BusinessUnit | |
| CompanyID | CompanyID SMALLINT Index |
MARISysConnections.CompanyID (WHERE ConnectionType=6) | |
| Responsible1 | Responsible1 NVARCHAR (20) |
MARIEmployeeMaster.Responsible1 | |
| Responsible2 | Responsible2 NVARCHAR (20) |
MARIEmployeeMaster.Responsible2 | |
| DrivingEmployee | DrivingEmployee NVARCHAR (20) |
MARIEmployeeMaster.DrivingEmployee | |
| 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 |
MARIGroups.LocationID (WHERE GruppenArt=10506) | |
| InsuranceID | InsuranceID INT |
MARIGroups.InsuranceID (WHERE GruppenArt=10507) | |
| CustomerLocationTreeElementID | CustomerLocationTreeElementID INT Index |
MARICustomerLocationTreeElement.CustomerLocationTreeElementID | |
| CalendarId | CalendarId INT Index |
MARICalendar.CalendarId | |
| MaintenanceProject | MaintenanceProject NVARCHAR (20) |
MARIProjectMaster.MaintenanceProject | |
| MaintenanceContractID | MaintenanceContractID INT |
MARIContract.MaintenanceContractID | |
| MaintenanceContractPosition | MaintenanceContractPosition INT |
MARIContractPositions.MaintenanceContractPosition | |
| MaintenancePhaseID | MaintenancePhaseID INT |
MARIProjectPhases.MaintenancePhaseID | |
| HireCardCode | HireCardCode NVARCHAR (20) Index |
OCRD.CardCode | |
| HirePurchaseProcess | HirePurchaseProcess INT |
MARIPurchaseProcess.HirePurchaseProcess | |
| HirePurchaseProcessPos | HirePurchaseProcessPos INT |
MARIPurchaseProcessPositions.HirePurchaseProcessPos | |
| Group1 | Group1 INT |
not used | MARIGroups.Group1 (WHERE GruppenArt=10503) |
| Group2 | Group2 INT |
not used | MARIGroups.Group2 (WHERE GruppenArt=10504) |
| Group3 | Group3 INT |
not used | MARIGroups.Group3 (WHERE GruppenArt=10505) |
| MPLocationID | MPLocationID INT Index |
MARILocation.MPLocationID | |
| SLA_ID | SLA_ID INT Index |
MARISupportSLA.SLA_ID | |
| ERPResourceCode | ERPResourceCode NVARCHAR (20) |
ORSC.ResCode | |
| CreateDate | CreateDate Datetime |
||
| CreateUser | CreateUser NVARCHAR (4) |
MARIUser.CreateUser (WHERE BenutzerTyp=1) | |
| ChangeDate | ChangeDate Datetime |
||
| ChangeUser | ChangeUser NVARCHAR (4) |
MARIUser.ChangeUser (WHERE BenutzerTyp=1) | |
| UpdateStamp | UpdateStamp INT |