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

# SalesOrderLines: Exact Online Sales Order Lines

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

- Catálogo: `ExactOnlineREST`
- Esquema: `SalesOrder`
- Llaves Primarias: `ID`
- Label: Sales Order Lines

Los datos de esta tabla están divididos por el valor de la columna `Division`.

Permite recuperar y modificar datos utilizando `insert`, `update` y `delete`.

Los cambios llegan a través del tema de webhook `SalesOrders` en `OrderID`.

## Fuente de la API

- Punto final: `/api/v1/{division}/salesorder/SalesOrderLines`
- Metadatos: `/api/v1/{division}/salesorder/$metadata`

## Características de rendimiento

| Characteristic | Value |
|---|---:|
| Latencia media de acceso (ms) | 5 |
| Número de filas escaneadas por minuto | 7,200 |
| Número de filas de queries puntuales por minuto | 300 |
| Escribir filas por minuto | 300 |

El resultado se puede almacenar en la Caché del cliente.

## Columnas de la Tabla

A continuación se muestran las columnas de la tabla `SalesOrderLines`. Cada columna tiene un tipo de datos SQL. Se debe proporcionar un nuevo valor no nulo para cada columna requerida en todo momento durante la inserción y la actualización.

| Name | Tipo de Datos | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `AmountDC` | `double` | Importe División Moneda | [x] | writable | Amount in the default currency of the company. |
| `AmountFC` | `double` | Cantidad Moneda Extranjera | [x] | writable | Amount in the currency of the transaction. |
| `CostCenter` | `varchar2(8)` | Centro de Costo | [ ] | filters on the platform, writable | Reference to Cost Center. |
| `CostCenterDescription` | `varchar2(60)` | Descripción del Centro de Costo | [ ] | writable | Description of cost center. |
| `CostPriceFC` | `double` | Precio de coste en moneda extranjera | [ ] | writable | Item cost price. |
| `CostUnit` | `varchar2(8)` | Unidad de Costo | [ ] | filters on the platform, writable | Reference to Cost Unit. |
| `CostUnitDescription` | `varchar2(60)` | Descripción de la Unidad de Costo | [ ] | writable | Description of cost unit. |
| `CustomField` | `varchar2` | Campo personalizado | [ ] | filtros de la plataforma |  |
| `CustomerItemCode` | `varchar2` | Código de artículo del cliente | [ ] |  | Code the customer uses for this item. |
| `DeliveryDate` | `datetime` | Fecha de Entrega | [ ] | filters on the platform, writable | Delivery date of this line. |
| `DeliveryStatus` | `int16` | Estado de la Entrega | [ ] | filters on the platform, writable | Shipping status of the sales order line.12=Open, 20=Partial, 21=Complete, 45=Cancelled. |
| `Description` | `varchar2` | Description | [ ] | filters on the platform, writable | Description. |
| `Discount` | `double` | Discount | [ ] | 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)` | Número de la Cámara de Comercio de la División | [ ] | writable | Chamber of commerce number of the Exact Online division. |
| `DivisionCompanyIBANNumber` | `varchar2(50)` | Número IBAN de la división | [ ] | writable | IBAN number of the Exact Online division. |
| `DivisionCompanyName` | `varchar2(50)` | División: Nombre de la empresa | [x] | writable | Company name of the Exact Online division. |
| `DivisionCompanyRSINNumber` | `varchar2(9)` | Número de la división RSIN | [ ] | writable | RSIN number of the Exact Online division. |
| `DivisionCompanyVATNumber` | `varchar2(35)` | Número de IVA de la división | [ ] | writable | VAT number of the Exact Online division. |
| `DivisionCompanyWageTaxNumber` | `varchar2(60)` | Número de identificación fiscal de la división en materia de impuestos sobre los salarios | [ ] | writable | Wage tax number of the Exact Online division. |
| `DivisionLabel` | `varchar2(128)` | Etiqueta de división | [x] | writable | Label of the Exact Online division. |
| `DivisionName` | `varchar2(50)` | Nombre de la Adminisración | [x] | writable | Name of the Exact Online division. |
| `DivisionOwnerCompanyName` | `varchar2(50)` | Nombre del titular de la suscripción | [x] | writable | Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs. |
| `DivisionOwnerCompanyNumber` | `varchar2(18)` | Número de titular de la suscripción | [x] | writable | Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs. |
| `DivisionShortName` | `int64` | Nombre abreviado de la división | [x] | writable | Short name of the Exact Online division. |
| `ID` | `guid` | ID | [x] | filters on the platform, writable | Primary key. |
| `InvoiceStatus` | `int16` | Estatus de la Factura | [ ] | filters on the platform, writable | Invoice status of the sales order line.12=Open, 20=Partial, 21=Complete, 45=Cancelled. |
| `Item` | `guid` | Item | [ ] | filters on the platform, writable | Reference to the Item that is sold in this sales order line. |
| `ItemCode` | `varchar2(30)` | Código del Artículo | [ ] | writable | Code of the item. |
| `ItemDescription` | `varchar2(255)` | Descripción del Elemento | [ ] | writable | Description of Item. |
| `ItemVersion` | `guid` | Versión del artículo | [ ] | filters on the platform, writable | Version of item. |
| `ItemVersionDescription` | `varchar2` | Artículo Versión Descripción | [ ] | writable | Description of Item Version. |
| `LineNumber` | `int32` | Número de Línea | [x] | filters on the platform, writable | Line number. |
| `Margin` | `double` | Margin | [ ] | writable | Sales margin of the sales order line. |
| `NetPrice` | `double` | Precio Neto | [ ] | writable | Net price of the sales order line. |
| `Notes` | `varchar2` | Notes | [ ] | writable | Extra notes. |
| `OrderID` | `guid` | Identificación de la Orden | [x] | filters on the platform, writable | Reference to Sales Order.All the lines of a sales order have the same OrderID. |
| `OrderNumber` | `int32` | Número de la Orden | [x] | filters on the platform, writable | Number of sales order. |
| `OrderStatus` | `int16` | Estado de la Orden | [ ] | filters on the platform, writable | The status of the sales order line.12=Open, 20=Partial, 21=Complete, 45=Cancelled. |
| `Pricelist` | `guid` | Lista de Precios | [ ] | filters on the platform, writable | Reference to Price List. |
| `PricelistDescription` | `varchar2` | Descripción de la Lista de Precios | [ ] | 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)` | Descripción del Proyecto | [ ] | writable | Description of Project. |
| `PurchaseOrder` | `guid` | Orden de Compra | [ ] | writable | Reference to Purchase Order. |
| `PurchaseOrderLine` | `guid` | Línea de Orden de Compra | [ ] | writable | Reference to Purchase Order Line. |
| `PurchaseOrderLineNumber` | `int32` | Número de línea de la orden de compra | [ ] | writable | Line number of referenced Purchase Order Line. |
| `PurchaseOrderNumber` | `int32` | Número de Orden de Compra | [ ] | 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. |
| `QuantityDelivered` | `double` | Cantidad entregada | [ ] | writable | The number of items delivered. |
| `QuantityInvoiced` | `double` | Cantidad facturada | [ ] | writable | The number of items invoiced. |
| `ShopOrder` | `guid` | Orden de Producción | [ ] | filters on the platform, writable | Reference to Shop Order. |
| `TaxSchedule` | `guid` | Calendario fiscal | [ ] | writable | Obsolete. |
| `TaxScheduleCode` | `varchar2` | Código del baremo fiscal | [ ] | writable | Obsolete. |
| `TaxScheduleDescription` | `varchar2` | Descripción del calendario fiscal | [ ] | writable | Obsolete. |
| `UnitCode` | `varchar2(8)` | Código de la Unidad | [ ] | writable | Code of item unit. |
| `UnitDescription` | `varchar2(60)` | Descripción de la Unidad | [ ] | writable | Description of Item Unit. |
| `UnitPrice` | `double` | Precio de la Unidad | [ ] | writable | Price per unit in the currency of the transaction. |
| `UseDropShipment` | `int16` | Utilizar Entrega Directa | [x] | filters on the platform, writable | Indicates if drop shipment is used (delivery directly to customer, invoice to wholesaler). |
| `VATAmount` | `double` | Cantidad VAT | [ ] | writable | VAT amount in the currency of the transaction. |
| `VATCode` | `varchar2(3)` | Código VAT | [ ] | filters on the platform, writable | VAT code. |
| `VATCodeDescription` | `varchar2(60)` | Descripción del Código VAT | [ ] | writable | Description of VAT code. |
| `VATPercentage` | `double` | Porcentaje VAT | [ ] | 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. |

