---
title: "SalesOrderLinesBulk (Exact Online)"
description: "Sales Order Lines (Bulk)"
language: fr
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/fr/datamodels/exactonline/ExactOnlineREST.SalesOrder.SalesOrderLinesBulk
original: https://documentation.invantive.eu/en/datamodels/exactonline/ExactOnlineREST.SalesOrder.SalesOrderLinesBulk
updated: 2026-11-16T20:57:33Z
license: https://documentation.invantive.eu/fr/
---

# SalesOrderLinesBulk: Exact Online Sales Order Lines (Bulk)

`read only` `per partition` `webhook` `REST`

- Catalogue : `ExactOnlineREST`
- Schéma : `SalesOrder`
- Clés primaires : `ID`
- Label: Sales Order Lines (Bulk)

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

Permet uniquement de récupérer des données.

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

## Source de l'API

- Point de terminaison : `/api/v1/{division}/bulk/SalesOrder/SalesOrderLines`
- Métadonnées : `/api/v1/{division}/bulk/SalesOrder/$metadata`

## Caractéristiques de performance

| Characteristic | Value |
|---|---:|
| Latence moyenne d'accès (ms) | 5 |
| Nombre de lignes par minute en mode de balayage complet | 20,000 |
| 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 `SalesOrderLinesBulk` 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] | writable | Amount in the default currency of the company. |
| `AmountFC` | `double` | Montant en devise étrangère | [x] | writable | Amount in the currency of the transaction. |
| `CostCenter` | `varchar2(8)` | Centre de coûts | [ ] | filters on the platform, writable | Reference to Cost Center. |
| `CostCenterDescription` | `varchar2(60)` | Description du centre de coûts | [ ] | writable | Description of cost center. |
| `CostPriceFC` | `double` | Prix de revient en devise étrangère | [ ] | writable | Item cost price. |
| `CostUnit` | `varchar2(8)` | Unité de coût | [ ] | filters on the platform, writable | Reference to Cost Unit. |
| `CostUnitDescription` | `varchar2(60)` | Description des unités de coût | [ ] | writable | Description of cost unit. |
| `CustomerItemCode` | `varchar2` | Code article client | [ ] |  | Code the customer uses for this item. |
| `DeliveryDate` | `datetime` | Date de livraison | [ ] | writable | Delivery date of this line. |
| `Description` | `varchar2` | Description | [ ] | writable | Description. |
| `Discount` | `double` | Discount | [x] | writable | Discount given on the default price.Discount = (DefaultPrice of Item - PriceItem in line) / DefaultPrice of Item. |
| `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. |
| `ID` | `guid` | ID | [x] | filters on the platform, writable | Primary key. |
| `Item` | `guid` | Item | [ ] | filters on the platform, writable | Reference to the Item that is sold in this sales order line. |
| `ItemCode` | `varchar2(30)` | Code de l'article | [ ] | writable | Code of the item. |
| `ItemDescription` | `varchar2(255)` | Description de l’article | [ ] | writable | Description of Item. |
| `ItemVersion` | `guid` | Version de l'élément | [ ] | filters on the platform, writable | Version of item. |
| `ItemVersionDescription` | `varchar2` | Élément Version Description | [ ] | writable | Description of Item Version. |
| `LineNumber` | `int32` | Numéro de ligne | [x] | filters on the platform, writable | Line number. |
| `NetPrice` | `double` | Prix net | [ ] | writable | Net price of the sales order line. |
| `Notes` | `varchar2` | Notes | [ ] | writable | Extra notes. |
| `OrderID` | `guid` | ID de l'ordre | [x] | filters on the platform, writable | Reference to Sales Order.All the lines of a sales order have the same OrderID. |
| `OrderNumber` | `int32` | Numéro de Commande | [x] | filters on the platform, writable | Number of sales order. |
| `Pricelist` | `guid` | Tarif | [ ] | filters on the platform, writable | Reference to Price List. |
| `PricelistDescription` | `varchar2` | Description de la liste des prix | [ ] | writable | Description of Price List. |
| `Project` | `guid` | Project | [ ] | filters on the platform, writable | Reference to Project.The project can be different per line.Sometimes also the project in the header is filled although this is not really used. |
| `ProjectDescription` | `varchar2(60)` | Description du projet | [ ] | writable | Description of Project. |
| `PurchaseOrder` | `guid` | Commande | [ ] | writable | Reference to Purchase Order. |
| `PurchaseOrderLine` | `guid` | Ligne de bon de commande | [ ] | writable | Reference to Purchase Order Line. |
| `PurchaseOrderLineNumber` | `int32` | Numéro de ligne de bon de commande | [ ] | writable | Line number of referenced Purchase Order Line. |
| `PurchaseOrderNumber` | `int32` | Numéro de commande | [ ] | writable | Number of referenced Purchase Order. |
| `Quantity` | `double` | Quantity | [ ] | writable | Number of items sold in default units.The quantity shown in the entry screen is Quantity * UnitFactor. |
| `ShopOrder` | `guid` | Commande d'atelier | [ ] | filters on the platform, writable | Reference to Shop Order. |
| `UnitCode` | `varchar2(8)` | Code de l'unité | [ ] | writable | Code of item unit. |
| `UnitDescription` | `varchar2(60)` | Description d'unité | [ ] | writable | Description of Item Unit. |
| `UnitPrice` | `double` | Prix unitaire | [ ] | writable | Price per unit in the currency of the transaction. |
| `UseDropShipment` | `int16` | Utiliser la livraison directe | [x] | writable | Indicates if drop shipment is used (delivery directly to customer, invoice to wholesaler). |
| `VATAmount` | `double` | Montant TVA | [ ] | writable | VAT amount in the currency of the transaction. |
| `VATCode` | `varchar2(3)` | Code TVA | [ ] | filters on the platform, writable | VAT code. |
| `VATCodeDescription` | `varchar2(60)` | Code TVA Description | [ ] | writable | Description of VAT code. |
| `VATPercentage` | `double` | Pourcentage de TVA | [ ] | writable | The VAT percentage of the VAT code.This is the percentage at the moment the sales order is created.It's also used for the default calculation of VAT amounts and VAT base amounts. |

## Clés

| Key | Column | Se réfère à | Kind | Description |
|---|---|---|---|---|
| `SalesOrderLinesBulk_CostCenter_Costcenters_fk` | `CostCenter` | [Costcenters](ExactOnlineREST.HRM.Costcenters)`.Code` | Key |  |
| `SalesOrderLinesBulk_CostUnit_Costunits_fk` | `CostUnit` | [Costunits](ExactOnlineREST.HRM.Costunits)`.Code` | Key |  |
| `SalesOrderLinesBulk_ItemVersion_ItemVersions_fk` | `ItemVersion` | [ItemVersions](ExactOnlineREST.Logistics.ItemVersions)`.ID` | Key |  |
| `SalesOrderLinesBulk_Item_Items_fk` | `Item` | [Items](ExactOnlineREST.Logistics.Items)`.ID` | Key |  |
| `SalesOrderLinesBulk_OrderID_SalesOrders_fk` | `OrderID` | [SalesOrders](ExactOnlineREST.SalesOrder.SalesOrders)`.OrderID` | Key |  |
| `SalesOrderLinesBulk_Pricelist_SalesPriceLists_fk` | `Pricelist` | [SalesPriceLists](ExactOnlineREST.Sales.SalesPriceLists)`.ID` | Key |  |
| `SalesOrderLinesBulk_Project_Projects_fk` | `Project` | [Projects](ExactOnlineREST.Project.Projects)`.ID` | Key |  |
| `SalesOrderLinesBulk_PurchaseOrderLine_PurchaseOrderLines_fk` | `PurchaseOrderLine` | [PurchaseOrderLines](ExactOnlineREST.PurchaseOrder.PurchaseOrderLines)`.ID` | Key |  |
| `SalesOrderLinesBulk_PurchaseOrder_PurchaseOrders_fk` | `PurchaseOrder` | [PurchaseOrders](ExactOnlineREST.PurchaseOrder.PurchaseOrders)`.PurchaseOrderID` | Key |  |
| `SalesOrderLinesBulk_ShopOrder_ShopOrders_fk` | `ShopOrder` | [ShopOrders](ExactOnlineREST.Manufacturing.ShopOrders)`.ID` | Key |  |
| `SalesOrderLinesBulk_VATCode_VATCodes_fk` | `VATCode` | [VATCodes](ExactOnlineREST.VAT.VATCodes)`.Code` | 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)
