| Table Name: | MPEquipmentCategory |
| View Name: | MARIEquipmentCategory |
| Group: | Group: EquipmentCategory |
| Description: | EquipmentCategory: Cagetory Master |
| ClassID: | 222. See Overview of ClassIDs by table. |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| EquipmentCategory | EquipmentCategory INT Primary |
||
| CategoryName | CategoryName NVARCHAR (100) Index |
||
| GroupType1 | GroupType1 INT |
MPGruppen.GruppenID (WHERE GruppenArt=10500) clsImportGroups_eGroupType |
|
| GroupName1 | GroupName1 NVARCHAR (50) |
not used | |
| GroupType2 | GroupType2 INT |
MPGruppen.GruppenID (WHERE GruppenArt=10501) clsImportGroups_eGroupType |
|
| GroupName2 | GroupName2 NVARCHAR (50) |
not used | |
| GroupType3 | GroupType3 INT |
MPGruppen.GruppenID (WHERE GruppenArt=10502) clsImportGroups_eGroupType |
|
| GroupName3 | GroupName3 NVARCHAR (50) |
not used | |
| CreationPrefix | CreationPrefix NVARCHAR (20) |
||
| QuantityUnit | QuantityUnit NVARCHAR (20) |
||
| DefaultEquipmentCode | DefaultEquipmentCode NVARCHAR (20) |
MPEquipment.EquipmentCode | |
| DefaultProject | DefaultProject NVARCHAR (20) |
MPProjektstamm.Projektnummer | |
| AccessMode | AccessMode INT |
clsImportEquipmentCategory_eAccessMode | |
| AccessRead | AccessRead BIGINT |
MPBenutzergruppen.Gruppe (WHERE BenutzerTyp=1) | |
| AccessChange | AccessChange BIGINT |
MPBenutzergruppen.Gruppe (WHERE BenutzerTyp=1) | |
| AccessInsert | AccessInsert BIGINT |
MPBenutzergruppen.Gruppe (WHERE BenutzerTyp=1) | |
| AccessDelete | AccessDelete BIGINT |
MPBenutzergruppen.Gruppe (WHERE BenutzerTyp=1) | |
| AccessAll | AccessAll BIGINT |
MPBenutzergruppen.Gruppe (WHERE BenutzerTyp=1) | |
| CustomerAccessMode | CustomerAccessMode BIGINT |
MPBenutzergruppen.Gruppe (WHERE BenutzerTyp=2) clsImportEquipmentCategory_eAccessMode |
|
| CustomerAccessRead | CustomerAccessRead BIGINT |
MPBenutzergruppen.Gruppe (WHERE BenutzerTyp=2) | |
| CustomerAccessChange | CustomerAccessChange BIGINT |
MPBenutzergruppen.Gruppe (WHERE BenutzerTyp=2) | |
| CustomerAccessInsert | CustomerAccessInsert BIGINT |
MPBenutzergruppen.Gruppe (WHERE BenutzerTyp=2) | |
| CustomerAccessDelete | CustomerAccessDelete BIGINT |
MPBenutzergruppen.Gruppe (WHERE BenutzerTyp=2) | |
| CustomerAccessAll | CustomerAccessAll BIGINT |
MPBenutzergruppen.Gruppe (WHERE BenutzerTyp=2) | |
| IconPictureID | IconPictureID INT |
MPBilder.BildID | |
| HandleQuantity | HandleQuantity SMALLINT (0=false,-1=true) |
||
| DefaultCompanyID | DefaultCompanyID SMALLINT Index |
MPSysConnections.CompanyID (WHERE ConnectionType=6) | |
| DefaultItemCode | DefaultItemCode NVARCHAR (50) Index |
OITM.ItemCode | |
| SLA_ID | SLA_ID INT Index |
MPHotlineSLA.SLA_ID | |
| ViewPort | ViewPort INT |
||
| ViewPortCustomerID | ViewPortCustomerID INT Index |
||
| ERPResourceCode | ERPResourceCode NVARCHAR (20) |
ORSC.ResCode | |
| 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 |
| MPEKVertraegePositionen | Purchase Process: PO Process Position (equivilant to contract position) |
| MPEquipment | Equipment: Master Data for each individual Equipment |
| MPEquipmentCategoryBPCatalog | EquipmentCategory: Business Partner Catalog Number |
| MPEquipmentCategorySubject | EquipmentCategory: Standard cost types for categories |
| MPOnlineCatalogTreeElementContent | OnlineCatalogTree: rules to biuld one line |
| MPVKVertraegePositionen | Contract Management: Contract positions (also service master positions) |
| MPWorkItemPosition | Positions for Service Task, Internal Service Task, Result Task, Serice Plan, Qualification (Plan+Task), AP Audit (+Plan+Task), Training Cource |