Skip to main content
Skip table of contents

ZF23INVTI - Detailinformationen zu Steuerangaben

Diese Datenbanktabelle besteht aus den folgenden Feldern

Column Name

Status

Column definition

Technical term

Description

TIKEY

required

VARCHAR(15)

Reference to ZF23INVHT.HTKEY

Unique auto generated identifier

TIREF

required

VARCHAR (100)

Reference ID to the Parent Table

Reference to the Head (“0”) or the line item (<> “0”)

TITYPE

required

CHAR(1)

Type of Tax

0 = Header level
1  = Line item level
2 = Tax on logistics costs
3 = Tax on advance payments

TILFD

required

DECIMAL(5, 0)

Order of Tax

Steuer Reihenfolge (i-effect Spalte)

TITAXA

required

DECIMAL(15, 2)

VAT category tax amount

The total VAT amount for a given VAT category.

TITAXT

required

CHAR(5)

Type of tax (code)

Coded identification of a VAT category.

TITAXFT

optional

VARCHAR(255)

VAT exemption reason text

A textual statement of the reason why the amount is exempted from VAT or why no VAT is being charged

TITAXBA

required

DECIMAL(15, 2)

VAT category taxable amount

Sum of all taxable amounts subject to a specific VAT category code and VAT category rate (if the VAT category rate is applicable).

TITAXGA

optional

DECIMAL(15, 2)

Line Total Basis Amount

A monetary value used as the line total basis on which this trade related tax, levy or duty is calculated

TITAXCOMA

optional

DECIMAL(15, 2)

Total amount of charges / allowances on document level

TITAXCAT

required

CHAR(2)

VAT category code

Coded identification of a VAT category.

TITAXFTC

optional

CHAR(16)

VAT exemption reason code

A coded statement of the reason for why the amount is exempted from VAT.

TITAXTPD

optional

DATE '0001-01-01'

Value added tax point date

The date when the VAT becomes accountable for the Seller and for the Buyer in so far as that date can be determined and differs from the date of issue of the invoice, according to the VAT directive.

TITAXDTC

optional

CHAR(5)

Value added tax point date code

The code of the date when the VAT becomes accountable for the Seller and for the Buyer.

TITAXPER

optional

DECIMAL(6, 2)

VAT category rate

The VAT rate, represented as percentage that applies for the relevant VAT category.

In der folgenden Auflistung können die zu den Feldern passenden Geschäftsregelnummern, die XML Zielelemente und weitere Erläuterungen entnommen werden

Spaltenname

XML Element

EN16931-ID

Beispiel

TITAXA

/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:ApplicableTradeTax/ram:CalculatedAmount

BT-117

Calculated by multiplying the VAT category taxable amount with the VAT category rate for the relevant VAT category.

TITAXT

/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:ApplicableTradeTax/ram:TypeCode

BT-118-0

The VAT category code and the VAT category rate shall be consistent. For more information on the recommended codes, please refer to subclause 6.3.3.2 - Specification of VAT category codes.

TITAXFT

/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:ApplicableTradeTax/ram:ExemptionReason

BT-120

Articles 226 items 11 to 15 Directive 2006/112/EC [2].

TITAXBA

/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:ApplicableTradeTax/ram:BasisAmount

BT-116

The sum of Invoice line net amount minus allowances plus charges on document level which are subject to a specific VAT category code and VAT category rate (if the VAT category rate is applicable).

TITAXGA

/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:ApplicableTradeTax/ram:LineTotalBasisAmount

BT-X-262

TITAXCOMA

/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:ApplicableTradeTax/ram:AllowanceChargeBasisAmount

BT-X-263

TITAXCAT

/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:ApplicableTradeTax/ram:CategoryCode

BT-118

The following entries of UNTDID 5305 [6] are used (further clarification between brackets):

  • Standard rate (Liable for VAT in a standard way)

  • Zero rated goods (Liable for VAT with a percentage rate of zero)

  • Exempt from tax (VAT/IGIC/IPSI)

  • VAT Reverse Charge (Reverse charge VAT/IGIC/IPSI rules apply)

  • VAT exempt for intra community supply of goods (VAT/IGIC/IPSI not levied due to Intra-community supply rules)

  • Free export item, tax not charged (VAT/IGIC/IPSI not levied due to export outside of the EU)

  • Services outside scope of tax (Sale is not subject to VAT/IGIC/IPSI)

  • Canary Islands General Indirect Tax (Liable for IGIC tax)

  • Liable for IPSI (Ceuta/Melilla tax)

TITAXFTC

/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:ApplicableTradeTax/ram:ExemptionReasonCode

BT-121

Code list issued and maintained by the Connecting Europe Facility.

TITAXTPD

/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:ApplicableTradeTax/ram:TaxPointDate/udt:DateString

BT-7

The tax point is usually the date goods were supplied or services completed (the 'basic tax point'). There are some variations. Please refer to Article 226 (7) of the Council Directive 2006/112/EC [2] for more information. This element is required if the Value added tax point date is different from the Invoice issue date. Both Buyer and Seller should use the Tax Point Date when provided by the Seller. The use of BT-7 and BT-8 is mutually exclusive.

TITAXDTC

/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:ApplicableTradeTax/ram:DueDateTypeCode

BT-8

The code shall distinguish between the following entries of UNTDID 2005 [6]:

  • Invoice docment issue date

  • Delivery date, actual

  • Payment date. The Value added tax point date code is used if the Value added tax point date is not known when the invoice is issued. The use of BT-8 and BT-7 is mutually exclusive.

TITAXPER

/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:ApplicableTradeTax/ram:RateApplicablePercent

BT-119

The VAT category code and the VAT category rate shall be consistent.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.