MARIProject Database Structure

View Name:MARIContractDocumentTAX
Based on table:MPVKVertraegeBelegeSteuer
Group:Group: ContractDocument
Description:Contract Management: Document TAX

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

INT Primary

MARIContractDocument.MARIDocID
DocEntry BelID

INT Index

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