Skip to main content
Skip table of contents

ZF2INVTI - Detailed information on tax data

Head - breakdown of turnover tax

Column name

In use?StatusColumn 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 the 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

xrequired

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

xoptional

CHAR(5)

Code for the tax due date

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

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

Column nameIn use?Status (Header)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 = Taxes on items

TILFDx
DECIMAL(5, 0)Order of TaxControl 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
TITAXPER

DECIMAL(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.