MARIProject Database Structure

Table Name:MPSetupMandantEInvoice
View Name:MARISettingsCompanyEInvoice
Group:
Description:Master Data: Electronic Invoice settings by company

Field View(engl.field)/Type Description Related
MandantEInvoiceSetID CompanyEInvoiceSetID

INT Primary

FuerMandant ByCompany

SMALLINT (0=false,-1=true)

Mandant Company

SMALLINT Index

MPSysConnections.CompanyID (WHERE ConnectionType=6)
CardCode CardCode

NVARCHAR (20) Index

OCRD.CardCode
EInvoiceProfileID EInvoiceProfileID

SMALLINT Index

FieldEnum FieldEnum

NVARCHAR (100) Index

Setting Setting

SMALLINT

Wert SettingValue

NTEXT

WertTyp ValueType

SMALLINT

Erstanlage CreateDate

Datetime

ErstanlageID CreateUser

NVARCHAR (4)

MPBenutzer.Benutzer (WHERE BenutzerTyp=1)
Aenderung ChangeDate

Datetime

AenderungID ChangeUser

NVARCHAR (4)

MPBenutzer.Benutzer (WHERE BenutzerTyp=1)



Back to table description

Database Version 80
© by MARINGO Computers GmbH, Cologne Germany