MARIProject Database Structure

View Name:MARISysCustomerLanguages
Based on table:MPSysKundenSprachen
Group:Group: SysCustomerLanguages
Description:System: Language
ClassID: 136. See Overview of ClassIDs by table.

Field Table(Germ.field)/Type Description Related
CustomerLanguageID CustomerLanguageID

INT Primary

LanguageMode LanguageMode

INT

1=System, 2=Userdefined clsImportSysCustomerLanguages_eLanguageMode
Matchcode Matchcode

NVARCHAR (50) Index

Name of the language
MatchcodeID MatchcodeID

INT Index

(optional) Translation Code for the laguage name
LanguageKey LanguageKey

NVARCHAR (6)

fi-FI
SysLangID SysLangID

INT Index

clsPublicEnums_eS_Languages
DefaultPrintProcess DefaultPrintProcess

INT

LanguageKeyPrint LanguageKeyPrint

NVARCHAR (6)

UseSupport UseSupport

SMALLINT (0=false,-1=true)

UseKnowledgeBase UseKnowledgeBase

SMALLINT (0=false,-1=true)

UseNewsletter UseNewsletter

SMALLINT (0=false,-1=true)

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
MARISupportIssue Support Module: Support Tickets, Tasks, Ideas, Dev Task, HR Tasks The type of ticket is defined by the field HotlineClassType.
DimensionHotlineClassType
Support Ticket17
Task676
Idea677
Development Task678
HR Task679
MARISupportIssueLine Support Module: Issue tracking: Issue line for comments, documents, emails, etc.
MARIClassNotificationText Event Management: Textdefinition master
MARIClassNotificationTextLang Event Management: Textdefinitions by language
MARISysCustomerLanguagesCompany System: Languages linked to SBO company languages
MARITrainingParticipant Training Module: List Of Participants
MARIKnowledgeBaseEntryLanguage Support Module: Knowledge Base Languages
MARINewsletterMaster Newsletter Design Template
MARINewsletterCampaign Source data for a plain newsletter (one time user)


Back to table description

Database Version 80
© by MARINGO Computers GmbH, Cologne Germany