| View Name: | MARIInfoScreenManagementBreakEvenColumnHead |
| Based on table: | MPDBColumnsDefinition |
| Group: | Group: InfoScreenManagementBreakEven |
| Description: | Info Screen Management: Column Definition Head |
| ClassID: | 270. See Overview of ClassIDs by table. |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| ColumnDefinitionID | ColumnDefinitionID INT Primary |
||
| KeyType | KeyType INT |
ClassID | |
| Description | Description NVARCHAR (50) |
||
| DefinitionType | DefinitionType INT |
||
| UseInWIP | UseInWIP SMALLINT (0=false,-1=true) |
||
| UseInInfoScreen | UseInInfoScreen SMALLINT (0=false,-1=true) |
||
| DefinitionGroup | DefinitionGroup INT |
MARIGroups.DefinitionGroup (WHERE GruppenArt=10509) | |
| WorkInProgressID | WorkInProgressID INT |
MARIWorkInProgressDefinition.WorkInProgressID | |
| WorkInProgressVersion | WorkInProgressVersion INT |
||
| PlanningVersionGroup1Name | PlanningVersionGroup1Name NVARCHAR (50) |
||
| PlanningVersionGroup1 | PlanningVersionGroup1 INT |
||
| PlanningVersionGroup2Name | PlanningVersionGroup2Name NVARCHAR (50) |
||
| PlanningVersionGroup2 | PlanningVersionGroup2 INT |
||
| PlanningVersionGroup3Name | PlanningVersionGroup3Name NVARCHAR (50) |
||
| PlanningVersionGroup3 | PlanningVersionGroup3 INT |
||
| Company | CompanyID INT |
MARISysConnections.Company (WHERE ConnectionType=6) | |
| BreakEvenViewMode | BreakEvenViewMode INT |
||
| Memo | Memo NTEXT |
||
| ChangeRightsMode | ChangeRightsMode INT |
||
| ChangeRightsGroup | ChangeRightsGroup BIGINT |
MARIUserGroups.ChangeRightsGroup (WHERE BenutzerTyp=1) | |
| ChangeRightsEmployee | ChangeRightsEmployee NVARCHAR (20) |
||
| QuerySourceID | QuerySourceID INT Index |
||
| 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 |
|---|---|
| MARIInfoScreenManagementBreakEvenColumnDef | Info Screen Management: Column Definition Columns |