## Teclas

| Key | Column | Se refiere a | Kind | Description |
|---|---|---|---|---|
| `SalesOrderLines_CostCenter_Costcenters_fk` | `CostCenter` | [Costcenters](ExactOnlineREST.HRM.Costcenters)`.Code` | Key |  |
| `SalesOrderLines_CostUnit_Costunits_fk` | `CostUnit` | [Costunits](ExactOnlineREST.HRM.Costunits)`.Code` | Key |  |
| `SalesOrderLines_ItemVersion_ItemVersions_fk` | `ItemVersion` | [ItemVersions](ExactOnlineREST.Logistics.ItemVersions)`.ID` | Key |  |
| `SalesOrderLines_Item_Items_fk` | `Item` | [Items](ExactOnlineREST.Logistics.Items)`.ID` | Key |  |
| `SalesOrderLines_OrderID_SalesOrders_fk` | `OrderID` | [SalesOrders](ExactOnlineREST.SalesOrder.SalesOrders)`.OrderID` | Key |  |
| `SalesOrderLines_Pricelist_SalesPriceLists_fk` | `Pricelist` | [SalesPriceLists](ExactOnlineREST.Sales.SalesPriceLists)`.ID` | Key |  |
| `SalesOrderLines_Project_Projects_fk` | `Project` | [Projects](ExactOnlineREST.Project.Projects)`.ID` | Key |  |
| `SalesOrderLines_PurchaseOrderLine_PurchaseOrderLines_fk` | `PurchaseOrderLine` | [PurchaseOrderLines](ExactOnlineREST.PurchaseOrder.PurchaseOrderLines)`.ID` | Key |  |
| `SalesOrderLines_PurchaseOrder_PurchaseOrders_fk` | `PurchaseOrder` | [PurchaseOrders](ExactOnlineREST.PurchaseOrder.PurchaseOrders)`.PurchaseOrderID` | Key |  |
| `SalesOrderLines_ShopOrder_ShopOrders_fk` | `ShopOrder` | [ShopOrders](ExactOnlineREST.Manufacturing.ShopOrders)`.ID` | Key |  |
| `SalesOrderLines_VATCode_VATCodes_fk` | `VATCode` | [VATCodes](ExactOnlineREST.VAT.VATCodes)`.Code` | Key |  |

## Referenciado por

- [PurchaseOrderLines](ExactOnlineREST.PurchaseOrder.PurchaseOrderLines) `SalesOrderLine` (Key)
- [SalesInvoiceLines](ExactOnlineREST.SalesInvoice.SalesInvoiceLines) `SalesOrderLine` (Key)
- [SalesInvoiceLinesBulk](ExactOnlineREST.SalesInvoice.SalesInvoiceLinesBulk) `SalesOrderLine` (Key)
- [DigitalOrderPickingLines](ExactOnlineREST.SalesOrder.DigitalOrderPickingLines) `SalesOrderLineID` (Key)
- [GoodsDeliveryLines](ExactOnlineREST.SalesOrder.GoodsDeliveryLines) `SalesOrderLineID` (Key)
- [GoodsDeliveryLinesBulk](ExactOnlineREST.SalesOrder.GoodsDeliveryLinesBulk) `SalesOrderLineID` (Key)
- [PlannedSalesReturnLines](ExactOnlineREST.SalesOrder.PlannedSalesReturnLines) `SalesOrderLineID` (Key)


## Notas de la Versión

Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador:

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