---
title: "VATCodes (Exact Online)"
description: "VAT Codes"
language: de
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/de/datamodels/exactonline/ExactOnlineREST.VAT.VATCodes
original: https://documentation.invantive.eu/en/datamodels/exactonline/ExactOnlineREST.VAT.VATCodes
updated: 2026-11-16T20:58:19Z
license: https://documentation.invantive.eu/de/
---

# VATCodes: Exact Online VAT Codes

`insert` `update` `delete` `per partition` `REST`

- Katalog: `ExactOnlineREST`
- Schema: `VAT`
- Primärschlüssel: `ID`
- Label: VAT Codes

Die Daten in dieser Tabelle sind nach dem Wert der Spalte `Division` aufgeteilt.

Mit `insert`, `update` und `delete` können Daten abgerufen und geändert werden.

## API-Quelle

- Endpunkt: `/api/v1/{division}/vat/VATCodes`
- Metadaten: `/api/v1/{division}/vat/$metadata`

## Leistungsmerkmale

| Characteristic | Value |
|---|---:|
| Durchschnittliche Zugriffsverzögerung (ms) | 5 |
| Anzahl der Vollscan-Zeilen pro Minute | 7,200 |
| Anzahl der Query-Zeilen pro Minute | 300 |
| Zeilen pro Minute schreiben | 300 |

Das Ergebnis kann auf dem Client im Cache zwischengespeichert werden.

## Tabellenspalten

Die Spalten der Tabelle `VATCodes` sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.

