MARIProject Database Structure

View Name:MARIPurchaseProcessDocumentTax
Based on table:MPEKVertraegeBelegeSteuer
Group:Group: MPEKVertraegeBelege
Description:Purchase Process: Purchase Document (Tax)

Field Table(Germ.field)/Type Description Related
MARIDocID MPBelID

INT Primary

MARIPurchaseProcess.MARIDocID
DocEntry BelID

INT Index

MARIPurchaseProcessDocumentPositions.DocEntry
Company Mandant

SMALLINT

MARISysConnections.Company (WHERE ConnectionType=6)
TaxCode Steuercode

NVARCHAR (10) Primary

TaxType SteuerTyp

INT

TaxPercent TaxPercent

NUMERIC(19,6)

TaxBasicValueSys TaxBasicValueSys

NUMERIC(19,6)

TaxBasicValueLoc TaxBasicValueLoc

NUMERIC(19,6)

TaxBaseAmount Steuerbasis

NUMERIC(19,6)

TaxValueSys TaxValueSys

NUMERIC(19,6)

TaxValueLoc TaxValueLoc

NUMERIC(19,6)

TaxValueFC Steuerbetrag

NUMERIC(19,6)

UpdateStamp UpdateStamp

INT




Back to table description

Database Version 80
© by MARINGO Computers GmbH, Cologne Germany