| View Name: | MARIEquipmentMaster |
| Based on table: | MPEquipment |
| Group: | Group: Equipment |
| Description: | Equipment: Master Data for each individual Equipment |
| ClassID: | 223. See Overview of ClassIDs by table. |
| Field | Table(Germ.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 |
MARIEquipmentCategory.EquipmentCategory | |
| EquipmentName | EquipmentName NVARCHAR (100) Index |
||
| EquipmentIdentification | EquipmentIdentification NVARCHAR (50) |
||
| InventoryID | InventoryID NVARCHAR (50) |
||
| Group1 | Group1 INT |
MARIGroups.Group1 (WHERE GruppenArt=10503) clsImportGroups_eGroupType |
|
| Group2 | Group2 INT |
MARIGroups.Group2 (WHERE GruppenArt=10504) clsImportGroups_eGroupType |
|
| Group3 | Group3 INT |
MARIGroups.Group3 (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 |
MARIWorkItem.ServicePlanOverAllRef2NextRelevantPlan | |
| PictureID | PictureID INT |
MARIPictures.PictureID | |
| ProduktID | ProduktID INT Index |
MARISupportProduct.ProduktID | |
| ProduktModulID | ProduktModulID INT Index |
MARISupportProductModules.ProduktModulID | |
| CreateDate | CreateDate Datetime |
||
| CreateUser | CreateUser NVARCHAR (4) |
MARIUser.CreateUser (WHERE BenutzerTyp=1) | |
| ChangeDate | ChangeDate Datetime |
||
| ChangeUser | ChangeUser NVARCHAR (4) |
MARIUser.ChangeUser (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 |
|---|---|
| MARISupportProductCustomer | Support Module: Support Product: Customer Product Link |
| MARIProjectItemBooking | 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 |
| MARIProjectTimeKeepingLinesServices | 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 |
| MARITravelTripLineProject | Travel Expenses Module: Trip receipt project line for invoice |
| MARITempReportDocumentPosSerialNumbers | Reporting: Temporary Table: Document Positions Serial Numbers |
| MARIPurchaseProcessPositionEquipment | Purchase Process: Equipment linked to a position |
| MARIEquipmentCategory | EquipmentCategory: Cagetory Master |
| MARIEquipmentDetails | Equipment: Master Data "date from" based |
| MARIEquipmentReminder | Equipment: recurrent dates for each equipment |
| MARIEquipmentSubjectBooking | Time/Costbooking on Equipment data |
| MARIEquipmentSubjectRates | Equipment: Specific cost rates |
| MARIEquipmentSubjectRatesBU | Equipment: Specific cost and sales rates for internal service charges |
| MARIContractPositionEquipment | Contract Management: Link an equipment to the contract position |
| MARIPurchaseProcessDocumentPositionsSerialNumbers | Purchase Process: Purchase Document (Positions+Serial) |
| MARIContractDocumentPositionsSerialNumbers | Contract Management: Document Positions Serial Numbers |
| MARIEquipmentLocation | Equipment: Current Location of this equipment |
| MARIDocumentDraftPosition | Positions based on the order of the paper document |
| MARIDocumentDraftPositionLink | Linked positions in the sales contract and or purchase process |
| MARIDocumentDraftPositionLinkBatch | Used batches |
| MARIDocumentDraftPositionLinkSerial | Used/reserved serial numbers |
| MARIPurchaseProcessDocumentPositionsBatches | Purchase Process: Purchase Document (Positions+Batches) |
| MARIContractDocumentPositionsBatches | Contract Management: Document Positions Batches |
| MARIEquipmentDetailsSerial | Equipment: Master Data "Date from" based serial numbers |
| MARIWorkItemPosition | Positions for Service Task, Internal Service Task, Result Task, Serice Plan, Qualification (Plan+Task), AP Audit (+Plan+Task), Training Cource |
| MARIWorkItemPositionSerial | Serialnumbers, Batchnumbers for work item positions |
| MARIPurchaseProcessPos2Service | Purchase Process: Link Position to Customer Service Object or parts |
| MARIContractPosition2Service | Contract Management: Contract position to Customer Service Object and parts |
| MARIEquipmentDetailsLink | Equipment Assembly: List of inner components |
| MARIOnlineCatalogTreeElementContent | OnlineCatalogTree: rules to biuld one line |
| MARIProjectWorkPackageEntry | Work Packages progress reporting by day |