---
title: "SalesEntries (Exact Online)"
description: "Sales Entries"
language: fr
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/fr/datamodels/exactonline/ExactOnlineREST.SalesEntry.SalesEntries
original: https://documentation.invantive.eu/en/datamodels/exactonline/ExactOnlineREST.SalesEntry.SalesEntries
updated: 2026-11-16T20:57:17Z
license: https://documentation.invantive.eu/fr/
---

# SalesEntries: Exact Online Sales Entries

`popular` `insert` `update` `delete` `per partition` `webhook` `REST`

- Catalogue : `ExactOnlineREST`
- Schéma : `SalesEntry`
- Clés primaires : `EntryID`
- Label: Sales Entries

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`.

Les modifications sont transmises via le sujet de webhook `SalesEntries`.

## Source de l'API

- Point de terminaison : `/api/v1/{division}/salesentry/SalesEntries`
- Métadonnées : `/api/v1/{division}/salesentry/$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 `SalesEntries` 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 |
|---|---|---|:---:|---|---|
| `AmountDC` | `double` | Montant Division Devise | [x] | filters on the platform, writable | Amount in the default currency of the company.For the header lines (LineNumber = 0) of an entry this is the SUM(AmountDC) of all lines. |
| `AmountFC` | `double` | Montant en devise étrangère | [x] | filters on the platform, writable | Amount in the currency of the transaction.For the header this is the sum of all lines, including VAT. |
| `BatchNumber` | `int32` | Numéro de lot | [ ] | filters on the platform, writable | The number of the batch of entries.Normally a batch consists of multiple entries.Batchnumbers are filled for invoices created by: - Fixed entries - Prolongation (only available with module hosting). |
| `Created` | `datetime` | Created | [x] | 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. |
| `Currency` | `varchar2(30)` | Currency | [ ] | filters on the platform, writable | Currency for the invoice.By default this is the currency of the administration. |
| `CustomField` | `varchar2` | Champ personnalisé | [ ] | writable |  |
| `Customer` | `guid` | Customer | [ ] | filters on the platform, writable | Reference to customer (account). |
| `CustomerName` | `varchar2(50)` | Nom du client | [ ] | filters on the platform, writable | Name of customer. |
| `Description` | `varchar2` | Description | [ ] | filters on the platform, writable | Description.Can be different for header and lines. |
| `Division` | `int32` | Division | [x] |  | 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. |
| `Document` | `guid` | Document | [ ] | filters on the platform, writable | Document that is manually linked to the invoice. |
| `DocumentNumber` | `int32` | Numéro de document | [ ] | filters on the platform, writable | Number of the document. |
| `DocumentSubject` | `varchar2(256)` | Objet du document | [ ] | filters on the platform, writable | Subject of the document. |
| `DueDate` | `datetime` | Date d'Échéance | [ ] | filters on the platform, writable | The due date for payments.This date is calculated based on the EntryDate and the Paymentcondition. |
| `EntryDate` | `datetime` | Date d'entrée | [ ] | filters on the platform, writable | The date when the invoice is entered. |
| `EntryID` | `guid` | Identifiant de l'entrée | [x] | filters on the platform, writable | The unique ID of the entry.Via this ID all transaction lines of a single entry can be retrieved. |
| `EntryNumber` | `int32` | Numéro d'inscription | [ ] | filters on the platform, writable | Entry number. |
| `ExternalLinkDescription` | `varchar2` | Description du lien externe | [ ] | filters on the platform, writable | Description of ExternalLink. |
| `ExternalLinkReference` | `varchar2` | Référence à un lien externe | [ ] | filters on the platform, writable | Reference of ExternalLink. |
| `GAccountAmountFC` | `double` | Compte G Montant Devise étrangère | [ ] | filters on the platform, writable | A positive value of the amount indicates that the amount is to be paid by the customer to your G bank account.In case of a credit invoice the amount should have negative value when retrieved or posted to Exact. |
| `InvoiceNumber` | `int32` | Numéro de facture | [ ] | filters on the platform, writable | Assigned at entry or at printing depending on setting.The number assigned is based on the freenumbers as defined for the Journal.When printing the field InvoiceNumber is copied to the fields EntryNumber and InvoiceNumber of the sales entry. |
| `IsExtraDuty` | `char` | S'agit-il d'heures supplémentaires ? | [ ] | filters on the platform, writable | Indicates whether the invoice has extra duty. |
| `Journal` | `varchar2(20)` | Journal | [ ] | filters on the platform, writable | The journal code.Every invoice should be linked to a sales journal. |
| `JournalDescription` | `varchar2(60)` | Description de la revue | [ ] | filters on the platform, writable | Description of Journal. |
| `Modified` | `datetime` | Modified | [x] | 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. |
| `NetAmountDC` | `double` | Montant net Division Devise | [ ] | writable | Net amount in division currency of sales entry. |
| `NetAmountFC` | `double` | Montant net en devise étrangère | [ ] | writable | Net amount in foreign currency of sales entry. |
| `OrderNumber` | `int32` | Numéro de Commande | [ ] | filters on the platform, writable | Number to indentify the invoice.Order numbers are not unique.Default the number is based on a setting for the first free number. |
| `PaymentCondition` | `varchar2(2)` | Condition de paiement | [ ] | filters on the platform, writable | The payment condition used for due date and discount calculation. |
| `PaymentConditionDescription` | `varchar2(60)` | Description des conditions de paiement | [ ] | filters on the platform, writable | Description of PaymentCondition. |
| `PaymentConditionPaymentMethod` | `varchar2` | itgen_eol_paymentconditionpaymentmethod | [ ] | filtres disponibles sur la plateforme |  |
| `PaymentReference` | `varchar2(60)` | Référence de réglement | [ ] | filters on the platform, writable | The payment reference used for bank imports, VAT return and Tax reference. |
| `ProcessNumber` | `int32` | Numéro de dossier | [ ] | filters on the platform, writable |  |
| `Rate` | `double` | Rate | [ ] | filters on the platform, writable | Foreign currency rate. |
| `ReportingPeriod` | `int16` | Période couverte par le rapport | [ ] | filters on the platform, writable | The period of the transaction lines.The period should exist in the period date table. |
| `ReportingYear` | `int16` | Année de référence | [ ] | filters on the platform, writable | The financial year to which the entry belongs.The financial year should exist in the period date table. |
| `Reversal` | `char` | Reversal | [x] | filters on the platform, writable | Indicates if amounts are reversed. |
| `Status` | `int16` | Status | [ ] | filters on the platform, writable | Status: 5 = Rejected, 20 = Open, 50 = Processed. |
| `StatusDescription` | `varchar2` | Description de l'état | [ ] | writable | Description of Status. |
| `Type` | `int32` | Type | [x] | filters on the platform, writable | Type: 20 = Sales entry, 21 = Sales credit note. |
| `TypeDescription` | `varchar2(240)` | Description du type | [ ] | writable | Description of Type. |
| `VATAmountDC` | `double` | Montant de la TVA / Division / Devise | [ ] | filters on the platform, writable | Vat amount in the default currency of the company. |
| `VATAmountFC` | `double` | Montant de la TVA en devise étrangère | [ ] | filters on the platform, writable | Vat amount in the currency of the transaction. |
| `WithholdingTaxAmountDC` | `double` | itgen_eol_withholdingtaxamountdc | [ ] | filters on the platform, writable | Withholding tax amount. |
| `WithholdingTaxBaseAmount` | `double` | Montant de base de la retenue à la source | [ ] | filters on the platform, writable | Withholding tax base amount to calculate withholding amount. |
| `WithholdingTaxPercentage` | `double` | Retenue à la source (%) | [ ] | filters on the platform, writable | Withholding tax percentage. |
| `YourRef` | `varchar2(60)` | Votre référence | [ ] | filters on the platform, writable | The invoice number of the customer. |

## Clés

| Key | Column | Se réfère à | Kind | Description |
|---|---|---|---|---|
| `SalesEntries_Creator_Users_fk` | `Creator` | [Users](ExactOnlineREST.Users.Users)`.UserID` | Key |  |
| `SalesEntries_Currency_Currencies_fk` | `Currency` | [Currencies](ExactOnlineREST.General.Currencies)`.Code` | Key |  |
| `SalesEntries_Customer_Accounts_fk` | `Customer` | [Accounts](ExactOnlineREST.CRM.Accounts)`.ID` | Key |  |
| `SalesEntries_Document_Documents_fk` | `Document` | [Documents](ExactOnlineREST.Documents.Documents)`.ID` | Key |  |
| `SalesEntries_Journal_Journals_fk` | `Journal` | [Journals](ExactOnlineREST.Financial.Journals)`.Code` | Key |  |
| `SalesEntries_Modifier_Users_fk` | `Modifier` | [Users](ExactOnlineREST.Users.Users)`.UserID` | 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)
