| Table Name: | MPHotlineProduktModul |
| View Name: | MARISupportProductModules |
| Group: | Group: SupportProduct |
| Description: | Support Module: Support Product: Master Data Modules |
| ClassID: | 105. See Overview of ClassIDs by table. |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| ProduktID | ProductID INT Primary |
MPHotlineProdukt.ProduktID | |
| ProduktModulID | ProductModuleID INT Primary |
||
| ProduktModulTyp | Type INT |
0=Normal,1=Sub module, 2=customer module | |
| ProduktModul | ProductModule NVARCHAR (50) Index |
||
| Reihenfolge | ModuleOrder INT |
||
| Indent | Indent INT |
||
| ParentProduktModulID | ParentProductModulID INT Index |
MPHotlineProduktModul.ProduktID | |
| Beschreibung | Description NTEXT |
||
| KundeMandant | CustomerCompany SMALLINT Index |
Company Customer | MPSysConnections.CompanyID (WHERE ConnectionType=6) |
| KundeCardCode | CustomerCardCode NVARCHAR (20) Index |
OCRD.CardCode | |
| ArtikelMandant | ItemCompany INT |
Company Item | MPSysConnections.CompanyID (WHERE ConnectionType=6) |
| Artikel | ItemCode NVARCHAR (50) |
OITM.ItemCode | |
| ModulWithVersions | ModulWithVersions SMALLINT (0=false,-1=true) |
||
| Memo | Memo NTEXT |
||
| Erstanlage | CreateDate Datetime |
||
| ErstanlageID | CreateUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| Aenderung | ChangeDate Datetime |
||
| AenderungID | ChangeUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| InAktiv | Inactive SMALLINT (0=false,-1=true) |
Hide dataset | |
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MPCustomerEquipmentCard | Advanced table to sbo standard customer equipment card |
| MPCustomerEquipmentCardCategory | Group to manage properties by group |
| MPEquipment | Equipment: Master Data for each individual Equipment |
| MPEquipmentCategory | EquipmentCategory: Cagetory Master |
| MPHotlineAnfrageModule | Support Module: Issue tracking: Issue linked modules |
| MPHotlineProduktKundeModul | Support Module: Support Product: Customer Product Link: Modules |
| MPHotlineProduktModul | Support Module: Support Product: Master Data Modules |
| MPHotlineProduktModulVersion | Support Module: Support Product: Master Data Versions for Modules |