| View Name: | MARIEquipmentCategory |
| Based on table: | MPEquipmentCategory |
| Group: | Group: EquipmentCategory |
| Description: | EquipmentCategory: Cagetory Master |
| ClassID: | 222. See Overview of ClassIDs by table. |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| EquipmentCategory | EquipmentCategory INT Primary |
||
| CategoryName | CategoryName NVARCHAR (100) Index |
||
| GroupType1 | GroupType1 INT |
MARIGroups.GroupType1 (WHERE GruppenArt=10500) clsImportGroups_eGroupType |
|
| GroupName1 | GroupName1 NVARCHAR (50) |
not used | |
| GroupType2 | GroupType2 INT |
MARIGroups.GroupType2 (WHERE GruppenArt=10501) clsImportGroups_eGroupType |
|
| GroupName2 | GroupName2 NVARCHAR (50) |
not used | |
| GroupType3 | GroupType3 INT |
MARIGroups.GroupType3 (WHERE GruppenArt=10502) clsImportGroups_eGroupType |
|
| GroupName3 | GroupName3 NVARCHAR (50) |
not used | |
| CreationPrefix | CreationPrefix NVARCHAR (20) |
||
| QuantityUnit | QuantityUnit NVARCHAR (20) |
||
| DefaultEquipmentCode | DefaultEquipmentCode NVARCHAR (20) |
MARIEquipmentMaster.DefaultEquipmentCode | |
| DefaultProject | DefaultProject NVARCHAR (20) |
MARIProjectMaster.DefaultProject | |
| AccessMode | AccessMode INT |
clsImportEquipmentCategory_eAccessMode | |
| AccessRead | AccessRead BIGINT |
MARIUserGroups.AccessRead (WHERE BenutzerTyp=1) | |
| AccessChange | AccessChange BIGINT |
MARIUserGroups.AccessChange (WHERE BenutzerTyp=1) | |
| AccessInsert | AccessInsert BIGINT |
MARIUserGroups.AccessInsert (WHERE BenutzerTyp=1) | |
| AccessDelete | AccessDelete BIGINT |
MARIUserGroups.AccessDelete (WHERE BenutzerTyp=1) | |
| AccessAll | AccessAll BIGINT |
MARIUserGroups.AccessAll (WHERE BenutzerTyp=1) | |
| CustomerAccessMode | CustomerAccessMode BIGINT |
MARIUserGroups.CustomerAccessMode (WHERE BenutzerTyp=2) clsImportEquipmentCategory_eAccessMode |
|
| CustomerAccessRead | CustomerAccessRead BIGINT |
MARIUserGroups.CustomerAccessRead (WHERE BenutzerTyp=2) | |
| CustomerAccessChange | CustomerAccessChange BIGINT |
MARIUserGroups.CustomerAccessChange (WHERE BenutzerTyp=2) | |
| CustomerAccessInsert | CustomerAccessInsert BIGINT |
MARIUserGroups.CustomerAccessInsert (WHERE BenutzerTyp=2) | |
| CustomerAccessDelete | CustomerAccessDelete BIGINT |
MARIUserGroups.CustomerAccessDelete (WHERE BenutzerTyp=2) | |
| CustomerAccessAll | CustomerAccessAll BIGINT |
MARIUserGroups.CustomerAccessAll (WHERE BenutzerTyp=2) | |
| IconPictureID | IconPictureID INT |
MARIPictures.IconPictureID | |
| HandleQuantity | HandleQuantity SMALLINT (0=false,-1=true) |
||
| DefaultCompanyID | DefaultCompanyID SMALLINT Index |
MARISysConnections.DefaultCompanyID (WHERE ConnectionType=6) | |
| DefaultItemCode | DefaultItemCode NVARCHAR (50) Index |
OITM.ItemCode | |
| SLA_ID | SLA_ID INT Index |
MARISupportSLA.SLA_ID | |
| ViewPort | ViewPort INT |
||
| ViewPortCustomerID | ViewPortCustomerID INT Index |
||
| ERPResourceCode | ERPResourceCode NVARCHAR (20) |
ORSC.ResCode | |
| 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 |
|---|---|
| MARIPurchaseProcessPositions | Purchase Process: PO Process Position (equivilant to contract position) |
| MARIContractPositions | Contract Management: Contract positions (also service master positions) |
| MARIEquipmentMaster | Equipment: Master Data for each individual Equipment |
| MARIEquipmentCategorySubject | EquipmentCategory: Standard cost types for categories |
| MARIDocumentDraftPosition | Positions based on the order of the paper document |
| MARIDocumentDraftPositionLink | Linked positions in the sales contract and or purchase process |
| MARIWorkItemPosition | Positions for Service Task, Internal Service Task, Result Task, Serice Plan, Qualification (Plan+Task), AP Audit (+Plan+Task), Training Cource |
| MARIEquipmentCategoryBPCatalog | EquipmentCategory: Business Partner Catalog Number |
| MARIOnlineCatalogTreeElementContent | OnlineCatalogTree: rules to biuld one line |