MARIProject Database Structure

Table Name:MPDBAuswertungen
View Name:MARIInfoScreenManagementBreakEven
Group:Group: InfoScreenManagementBreakEven
Description:Info Screen Management: Breakeven Analysis (Header)
ClassID: 251. See Overview of ClassIDs by table.

Field View(engl.field)/Type Description Related
ViewMode ViewMode

SMALLINT Primary

Break Even Analysis ID
KeyType KeyType

INT Index

40 For Project/Contract or 22 for Profit Center
Mandant Company

SMALLINT Index

MPSysConnections.CompanyID (WHERE ConnectionType=6)
MandantenUebergreifend CompanyForAllFlag

SMALLINT (0=false,-1=true)

Definition can be used in all companies (if G/L Accounts are synchrinized)
Title Title

NVARCHAR (50) Index

Options Options

NTEXT

BerechtigungsFlagg SecurityFlag

BIGINT

MPBenutzergruppen.Gruppe (WHERE BenutzerTyp=1)
PlanungsMode PlanningMode

INT Index

TimeMode TimeLine

INT

DefinitionGroup DefinitionGroup

INT

MPGruppen.GruppenID (WHERE Gruppenart=10508)
DefaultPlanningVersion DefaultPlanningVersion

INT

Memo Memo

NTEXT

ChangeRightsMode ChangeRightsMode

INT

ChangeRightsGroup ChangeRightsGroup

BIGINT

MPBenutzergruppen.Gruppe (WHERE BenutzerTyp=1)
ChangeRightsEmployee ChangeRightsEmployee

NVARCHAR (20)

MenuOption MenuOption

INT

MenuIcon MenuIcon

INT

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


Linked by

Table Description
MPDBAuswertungenPos Info Screen Management: Breakeven Analysis (Lines)
MPDBAuswertungenPosKto Info Screen Management: Breakeven Analysis (Accounts)
MPProjektPlanungsversion Project Master: Planning versions linked to a project


Back to table description

Database Version 80
© by MARINGO Computers GmbH, Cologne Germany