ZF2INVTI - Detailed information on tax data

Column name	In use?	Status	Column definition	Column description	Technical term	Example
TIKEY	x		VARCHAR(15)	Internal pagination number	Internal invoice number (i-effect column)
TIREF	x		DECIMAL(5, 0)	Reference ID to the Specified Table	Reference to table (i-effect column)	0 = Document header
TITYPE	x		CHAR(1)	Type of Tax	Type of tax (i-effect column)	0 = Taxes in the document header/footer,
TILFD	x		DECIMAL(5, 0)	Order of Tax	Control sequence (i-effect column)
TITAXA	x	required	DECIMAL(15, 2)	Tax amount calculated	Tax amount
TITAXT	x	required	CHAR(5)	Type of Tax	Tax type (code)	VAT
TITAXFT	x	optional	VARCHAR(255)	Reason for tax exemption	Reason for tax exemption (free text)
TITAXBA	x	required	DECIMAL(15, 2)	Basic Amount for Tax calculation	Tax base amount
TITAXGA			DECIMAL(15, 2)	Goods amount of the Tax rate	Goods amount of the tax rate
TITAXCOMA			DECIMAL(15, 2)	Total amount increases and reductions in the tax rate	Total amount Tax rate additions and deductions
TITAXCAT	x	required	CHAR(2)	Tax category	Tax category	S
TITAXFTC	x	required	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	x	optional	CHAR(5)	Code for the tax due date	Code for the tax due date
TITAXPER	x	required	DECIMAL(6, 2)	Tax rate	Tax percentage rate	19.00

Column name	In use?	Status (Header)	Column definition	Column description	Technical term	Example
TIKEY	x		VARCHAR(15)	Internal pagination number	Internal invoice number (i-effect column)
TIREF	x		DECIMAL(5, 0)	Reference ID to the Specified Table	Reference to table (i-effect column) ZFINVOICPI (PIREF)
TITYPE	x		CHAR(1)	Type of Tax	Type of tax (i-effect column)	1 = Taxes on items
TILFD	x		DECIMAL(5, 0)	Order of Tax	Control sequence (i-effect column)
TITAXA			DECIMAL(15, 2)	Tax amount calculated	Tax amount
TITAXT	x	required	CHAR(5)	Type of Tax	Tax type (Code)	VAT
TITAXFT			VARCHAR(255)	Reason for tax exemption	Reason for tax exemption (free text)
TITAXBA			DECIMAL(15, 2)	Basic Amount for Tax calculation	Tax base amount
TITAXGA			DECIMAL(15, 2)	Goods amount of the Tax rate	Goods amount of the tax rate
TITAXCOMA			DECIMAL(15, 2)	Total amount increases and reductions in the tax rate	Total amount Tax rate additions and deductions
TITAXCAT	x	required	CHAR(2)	Tax category	Tax category	S
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 rate	Tax percentage rate	19.00