MARIProject Database Structure

View Name:MARIJournalEntryISCRule
Based on table:MPFibuBuchungsautomatRegel
Group:Group: JournalEntryExport
Description:Definitions for Internal Service Charge Wizard

Field Table(Germ.field)/Type Description Related
DefinitionRuleID AutomatRegelID

INT Primary

ID ID

INT

ISCEvent Buchungsfall

INT Index

TravelCategory ReiseTemplate

INT

MARITravelTemplate.TravelCategory
TravelCategorySubType ReiseTemplateVersion

INT

MARITravelTemplateVersion.TravelCategorySubType
SourceVariant QuellVariante

INT Index

VariantValid VariantenGueltig

SMALLINT (0=false,-1=true)

SourceType HerkunftsTyp

INT

LineType ZeilenTyp

NTEXT

Description Beschreibung

NTEXT

DescriptionID BeschreibungID

INT

Language ID for the original
BUEmpl_Equals_BUProj MAGB_gleich_PRJGB

SMALLINT (0=false,-1=true)

CompanyEquals MandantGleich

SMALLINT (0=false,-1=true)

ProjectType ProjektTyp

INT

NumberBookings AnzahlBuchungen

INT

Remark Bemerkung

NTEXT

RemarkID BemerkungID

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




Back to table description

Database Version 80
© by MARINGO Computers GmbH, Cologne Germany