MARIProject Database Structure

Table Name:MPEKVertraegeBelegeSteuer
View Name:MARIPurchaseProcessDocumentTax
Group:Group: MPEKVertraegeBelege
Description:Purchase Process: Purchase Document (Tax)

Field View(engl.field)/Type Description Related
MPBelID MARIDocID

INT Primary

MPEKVertraege.MPBelID
BelID DocEntry

INT Index

MPEKVertraegeBelegePositionen.MPBelPosID
Mandant Company

SMALLINT

MPSysConnections.CompanyID (WHERE ConnectionType=6)
Steuercode TaxCode

NVARCHAR (10) Primary

SteuerTyp TaxType

INT

TaxPercent TaxPercent

NUMERIC(19,6)

TaxBasicValueSys TaxBasicValueSys

NUMERIC(19,6)

TaxBasicValueLoc TaxBasicValueLoc

NUMERIC(19,6)

Steuerbasis TaxBaseAmount

NUMERIC(19,6)

TaxValueSys TaxValueSys

NUMERIC(19,6)

TaxValueLoc TaxValueLoc

NUMERIC(19,6)

Steuerbetrag TaxValueFC

NUMERIC(19,6)

UpdateStamp UpdateStamp

INT




Back to table description

Database Version 80
© by MARINGO Computers GmbH, Cologne Germany