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

# SettlementLineItems: Robaws Settlement Line Items

`read only` `REST`

- Catálogo: `Robaws`
- Esquema: `SettlementLineItems`
- Label: Settlement Line Items

Buscar

Solo puede recuperar datos.

## Fuente de la API

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

## Características de rendimiento

| Characteristic | Value |
|---|---:|
| Latencia media de acceso (ms) | 137 |
| Número de filas escaneadas por minuto | 9,850 |
| Número de filas de queries puntuales por minuto | 670 |
| 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` | `` | [ ] |  |  |
| `searchText` | `` | [ ] |  |  |
| `settlementId` | `` | [ ] |  |  |
| `sort` | `` | [ ] |  |  |
| `updatedFrom` | `` | [ ] |  |  |
| `withArchived` | `` | [ ] |  |  |

## Columnas de la Tabla

A continuación se muestran las columnas de la tabla `SettlementLineItems`. 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 |
|---|---|---|:---:|---|---|
| `agreementType` | `varchar2` | Tipo de acuerdo | [ ] | filtros en la plataforma, modificables, `agreementType` |  |
| `archivedAt` | `datetime` | Archivado en | [ ] | filtros en la plataforma, modificables, `archivedAt` |  |
| `articleId` | `varchar2` | ID del artículo | [ ] | filtros en la plataforma, modificables, `articleId` |  |
| `chapter` | `varchar2` | Chapter | [ ] | filtros en la plataforma, modificables, `chapter` |  |
| `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` |  |
| `extendedDescriptionRendered` | `varchar2` | Descripción ampliada generada | [ ] | filtros en la plataforma, modificables, `extendedDescriptionRendered` | When reading, only present if requested via 'include' query parameter, otherwise null. |
| `extraFields` | `varchar2` | Campos adicionales | [ ] | writable | The JSON text of the nested object. |
| `id` | `varchar2` | ID | [ ] | filtros en la plataforma, modificables, `id` |  |
| `imageId` | `varchar2` | ID de la imagen | [ ] | filtros en la plataforma, modificables, `imageId` |  |
| `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` |  |
| `number` | `varchar2` | Number | [ ] | filtros en la plataforma, modificables, `number` |  |
| `price` | `decimal` | Price | [ ] | filtros en la plataforma, modificables, `price` |  |
| `quantity` | `decimal` | Quantity | [ ] | filtros en la plataforma, modificables, `quantity` | The line's quantity as stored.In /aggregate, SUM, AVG, MIN and MAX skip the lines that are not part of the document's total (chapters, titles, text, variants and options); COUNT still counts them. |
| `quantityFormula` | `varchar2` | Fórmula de la cantidad | [ ] | filtros en la plataforma, modificables, `quantityFormula` |  |
| `settlementId` | `varchar2` | N.º de liquidación | [ ] | filtros en la plataforma, modificables, `settlementId` | Only present when obtained via /api/v2/settlement-line-items or its bulk alias |
| `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 document's currency (the document's 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 skip the lines that are not part of the document's total (chapters, titles, text, variants and options); COUNT still counts them. |
| `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 document's exchange rate.Use it to add up lines of documents in different currencies; totalExclVat holds the same total in the document's own currency.In /aggregate, SUM, AVG, MIN and MAX skip the lines that are not part of the document's total (chapters, titles, text, variants and options); COUNT still counts them. |
| `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` |  |

## Teclas

| Key | Column | Se refiere a | Kind | Description |
|---|---|---|---|---|
| `SettlementLineItems_materialId_fk` | `materialId` | [Materials](Robaws.Materials.Materials)`.id` | Key |  |
| `SettlementLineItems_settlementId_fk` | `settlementId` | [Settlements](Robaws.Settlements.Settlements)`.id` | Key |  |
| `SettlementLineItems_vatTariffId_txt` | `vatTariffId` | [VatTariffs](Robaws.VatTariffs.VatTariffs)`.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. |


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