---
title: "VATCodes (Exact Online)"
description: "VAT Codes"
language: fr
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/fr/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/fr/
---

# VATCodes: Exact Online VAT Codes

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

- Catalogue : `ExactOnlineREST`
- Schéma : `VAT`
- Clés primaires : `ID`
- Label: VAT Codes

Les données de cette table sont partitionnées en fonction de la valeur de la colonne `Division`.

Permet de récupérer et de modifier des données à l'aide de `insert`, `update` et `delete`.

## Source de l'API

- Point de terminaison : `/api/v1/{division}/vat/VATCodes`
- Métadonnées : `/api/v1/{division}/vat/$metadata`

## Caractéristiques de performance

| Characteristic | Value |
|---|---:|
| Latence moyenne d'accès (ms) | 5 |
| Nombre de lignes par minute en mode de balayage complet | 7,200 |
| Nombre de lignes de requêtes ponctuelles par minute | 300 |
| Nombre d'enregistrements écrits par minute | 300 |

Le résultat peut être mis en cache côté client.

## Colonnes de table

Les colonnes de la table `VATCodes` sont présentées ci-dessous. Chaque colonne possède un type de données SQL. Une nouvelle valeur non nulle doit être fournie pour chaque colonne requise à tout moment lors de l'insertion et de la mise à jour.

| Name | Type de données | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `Account` | `guid` | Account | [ ] | filters on the platform, writable | Tax account. |
| `AccountCode` | `varchar2(18)` | Code du compte | [ ] | filters on the platform, writable | Code of Account. |
| `AccountName` | `varchar2(50)` | Nom du compte | [ ] | 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` | Créé | [ ] | writable | Creation date in UTC. |
| `Creator` | `guid` | Creator | [ ] | filters on the platform, writable | User ID of creator. |
| `CreatorFullName` | `varchar2(240)` | Nom complet de l'auteur | [ ] | filters on the platform, writable | Name of creator. |
| `CustomField` | `varchar2` | Champ personnalisé | [ ] | writable |  |
| `Description` | `varchar2(60)` | Description | [ ] | filters on the platform, writable | Description of the VAT code. |
| `Division` | `int32` | Division | [ ] |  | Division code. |
| `DivisionCompanyCoCNumber` | `varchar2(60)` | Numéro d'enregistrement à la Chambre de commerce de la division | [ ] | writable | Chamber of commerce number of the Exact Online division. |
| `DivisionCompanyIBANNumber` | `varchar2(50)` | Numéro IBAN de la division | [ ] | writable | IBAN number of the Exact Online division. |
| `DivisionCompanyName` | `varchar2(50)` | Division - Nom de l'entreprise | [x] | writable | Company name of the Exact Online division. |
| `DivisionCompanyRSINNumber` | `varchar2(9)` | Numéro de division RSIN | [ ] | writable | RSIN number of the Exact Online division. |
| `DivisionCompanyVATNumber` | `varchar2(35)` | Numéro de TVA de la division | [ ] | writable | VAT number of the Exact Online division. |
| `DivisionCompanyWageTaxNumber` | `varchar2(60)` | Numéro d'identification fiscale de la division | [ ] | writable | Wage tax number of the Exact Online division. |
| `DivisionLabel` | `varchar2(128)` | Étiquette de division | [x] | writable | Label of the Exact Online division. |
| `DivisionName` | `varchar2(50)` | Nom de l'administration | [x] | writable | Name of the Exact Online division. |
| `DivisionOwnerCompanyName` | `varchar2(50)` | Nom du titulaire de l'abonnement | [x] | writable | Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs. |
| `DivisionOwnerCompanyNumber` | `varchar2(18)` | Numéro d'abonné | [x] | writable | Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs. |
| `DivisionShortName` | `int64` | Nom abrégé de la division | [x] | writable | Short name of the Exact Online division. |
| `EUSalesListing` | `varchar2(1)` | Liste des produits en vente dans l'UE | [ ] | 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` | Liste hors TVA | [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)` | Type Intrastat | [ ] | 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` | Est bloqué | [ ] | filters on the platform, writable | Indicates if the VAT code may still be used. |
| `LegalText` | `varchar2(150)` | Texte légal | [ ] | 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` | Modifié (UTC) | [ ] | writable | Last modified date in UTC. |
| `Modifier` | `guid` | Modifier | [ ] | filters on the platform, writable | User ID of modifier. |
| `ModifierFullName` | `varchar2(240)` | Nom complet modifié | [ ] | filters on the platform, writable | Name of modifier. |
| `OssCountry` | `varchar2` | Pays OSS | [ ] | filtres disponibles sur la plateforme |  |
| `Percentage` | `double` | Percentage | [ ] | filters on the platform, writable | Percentage of the VAT code. |
| `TaxReturnType` | `int16` | Type de déclaration d'impôt | [ ] | 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` | Taux partiel de TVA | [ ] | 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)` | Type d'opération TVA | [ ] | 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)` | Type de document de TVA | [ ] | 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` | Marge TVA | [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). |

## Clés

| Key | Column | Se réfère à | 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 |  |

## Référencée

- [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)


## Notes de Version

Quels ont été les changements apportés à chaque version au niveau des tables, des colonnes, des attributs et des fonctionnalités du chauffeur :

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