---
title: "SalesInvoiceLineItems (Robaws)"
description: "Sales Invoice Line Items"
language: es
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/es/datamodels/robaws/Robaws.SalesInvoiceLineItems.SalesInvoiceLineItems
original: https://documentation.invantive.eu/en/datamodels/robaws/Robaws.SalesInvoiceLineItems.SalesInvoiceLineItems
updated: 2026-11-18T01:12:27Z
license: https://documentation.invantive.eu/es/
---

# SalesInvoiceLineItems: Robaws Sales Invoice Line Items

`read only` `REST`

- Catálogo: `Robaws`
- Esquema: `SalesInvoiceLineItems`
- Label: Sales Invoice Line Items

Buscar

Solo puede recuperar datos.

## Fuente de la API

- Punto final: `/api/v2/sales-invoice-line-items`
- Operación: `get /api/v2/sales-invoice-line-items`

## Características de rendimiento

| Characteristic | Value |
|---|---:|
| Latencia media de acceso (ms) | 157 |
| Número de filas escaneadas por minuto | 13,430 |
| Número de filas de queries puntuales por minuto | 993 |
| Escribir filas por minuto | 539 |

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

## Parámetros

| Name | Tipo de Datos | Required | Default | Documentation |
|---|---|:---:|---|---|
| `articleId` | `` | [ ] |  |  |
| `salesInvoiceId` | `` | [ ] |  |  |
| `searchText` | `` | [ ] |  |  |
| `sort` | `` | [ ] |  |  |
| `updatedFrom` | `` | [ ] |  |  |
| `withArchived` | `` | [ ] |  |  |

## Columnas de la Tabla

