MARIProject Database Structure

View Name:MARIContractDocumentPositionsTax
Based on table:MPVKVertraegeBelegePositionenSteuer
Group:Group: ContractDocument
Description:Contract Management: Document Positions Tax

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

INT Index

MARIContractDocument.MARIDocID
MARIDocPosID MPBelPosID

INT Index

MARIContractDocumentPositions.MARIDocPosID
MARIDocPosTaxID MPBelPosSteuerID

INT Primary

TaxCode Steuercode

NVARCHAR (10)

STATaxCode SteuercodeSTA

NVARCHAR (10)

OSTA.Code
STAType SteuerTypSTA

INT

OSTA.Type
TaxRate Steuersatz

NUMERIC(19,6)

TaxManual SteuerManuell

SMALLINT

TaxWtLiable TaxWtLiable

SMALLINT

TaxBaseLC SteuerBasisLC

NUMERIC(19,6)

TaxBaseFC SteuerBasisFC

NUMERIC(19,6)

TaxBaseSys SteuerBasisSys

NUMERIC(19,6)

TaxValueLC SteuerBetragLC

NUMERIC(19,6)

TaxValueFC SteuerBetragFC

NUMERIC(19,6)

TaxValueSys SteuerBetragSys

NUMERIC(19,6)




Back to table description

Database Version 80
© by MARINGO Computers GmbH, Cologne Germany