ZF2INVTI - Detailed information on tax details (Zugferd 2.2.0 + XRechnung)
Column name | Status | Column definition | Technical term | Column description | XML Element | EN16931-ID | Example |
|---|---|---|---|---|---|---|---|
TIKEY | required | VARCHAR(15) | Internal pagination number | Internal invoice number (i-effect column) | |||
TIREF | required | DECIMAL(5, 0) | Reference ID to the Specified Table | Reference to table (i-effect column) | 0 = document header | ||
TITYPE | required | CHAR(1) | Type of Tax | Type of tax (i-effect column) | 0 = Taxes in document header/footer | ||
TILFD | required | DECIMAL(5, 0) | Order of Tax | Control sequence (i-effect column) | |||
TITAXA | required | DECIMAL(15, 2) | Tax amount calculated | Category-specific tax amount | CalculatedAmount | BT-117 | |
TITAXT | required | CHAR(5) | Type of Tax | VAT category code | TypeCode | BT-118-0 | VAT |
TITAXFT | optional | VARCHAR(255) | Reason for tax exemption | Reason for tax exemption (free text) | ExemptionReason | BT-120 | |
TITAXBA | required | DECIMAL(15, 2) | Basic Amount for Tax calculation | tax base amount | BasisAmount | BT-116 | |
TITAXGA | optional | DECIMAL(15, 2) | Goods amount of the Tax rate | Amount of goods subject to tax | LineTotalBasisAmount | ||
TITAXCOMA | optional | DECIMAL(15, 2) | Total amount increases and reductions in the tax rate | Total amount of tax rate increases and reductions | AllowanceChargeBasisAmount | ||
TITAXCAT | required | CHAR(2) | Tax category | Coded designation of a sales tax category | CategoryCode | BT-118 | S |
TITAXFTC | optional | CHAR(16) | Reason for tax exemption (CODE) | Code for the reason for VAT exemption | ExemptionReasonCode | BT-121 | |
TITAXTPD | optional | DATE '0001-01-01' | Tax due date | tax due date | TaxPointDate | ||
TITAXDTC | optional | CHAR(5) | Code for the tax due date | Code for the tax due date | DueDateTypeCode | BT-8 | |
TITAXPER | optional | DECIMAL(6, 2) | Tax rate | Category-specific sales tax rate | RateApplicablePercent | BT-119 | 19.00 |