ZF2INVTI - Detailed information on tax data
Head - breakdown of turnover tax
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 |
Line items - sales tax information at the invoice line item level
| 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 |