A continuación se muestran las columnas de la tabla `SalesInvoiceLineItems`. 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 |
|---|---|---|:---:|---|---|
| `activityId` | `varchar2` | ID de actividad | [ ] | filtros en la plataforma, modificables, `activityId` |  |
| `archivedAt` | `datetime` | Archivado en | [ ] | filtros en la plataforma, modificables, `archivedAt` |  |
| `articleId` | `varchar2` | ID del artículo | [ ] | filtros en la plataforma, modificables, `articleId` |  |
| `createdAt` | `datetime` | Creado en | [ ] | filtros en la plataforma, modificables, `createdAt` |  |
| `deletedAt` | `datetime` | Eliminado el | [ ] | filtros en la plataforma, modificables, `deletedAt` |  |
| `description` | `varchar2` | Description | [ ] | filtros en la plataforma, modificables, `description` |  |
| `discount` | `decimal` | Discount | [ ] | filtros en la plataforma, modificables, `discount` |  |
| `extendedDescription` | `varchar2` | Descripción detallada | [ ] | filtros en la plataforma, modificables, `extendedDescription` |  |
| `extraFields` | `varchar2` | Campos adicionales | [ ] | writable | The JSON text of the nested object. |
| `generalLedgerAccountId` | `varchar2` | ID de la cuenta del Libro Mayor General | [ ] | filtros en la plataforma, modificables, `generalLedgerAccountId` |  |
| `id` | `varchar2` | ID | [ ] | filtros en la plataforma, modificables, `id` |  |
| `installationId` | `varchar2` | ID de instalación | [ ] | filtros en la plataforma, modificables, `installationId` | Deprecated: an installation has no meaning on an invoice line.Returns the line's material, the same as materialId. |
| `lineNumber` | `varchar2` | Número de Línea | [ ] | filtros en la plataforma, modificables, `lineNumber` |  |
| `lockedAt` | `datetime` | Bloqueado en | [ ] | filtros en la plataforma, modificables, `lockedAt` |  |
| `materialId` | `varchar2` | Identificador del material | [ ] | filtros en la plataforma, modificables, `materialId` |  |
| `orderId` | `varchar2` | Identificación de la Orden | [ ] | filtros en la plataforma, modificables, `orderId` |  |
| `postId` | `varchar2` | ID de la publicación | [ ] | filtros en la plataforma, modificables, `postId` |  |
| `price` | `decimal` | Price | [ ] | filtros en la plataforma, modificables, `price` |  |
| `projectId` | `varchar2` | Identificación del Proyecto | [ ] | filtros en la plataforma, modificables, `projectId` |  |
| `quantity` | `decimal` | Quantity | [ ] | filtros en la plataforma, modificables, `quantity` | The line's quantity as stored: never negative on a credit note, unlike the line's money.To count sold quantities net of credit notes, filter or group on links.salesInvoice.attributes.type.In /aggregate, SUM, AVG, MIN and MAX skip the lines that are not part of the invoice total (chapters, titles, text, variants and options); COUNT still counts them. |
| `rentalTicketId` | `varchar2` | N.º de referencia del alquiler | [ ] | filtros en la plataforma, modificables, `rentalTicketId` |  |
| `salesInvoiceId` | `varchar2` | N.º de factura de venta | [ ] | filtros en la plataforma, modificables, `salesInvoiceId` | Only present when obtained via bulk endpoint |
| `styleName` | `varchar2` | Nombre de Estilo | [ ] | filtros en la plataforma, modificables, `styleName` |  |
| `totalExclVat` | `decimal` | Total excluyendo VAT | [ ] | filtros en la plataforma, modificables, `totalExclVat` | The line's total excluding VAT, in its sales invoice's currency (links.salesInvoice.attributes.currency); the exchange rate is not applied.For the line's total in the company's default currency, use totalExclVatInDefaultCurrency.In /aggregate, SUM, AVG, MIN and MAX count a credit note's line negative; /query returns the value as stored.In /aggregate, SUM, AVG, MIN and MAX skip the lines that are not part of the invoice total (chapters, titles, text, variants and options); COUNT still counts them.On the line of an advance or final invoice, SUM, AVG, MIN and MAX in /aggregate count the share that invoice bills (its advance percentage, or the rest on the final invoice), as the invoice's own totals do; /query returns the full amount as stored. |
| `totalExclVatInDefaultCurrency` | `decimal` | Total sin IVA en la moneda predeterminada | [ ] | filtros en la plataforma, modificables, `totalExclVatInDefaultCurrency` | The line's total excluding VAT, converted to the company's default currency at its sales invoice's exchange rate.Use it to add up lines across invoices in different currencies; totalExclVat holds the same total in the invoice's own currency.In /aggregate, SUM, AVG, MIN and MAX count a credit note's line negative; /query returns the value as stored.In /aggregate, SUM, AVG, MIN and MAX skip the lines that are not part of the invoice total (chapters, titles, text, variants and options); COUNT still counts them.On the line of an advance or final invoice, SUM, AVG, MIN and MAX in /aggregate count the share that invoice bills (its advance percentage, or the rest on the final invoice), as the invoice's own totals do; /query returns the full amount as stored. |
| `transportId` | `varchar2` | N.º de transporte | [ ] | filtros en la plataforma, modificables, `transportId` |  |
| `type` | `varchar2` | Type | [ ] | filtros en la plataforma, modificables, `type` |  |
| `unitType` | `varchar2` | Tipo de Unidad | [ ] | filtros en la plataforma, modificables, `unitType` |  |
| `updatedAt` | `datetime` | Actualizado en | [ ] | filtros en la plataforma, modificables, `updatedAt` |  |
| `vatTariffId` | `varchar2` | N.º de identificación del tipo impositivo del IVA | [ ] | filtros en la plataforma, modificables, `vatTariffId` |  |
| `workOrderId` | `varchar2` | N.º de orden de trabajo | [ ] | filtros en la plataforma, modificables, `workOrderId` |  |

## Teclas

| Key | Column | Se refiere a | Kind | Description |
|---|---|---|---|---|
| `SalesInvoiceLineItems_activityId_fk` | `activityId` | [Activities](Robaws.Activities.Activities)`.id` | Key |  |
| `SalesInvoiceLineItems_installationId_fk` | `installationId` | [Installations](Robaws.Installations.Installations)`.id` | Key |  |
| `SalesInvoiceLineItems_projectId_txt` | `projectId` | [Projects](Robaws.Projects.Projects)`.id` | Textual | The referenced row, for as long as Robaws still lists it: a deleted or purged row is no longer listed, and a document may keep referring to it. |
| `SalesInvoiceLineItems_vatTariffId_fk` | `vatTariffId` | [VatTariffs](Robaws.VatTariffs.VatTariffs)`.id` | Key |  |
| `SalesInvoiceLineItems_workOrderId_fk` | `workOrderId` | [WorkOrders](Robaws.WorkOrders.WorkOrders)`.id` | Key |  |


## Notas de la Versión

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

- [ROBAWS](/es/release-notes/drivers?driver=robaws)
