| Table Name: | MPEquipment |
| View Name: | MARIEquipmentMaster |
| Group: | Group: Equipment |
| Description: | Equipment: Master Data for each individual Equipment |
| ClassID: | 223. See Overview of ClassIDs by table. |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| EquipmentCode | EquipmentCode NVARCHAR (20) Primary |
||
| EquipmentType | EquipmentType INT |
Distinguish between EquipmentMaster223, Equipment Qty>1=451, EquipmentAssembly=452 | clsImportEquipmentMaster_eEquipmentMasterType |
| EquipmentCategory | EquipmentCategory INT Index |
MPEquipmentCategory.EquipmentCategory | |
| EquipmentName | EquipmentName NVARCHAR (100) Index |
||
| EquipmentIdentification | EquipmentIdentification NVARCHAR (50) |
||
| InventoryID | InventoryID NVARCHAR (50) |
||
| Group1 | Group1 INT |
MPGruppen.GruppenID (WHERE GruppenArt=10503) clsImportGroups_eGroupType |
|
| Group2 | Group2 INT |
MPGruppen.GruppenID (WHERE GruppenArt=10504) clsImportGroups_eGroupType |
|
| Group3 | Group3 INT |
MPGruppen.GruppenID (WHERE GruppenArt=10505) clsImportGroups_eGroupType |
|
| SerialNumber | SerialNumber NVARCHAR (50) |
||
| BuildInYear | BuildInYear SMALLINT |
||
| DateInCompany | DateInCompany Datetime |
||
| DateOutCompany | DateOutCompany Datetime |
||
| ServicePlanOverAllStatus | ServicePlanOverAllStatus INT |
||
| ServicePlanOverAllNextRelevantDate | ServicePlanOverAllNextRelevantDate Datetime |
||
| ServicePlanOverAllRef2NextRelevantPlan | ServicePlanOverAllRef2NextRelevantPlan INT |
MPWorkItem.WorkItemID | |
| PictureID | PictureID INT |
MPBilder.BildID | |
| ProduktID | ProduktID INT Index |
MPHotlineProdukt.ProduktID | |
| ProduktModulID | ProduktModulID INT Index |
MPHotlineProduktModul.ProduktModulID | |
| CreateDate | CreateDate Datetime |
||
| CreateUser | CreateUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| ChangeDate | ChangeDate Datetime |
||
| ChangeUser | ChangeUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| Memo | Memo NTEXT |
||
| MemoLevel | MemoLevel SMALLINT |
||
| InActive | Inactive SMALLINT (0=false,-1=true) |
Hide dataset | |
| HidePageFlag | HidePageFlag BIGINT |
||
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MPDocumentDraftPosition | Positions based on the order of the paper document |
| MPDocumentDraftPositionLink | Linked positions in the sales contract and or purchase process |
| MPDocumentDraftPositionLinkBatch | Used batches |
| MPDocumentDraftPositionLinkSerial | Used/reserved serial numbers |
| MPEKVertraegeBelegePositionenCharge | Purchase Process: Purchase Document (Positions+Batches) |
| MPEKVertraegeBelegePositionenSerie | Purchase Process: Purchase Document (Positions+Serial) |
| MPEKVertraegePos2Service | Purchase Process: Link Position to Customer Service Object or parts |
| MPEKVertraegePositionenEquipment | Purchase Process: Equipment linked to a position |
| MPEquipmentCategory | EquipmentCategory: Cagetory Master |
| MPEquipmentDetails | Equipment: Master Data "date from" based |
| MPEquipmentDetailsLink | Equipment Assembly: List of inner components |
| MPEquipmentDetailsSerial | Equipment: Master Data "Date from" based serial numbers |
| MPEquipmentLocation | Equipment: Current Location of this equipment |
| MPEquipmentReminder | Equipment: recurrent dates for each equipment |
| MPEquipmentSubjectBooking | Time/Costbooking on Equipment data |
| MPEquipmentSubjectRates | Equipment: Specific cost rates |
| MPEquipmentSubjectRatesBU | Equipment: Specific cost and sales rates for internal service charges |
| MPHotlineProduktKunde | Support Module: Support Product: Customer Product Link |
| MPOnlineCatalogTreeElementContent | OnlineCatalogTree: rules to biuld one line |
| MPProjektArbeitspaketerfassung | Work Packages progress reporting by day |
| MPProjektArtikelerfassung | Time Keeping: ProjectTimeKeepingItems: For items used in a project each entry is stored in this table. This table is also linked to the header: MPProjectBuchungskopf |
| MPProjektLeistungserfassung | Time Keeping: ProjectTimeKeepingLinesServices: additional lines for the MPProjectBuchungserfassung for the project types: customer project and internal project with contract. This table stores the link to the contract and contract position |
| MPReise2ZeileProjekt | Travel Expenses Module: Trip receipt project line for invoice |
| MPTmpRptPrintPositionenSerien | Reporting: Temporary Table: Document Positions Serial Numbers |
| MPVKVertraegeBelegePositionenCharge | Contract Management: Document Positions Batches |
| MPVKVertraegeBelegePositionenSerie | Contract Management: Document Positions Serial Numbers |
| MPVKVertraegePos2Service | Contract Management: Contract position to Customer Service Object and parts |
| MPVKVertraegePositionenEquipment | Contract Management: Link an equipment to the contract position |
| MPWorkItemPosition | Positions for Service Task, Internal Service Task, Result Task, Serice Plan, Qualification (Plan+Task), AP Audit (+Plan+Task), Training Cource |
| MPWorkItemPositionSerial | Serialnumbers, Batchnumbers for work item positions |