MPDBColumnsDefinition

Table Name:	MPDBColumnsDefinition
View Name:	MARIInfoScreenManagementBreakEvenColumnHead
Group:	Group: InfoScreenManagementBreakEven
Description:	Info Screen Management: Column Definition Head
ClassID:	270. See Overview of ClassIDs by table.

Field	View(engl.field)/Type	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	MPGruppen.GruppenID (WHERE GruppenArt=10509)
WorkInProgressID	WorkInProgressID INT	MPWorkInProgressDefinition.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
CompanyID	Company INT	MPSysConnections.CompanyID (WHERE ConnectionType=6)
BreakEvenViewMode	BreakEvenViewMode INT
Memo	Memo NTEXT
ChangeRightsMode	ChangeRightsMode INT
ChangeRightsGroup	ChangeRightsGroup BIGINT	MPBenutzergruppen.Gruppe (WHERE BenutzerTyp=1)
ChangeRightsEmployee	ChangeRightsEmployee NVARCHAR (20)
QuerySourceID	QuerySourceID INT Index
Erstanlage	CreateDate Datetime
ErstanlageID	CreateUser NVARCHAR (4)	MPBenutzer.Benutzer (WHERE BenutzerTyp=1)
Aenderung	ChangeDate Datetime
AenderungID	ChangeUser NVARCHAR (4)	MPBenutzer.Benutzer (WHERE BenutzerTyp=1)
UpdateStamp	UpdateStamp INT

MARIProject Database Structure