ZF2INVTI - Detailed information on tax data
Head - breakdown of turnover tax
Column name | In use? | Status (Head) | 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 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 | optional | CHAR(5) | Reason for tax exemption (CODE) | Code for the reason for exemption from turnover tax | |
TITAXTPD | x | optional | DATE '0001-01-01' | Tax due date | Date of tax due | |
TITAXDTC | x | Mandatory if TITAXDTC is filled. | CHAR(5) | Code for the tax due date | Code for the tax due date | |
TITAXPER | x | optional | DECIMAL(6, 2) | Tax rate | Tax percentage rate | 19.00 |
Line items - sales tax information at the invoice line item level
Column name | In use? | Status (Head) | 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 = Tax of the positions | |
TILFD | x | DECIMAL(5, 0) | Order of Tax | Tax 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 | x | optional | DECIMAL(6, 2) | Tax rate | Tax percentage rate | 19.00 |