Skip to main content
Skip table of contents

ZF2INVTI - Detailed information on tax data

Head - breakdown of turnover tax

Column name

In use?Status (Head)Column definitionColumn descriptionTechnical termExample
TIKEYx
VARCHAR(15)Internal pagination numberInternal invoice number (i-effect column)
TIREFx
DECIMAL(5, 0)Reference ID to the Specified Table

Reference to table (i-effect column)

0 = Document header
TITYPEx
CHAR(1)Type of TaxType of tax (i-effect column)

0 = Taxes in document header/footer,

TILFDx
DECIMAL(5, 0)Order of TaxControl sequence (i-effect column)
TITAXAxrequiredDECIMAL(15, 2)Tax amount calculatedTax amount
TITAXTxrequiredCHAR(5)Type of TaxTax type (code)VAT
TITAXFTxoptionalVARCHAR(255)Reason for tax exemptionReason for tax exemption (free text)
TITAXBAxrequiredDECIMAL(15, 2)Basic Amount for Tax calculationTax base amount
TITAXGA

DECIMAL(15, 2) Goods amount of the Tax rateGoods amount of the tax rate
TITAXCOMA

DECIMAL(15, 2)Total amount increases and reductions in the tax rateTotal amount Tax rate additions and deductions
TITAXCATxrequiredCHAR(2)Tax categoryTax categoryS

TITAXFTC

xoptional

CHAR(5)

Reason for tax exemption (CODE)

Code for the reason for exemption from turnover tax

TITAXTPD

xoptional

DATE '0001-01-01'

Tax due date

Date of tax due

TITAXDTC

xMandatory if TITAXDTC is filled.

CHAR(5)

Code for the tax due date

Code for the tax due date
TITAXPERxoptionalDECIMAL(6, 2)Tax rateTax percentage rate19.00

Line items - sales tax information at the invoice line item level

Column name

In use?Status (Head)Column definitionColumn descriptionTechnical termExample
TIKEYx
VARCHAR(15)Internal pagination numberInternal invoice number (i-effect column)
TIREFx
DECIMAL(5, 0)Reference ID to the Specified Table

Reference to table (i-effect column)

ZFINVOICPI (PIREF)


TITYPEx
CHAR(1)Type of TaxType of tax (i-effect column)

1 = Tax of the positions

TILFDx
DECIMAL(5, 0)Order of TaxTax sequence (i-effect column)
TITAXA

DECIMAL(15, 2)Tax amount calculatedTax amount
TITAXTxrequiredCHAR(5)Type of TaxTax type (code)VAT
TITAXFT

VARCHAR(255)Reason for tax exemptionReason for tax exemption (free text)
TITAXBA

DECIMAL(15, 2)Basic Amount for Tax calculationTax base amount
TITAXGA

DECIMAL(15, 2) Goods amount of the Tax rateGoods amount of the tax rate
TITAXCOMA

DECIMAL(15, 2)Total amount increases and reductions in the tax rateTotal amount Tax rate additions and deductions
TITAXCATxrequiredCHAR(2)Tax categoryTax categoryS

TITAXFTC



CHAR(5)

Reason for tax exemption (CODE)

Code for the reason for exemption from turnover tax

TITAXTPD



DATE '0001-01-01'

Tax due date

Date of tax due

TITAXDTC



CHAR(5)

Code for the tax due date

Code for the tax due date
TITAXPERxoptionalDECIMAL(6, 2)Tax rateTax percentage rate19.00
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.