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