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