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 |
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):
|
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]:
|
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. |