MARIProject Database Structure

View Name:MARISettingsCompanyEInvoice
Based on table:MPSetupMandantEInvoice
Group:
Description:Master Data: Electronic Invoice settings by company

Field Table(Germ.field)/Type Description Related
CompanyEInvoiceSetID MandantEInvoiceSetID

INT Primary

ByCompany FuerMandant

SMALLINT (0=false,-1=true)

Company Mandant

SMALLINT Index

MARISysConnections.Company (WHERE ConnectionType=6)
CardCode CardCode

NVARCHAR (20) Index

OCRD.CardCode
EInvoiceProfileID EInvoiceProfileID

SMALLINT Index

FieldEnum FieldEnum

NVARCHAR (100) Index

Setting Setting

SMALLINT

SettingValue Wert

NTEXT

ValueType WertTyp

SMALLINT

CreateDate Erstanlage

Datetime

CreateUser ErstanlageID

NVARCHAR (4)

MARIUser.CreateUser (WHERE BenutzerTyp=1)
ChangeDate Aenderung

Datetime

ChangeUser AenderungID

NVARCHAR (4)

MARIUser.ChangeUser (WHERE BenutzerTyp=1)



Back to table description

Database Version 80
© by MARINGO Computers GmbH, Cologne Germany