| View Name: | MARICustomerServiceObjectCategory |
| Based on table: | MPCustomerEquipmentCardCategory |
| Group: | Group: CustomerServiceObject |
| Description: | Group to manage properties by group |
| ClassID: | 385. See Overview of ClassIDs by table. |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| CECGroupID | CECGroupID INT Primary |
||
| CompanyID | CompanyID INT Index |
MARISysConnections.CompanyID (WHERE ConnectionType=6) | |
| CECGroupName | CECGroupName NVARCHAR (100) Index |
||
| Indent | Indent INT |
||
| Parent | Parent INT |
||
| BranchType | BranchType SMALLINT |
||
| PositionID | PositionID SMALLINT |
||
| GroupMemo | GruppenMemo NTEXT |
||
| ViewPortID | ViewPortID INT |
||
| ViewPortCustomerID | ViewPortCustomerID INT Index |
||
| NumberSeriesManufSN | NumberSeriesManufSN NVARCHAR (8) |
||
| NumberSeriesInternalSN | NumberSeriesInternalSN NVARCHAR (8) |
||
| AccessMode | AccessMode INT |
||
| 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 |
||
| 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) | |
| ProductID | ProduktID INT Index |
MARISupportProduct.ProductID | |
| ProductModuleID | ProduktModulID INT Index |
MARISupportProductModules.ProductModuleID | |
| OptionMemo | OptionMemo NTEXT |
||
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MARIItemGroupProperties | Item Groups: Additional fields for maintenance and purchase order |
| MARIItemProperties | Item Master: Additional fields for maintenance and purchase order |
| MARICustomerServiceObject | Advanced table to sbo standard customer equipment card |