| Name | Datentyp | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `Account` | `guid` | Account | [ ] | filters on the platform, writable | Tax account. |
| `AccountCode` | `varchar2(18)` | Konto Code | [ ] | filters on the platform, writable | Code of Account. |
| `AccountName` | `varchar2(50)` | Konto Name | [ ] | filters on the platform, writable | Name of Account. |
| `CalculationBasis` | `int16` | itgen_eol_calculationbasis | [ ] | filters on the platform, writable | Indicates how to calculate the tax.0 = based on the gross amount, 1 = based on the gross amount + another tax. |
| `Charged` | `char` | Charged | [ ] | filters on the platform, writable | Indicates if transactions using the VAT code are transactions of the domestic VAT charging regulation (such as those for subcontractors) or transactions that are registered within the EU.If Charged=1 and linked to a purchase invoice, both a line for the VAT to pay and a line for the VAT to claim are being created. |
| `Code` | `varchar2(3)` | Code | [x] | filters on the platform, writable | VAT code. |
| `Country` | `varchar2(30)` | Country | [ ] | filters on the platform, writable | Obsolete. |
| `Created` | `datetime` | Created | [ ] | filters on the platform, writable | Creation date. |
| `CreatedUtc` | `datetime` | Angelegt | [ ] | writable | Creation date in UTC. |
| `Creator` | `guid` | Creator | [ ] | filters on the platform, writable | User ID of creator. |
| `CreatorFullName` | `varchar2(240)` | Ersteller vollständiger Name | [ ] | filters on the platform, writable | Name of creator. |
| `CustomField` | `varchar2` | Benutzerdefiniertes Feld | [ ] | writable |  |
| `Description` | `varchar2(60)` | Description | [ ] | filters on the platform, writable | Description of the VAT code. |
| `Division` | `int32` | Division | [ ] |  | Division code. |
| `DivisionCompanyCoCNumber` | `varchar2(60)` | Nummer der Handelskammer des Bezirks | [ ] | writable | Chamber of commerce number of the Exact Online division. |
| `DivisionCompanyIBANNumber` | `varchar2(50)` | Abteilung IBAN-Nummer | [ ] | writable | IBAN number of the Exact Online division. |
| `DivisionCompanyName` | `varchar2(50)` | Geschäftsbereich Firmenname | [x] | writable | Company name of the Exact Online division. |
| `DivisionCompanyRSINNumber` | `varchar2(9)` | Abteilung RSIN-Nummer | [ ] | writable | RSIN number of the Exact Online division. |
| `DivisionCompanyVATNumber` | `varchar2(35)` | Umsatzsteuer-Identifikationsnummer der Abteilung | [ ] | writable | VAT number of the Exact Online division. |
| `DivisionCompanyWageTaxNumber` | `varchar2(60)` | Nummer der Lohnsteuerabteilung | [ ] | writable | Wage tax number of the Exact Online division. |
| `DivisionLabel` | `varchar2(128)` | Abteilungsbezeichnung | [x] | writable | Label of the Exact Online division. |
| `DivisionName` | `varchar2(50)` | Verwaltung Name | [x] | writable | Name of the Exact Online division. |
| `DivisionOwnerCompanyName` | `varchar2(50)` | Name des Abonnenten | [x] | writable | Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs. |
| `DivisionOwnerCompanyNumber` | `varchar2(18)` | Abonnentennummer | [x] | writable | Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs. |
| `DivisionShortName` | `int64` | Kurzbezeichnung der Abteilung | [x] | writable | Short name of the Exact Online division. |
| `EUSalesListing` | `varchar2(1)` | EU Verkaufsliste | [ ] | filters on the platform, writable | Used in all legislations except France.Indicates if and how transactions using the VAT code appear on the ICT return (EU sales list).L = Listing goods, N = No listing, S = Listing services, T = Triangulation. |
| `ExcludeVATListing` | `int16` | USt.-Liste ausschließen | [x] | filters on the platform, writable |  |
| `GLDiscountPurchase` | `guid` | itgen_eol_gldiscountpurchase | [ ] | filters on the platform, writable | Indicates the purchase discount GL account linked to the VAT codes for German legislation. |
| `GLDiscountPurchaseCode` | `varchar2(30)` | itgen_eol_gldiscountpurchasecode | [ ] | filters on the platform, writable | Code of GLDiscountPurchase. |
| `GLDiscountPurchaseDescription` | `varchar2(60)` | itgen_eol_gldiscountpurchasedescription | [ ] | filters on the platform, writable | Description of GLDiscountPurchase. |
| `GLDiscountSales` | `guid` | itgen_eol_gldiscountsales | [ ] | filters on the platform, writable | Indicates the sales discount GL account linked to the VAT codes for German legislation. |
| `GLDiscountSalesCode` | `varchar2(30)` | itgen_eol_gldiscountsalescode | [ ] | filters on the platform, writable | Code of GLDiscountSales. |
| `GLDiscountSalesDescription` | `varchar2(60)` | itgen_eol_gldiscountsalesdescription | [ ] | filters on the platform, writable | Description of GLDiscountSales. |
| `GLToClaim` | `guid` | itgen_eol_gltoclaim | [ ] | filters on the platform, writable | G/L account that is used to book the VAT to claim.If you enter purchases with a VAT code, the VAT amount to be claimed is entered to this VAT account.Must be of type VAT. |
| `GLToClaimCode` | `varchar2(30)` | itgen_eol_gltoclaimcode | [ ] | filters on the platform, writable | Code of GLToClaim. |
| `GLToClaimDescription` | `varchar2(60)` | itgen_eol_gltoclaimdescription | [ ] | filters on the platform, writable | Description of GLToClaim. |
| `GLToPay` | `guid` | itgen_eol_gltopay | [ ] | filters on the platform, writable | G/L account that is used to book the VAT to pay.If you enter sales with a VAT code, the VAT amount to be paid is entered to this VAT account.Must be of type VAT. |
| `GLToPayCode` | `varchar2(30)` | itgen_eol_gltopaycode | [ ] | filters on the platform, writable | Code of GLToPay. |
| `GLToPayDescription` | `varchar2(60)` | itgen_eol_gltopaydescription | [ ] | filters on the platform, writable | Description of GLToPay. |
| `ID` | `guid` | ID | [x] | filters on the platform, writable | Primary key. |
| `IntraStat` | `char` | Intrastat | [ ] | filters on the platform, writable | Used in all legislations except France.Indicates if intrastat is used. |
| `IntrastatType` | `varchar2(1)` | Intrastat-Typ | [ ] | filters on the platform, writable | Used in France legislation only.Indicates if and how transactions using the VAT code appear on the DEB/DES return.L = Goods, N = Empty, S = Services. |
| `IsBlocked` | `char` | Ist blockiert | [ ] | filters on the platform, writable | Indicates if the VAT code may still be used. |
| `LegalText` | `varchar2(150)` | Rechtlicher Text | [ ] | filters on the platform, writable | Legal description for VAT code to print in the total block of the invoice. |
| `Modified` | `datetime` | Modified | [ ] | filters on the platform, writable | Last modified date. |
| `ModifiedUtc` | `datetime` | Geändert (UTC) | [ ] | writable | Last modified date in UTC. |
| `Modifier` | `guid` | Modifier | [ ] | filters on the platform, writable | User ID of modifier. |
| `ModifierFullName` | `varchar2(240)` | Geänderter vollständiger Name | [ ] | filters on the platform, writable | Name of modifier. |
| `OssCountry` | `varchar2` | OSS-Land | [ ] | Filter auf der Plattform |  |
| `Percentage` | `double` | Percentage | [ ] | filters on the platform, writable | Percentage of the VAT code. |
| `TaxReturnType` | `int16` | Steuerrückerstattung Typ | [ ] | filters on the platform, writable | Indicates what type of Taxcode it is: can be VAT, IncomeTax. |
| `Type` | `varchar2(1)` | Type | [ ] | filters on the platform, writable | Indicates how the VAT amount should be calculated in relation to the invoice amount.B = VAT 0% (Only base amount), E = Excluding, I = Including, N = No VAT. |
| `VATPartialRatio` | `int16` | Mehrwertsteuer-Teilquote | [ ] | filters on the platform, writable | Partial ratio explains which part of the VAT the company has to pay.Used in some branches where the sellers have a bad reputation, so the buyers have to take over the VAT-liability. |
| `VATTransactionType` | `varchar2(1)` | Umsatzsteuer-Transaktionsart | [ ] | filters on the platform, writable | Indicates the type of transactions for which the VAT code may be used.B = Both, P = Purchase, S = Sales. |
| `VatDocType` | `varchar2(1)` | Umsatzsteuer-Belegart | [ ] | filters on the platform, writable | Field in VAT code maintenance to calculate different VATs depending on the selected document type.P = purchase invoice, F = freelance invoice, E = expense voucher.The field is valid for witholding tax type. |
| `VatMargin` | `int16` | USt. Marge | [x] | filters on the platform, writable | The VAT margin scheme is used for the trade of secondhand goods which are purchased without VAT (for example when a company buys a secondhand good from a private person).In the VAT margin scheme, the VAT is not calculated based on the sales price.Instead of that, the VAT is calculated based on the margin (gross sales price minus the gross purchase price). |

