MARIProject Database Structure

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

Field Table(Germ.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
Company Mandant

SMALLINT Index

MARISysConnections.Company (WHERE ConnectionType=6)
CompanyForAllFlag MandantenUebergreifend

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

SecurityFlag BerechtigungsFlagg

BIGINT

MARIUserGroups.SecurityFlag (WHERE BenutzerTyp=1)
PlanningMode PlanungsMode

INT Index

TimeLine TimeMode

INT

DefinitionGroup DefinitionGroup

INT

MARIGroups.DefinitionGroup (WHERE Gruppenart=10508)
DefaultPlanningVersion DefaultPlanningVersion

INT

Memo Memo

NTEXT

ChangeRightsMode ChangeRightsMode

INT

ChangeRightsGroup ChangeRightsGroup

BIGINT

MARIUserGroups.ChangeRightsGroup (WHERE BenutzerTyp=1)
ChangeRightsEmployee ChangeRightsEmployee

NVARCHAR (20)

MenuOption MenuOption

INT

MenuIcon MenuIcon

INT

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


Linked by

Table Description
MARIInfoScreenManagementBreakEvenPos Info Screen Management: Breakeven Analysis (Lines)
MARIProjectPlanningVersions Project Master: Planning versions linked to a project
MARIInfoScreenManagementBreakEvenAccounts Info Screen Management: Breakeven Analysis (Accounts)


Back to table description

Database Version 80
© by MARINGO Computers GmbH, Cologne Germany