| View Name: | MARISysUserQuery |
| Based on table: | MPSysUserQuery |
| Group: | Group: SysUserQuery |
| Description: | System: User Defined Queries |
| ClassID: | 250. See Overview of ClassIDs by table. |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| UserQueryID | UserQueryID INT Primary |
Internal ID | |
| Matchcode | Matchcode NVARCHAR (50) Index |
Name of the query | |
| QueryType | QueryType INT Index |
0=MARI, 1=MARI+SBO, 2=SBO Only | |
| QuerySQL | QuerySQL NTEXT |
QUERY TEXT | |
| ConnectionID | ConnectionID INT Index |
1=MARIProject DB | |
| Company | Company INT |
MARISysConnections.Company (WHERE ConnectionType=6) | |
| QueryGroup | QueryGroup INT |
Link to group | MARISysUserQuery.QueryGroup |
| Description | Description NTEXT |
||
| QuerySyntax | QuerySyntax INT |
1=TSQL, 2=HANA Syntax | |
| Inactive | InAktiv SMALLINT (0=false,-1=true) |
Hide dataset | |
| CreateView | CreateView SMALLINT (0=false,-1=true) |
Flag to store the query as permanent view in the database | |
| ViewName | ViewName NVARCHAR (50) |
Name of the view, when stored | |
| LastImport | LastImport Datetime |
||
| ClassID | ClassId INT Index |
ClassId | |
| FilterMode | FilterMode INT |
||
| FilterID | FilterID INT Index |
MARISysFilterDefinitionFilter.FilterID | |
| CreateDate | Erstanlage Datetime |
||
| CreateUser | ErstanlageID NVARCHAR (4) |
MARIUser.CreateUser (WHERE BenutzerTyp=1) | |
| ChangeDate | Aenderung Datetime |
||
| ChangeUser | AenderungID NVARCHAR (4) |
MARIUser.ChangeUser (WHERE BenutzerTyp=1) | |
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MARIDocApprovalRessources | Steps in the approval process. Rule Lines (Steps) for each approval prioritry. The rules are used from top (Priority=0) to button. |
| MARISysUserQuery | System: User Defined Queries |
| MARIInfoScreenManagementBreakEvenColumnDef | Info Screen Management: Column Definition Columns |
| MARICommissionTypes | Commission: Basic Settings for different Types |
| MARIOnlineCatalogTreeElementContent | OnlineCatalogTree: rules to biuld one line |
| MARIChefInfoDashboardTiles | Project Dash Board Settings Tiles |