## Tasten

| Key | Column | Bezieht sich auf | Kind | Description |
|---|---|---|---|---|
| `VATCodes_Account_Accounts_fk` | `Account` | [Accounts](ExactOnlineREST.CRM.Accounts)`.ID` | Key |  |
| `VATCodes_Creator_Users_fk` | `Creator` | [Users](ExactOnlineREST.Users.Users)`.UserID` | Key |  |
| `VATCodes_GLDiscountPurchase_GLAccounts_fk` | `GLDiscountPurchase` | [GLAccounts](ExactOnlineREST.Financial.GLAccounts)`.ID` | Key |  |
| `VATCodes_GLDiscountSales_GLAccounts_fk` | `GLDiscountSales` | [GLAccounts](ExactOnlineREST.Financial.GLAccounts)`.ID` | Key |  |
| `VATCodes_GLToClaim_GLAccounts_fk` | `GLToClaim` | [GLAccounts](ExactOnlineREST.Financial.GLAccounts)`.ID` | Key |  |
| `VATCodes_GLToPay_GLAccounts_fk` | `GLToPay` | [GLAccounts](ExactOnlineREST.Financial.GLAccounts)`.ID` | Key |  |
| `VATCodes_Modifier_Users_fk` | `Modifier` | [Users](ExactOnlineREST.Users.Users)`.UserID` | Key |  |

## Verwiesen von

- [QuotationLines](ExactOnlineREST.CRM.QuotationLines) `VATCode` (Key)
- [QuotationLinesBulk](ExactOnlineREST.CRM.QuotationLinesBulk) `VATCode` (Key)
- [AllocationRule](ExactOnlineREST.Cashflow.AllocationRule) `VATCode` (Key)
- [GLAccounts](ExactOnlineREST.Financial.GLAccounts) `VATCode` (Key)
- [GLAccountsBulk](ExactOnlineREST.Financial.GLAccountsBulk) `VATCode` (Key)
- [BankEntryLines](ExactOnlineREST.FinancialTransaction.BankEntryLines) `VATCode` (Key)
- [CashEntryLines](ExactOnlineREST.FinancialTransaction.CashEntryLines) `VATCode` (Key)
- [TransactionLines](ExactOnlineREST.FinancialTransaction.TransactionLines) `VATCode` (Key)
- [TransactionLinesBulk](ExactOnlineREST.FinancialTransaction.TransactionLinesBulk) `VATCode` (Key)
- [GeneralJournalEntryLines](ExactOnlineREST.GeneralJournalEntry.GeneralJournalEntryLines) `VATCode` (Key)
- [MfgSalesOrderlines](ExactOnlineREST.Manufacturing.MfgSalesOrderlines) `VATCode` (Key)
- [InvoiceTerms](ExactOnlineREST.Project.InvoiceTerms) `VATCode` (Key)
- [PurchaseInvoiceLines](ExactOnlineREST.Purchase.PurchaseInvoiceLines) `VATCode` (Key)
- [PurchaseEntryLines](ExactOnlineREST.PurchaseEntry.PurchaseEntryLines) `VATCode` (Key)
- [PurchaseOrderLines](ExactOnlineREST.PurchaseOrder.PurchaseOrderLines) `VATCode` (Key)
- [SalesEntryLines](ExactOnlineREST.SalesEntry.SalesEntryLines) `VATCode` (Key)
- [SalesInvoiceLines](ExactOnlineREST.SalesInvoice.SalesInvoiceLines) `VATCode` (Key)
- [SalesInvoiceLinesBulk](ExactOnlineREST.SalesInvoice.SalesInvoiceLinesBulk) `VATCode` (Key)
- [SalesOrderLines](ExactOnlineREST.SalesOrder.SalesOrderLines) `VATCode` (Key)
- [SalesOrderLinesBulk](ExactOnlineREST.SalesOrder.SalesOrderLinesBulk) `VATCode` (Key)
- [SubscriptionLines](ExactOnlineREST.Subscription.SubscriptionLines) `VATCode` (Key)


## Anmerkungen zu dieser Version

Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert:

- [Exact Online](/de/release-notes/drivers?driver=exact-online)
