---
title: "StockChanges (Robaws)"
description: "Stock Changes"
language: es
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/es/datamodels/robaws/Robaws.StockChanges.StockChanges
original: https://documentation.invantive.eu/en/datamodels/robaws/Robaws.StockChanges.StockChanges
updated: 2026-11-18T01:12:33Z
license: https://documentation.invantive.eu/es/
---

# StockChanges: Robaws Stock Changes

`insert` `update` `delete` `REST`

- Catálogo: `Robaws`
- Esquema: `StockChanges`
- Llaves Primarias: `id`
- Label: Stock Changes

Buscar

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

## Fuente de la API

- Punto final: `/api/v2/stock-changes`
- Operación: `get /api/v2/stock-changes`

## Características de rendimiento

| Characteristic | Value |
|---|---:|
| Latencia media de acceso (ms) | 100 |
| Número de filas escaneadas por minuto | 37,848 |
| Número de filas de queries puntuales por minuto | 792 |
| 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` | `` | [ ] |  |  |
| `assignedEmployeeId` | `` | [ ] |  |  |
| `deliveryNoteId` | `` | [ ] |  |  |
| `isBookedOnly` | `` | [ ] |  |  |
| `materialId` | `` | [ ] |  |  |
| `orderId` | `` | [ ] |  |  |
| `projectId` | `` | [ ] |  |  |
| `salesOrderId` | `` | [ ] |  |  |
| `searchText` | `` | [ ] |  |  |
| `sort` | `` | [ ] |  |  |
| `supplyOrderId` | `` | [ ] |  |  |
| `updatedFrom` | `` | [ ] |  |  |
| `withArchived` | `` | [ ] |  |  |
| `workOrderId` | `` | [ ] |  |  |

## Columnas de la Tabla

A continuación se muestran las columnas de la tabla `StockChanges`. 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 |
|---|---|---|:---:|---|---|
| `archivedAt` | `datetime` | Archivado en | [ ] | filtros en la plataforma, modificables, `archivedAt` |  |
| `assignedEmployeeId` | `varchar2` | N.º de identificación del empleado asignado | [ ] | filtros en la plataforma, modificables, `assignedEmployeeId` |  |
| `assignedSupplierId` | `varchar2` | N.º de identificación del proveedor asignado | [ ] | filtros en la plataforma, modificables, `assignedSupplierId` |  |
| `assignedUserId` | `varchar2` | ID de usuario asignado | [ ] | filtros en la plataforma, modificables, `assignedUserId` |  |
| `booked` | `char` | Booked | [ ] | filtros en la plataforma, modificables, `booked` |  |
| `bookedAt` | `datetime` | Reservado en | [ ] | filtros en la plataforma, modificables, `bookedAt` | The exact moment the stock change was booked, with the time of day (bookingDate holds only the date).Empty while the stock change is not booked.It is set while the booking is processed, before the booking is saved and the stock is revalued, so a booking only becomes visible some time after this moment; on a large stock that delay can be several minutes or more.Use it to order bookings within one day.To fetch changes incrementally, let each window overlap the previous one generously and skip ids you already have. |
| `bookingDate` | `datetime` | Fecha de la reserva | [ ] | filtros en la plataforma, modificables, `bookingDate` |  |
| `createdAt` | `datetime` | Creado en | [ ] | filtros en la plataforma, modificables, `createdAt` |  |
| `date` | `datetime` | Date | [ ] | filtros en la plataforma, modificables, `date` |  |
| `deletedAt` | `datetime` | Eliminado el | [ ] | filtros en la plataforma, modificables, `deletedAt` |  |
| `deliveryNoteId` | `varchar2` | N.º de albarán | [ ] | filtros en la plataforma, modificables, `deliveryNoteId` |  |
| `description` | `varchar2` | Description | [ ] | filtros en la plataforma, modificables, `description` |  |
| `enumeration` | `char` | Enumeration | [ ] | filtros en la plataforma, modificables, `enumeration` |  |
| `extraFields` | `varchar2` | Campos adicionales | [ ] | writable | The JSON text of the nested object. |
| `fromLocationId` | `varchar2` | Desde el ID de ubicación | [ ] | filtros en la plataforma, modificables, `fromLocationId` |  |
| `id` | `varchar2` | ID | [ ] | filtros en la plataforma, modificables, `id` |  |
| `lockedAt` | `datetime` | Bloqueado en | [ ] | filtros en la plataforma, modificables, `lockedAt` |  |
| `logicId` | `varchar2` | Identificador lógico | [ ] | filtros en la plataforma, modificables, `logicId` |  |
| `salesOrderId` | `varchar2` | N.º de pedido de venta | [ ] | filtros en la plataforma, modificables, `salesOrderId` |  |
| `status` | `varchar2` | Status | [ ] | filtros en la plataforma, modificables, `status` |  |
| `supplyOrderId` | `varchar2` | N.º de pedido de suministro | [ ] | filtros en la plataforma, modificables, `supplyOrderId` |  |
| `supplyOrder_archivedAt` | `datetime` | Pedido de suministro archivado en | [ ] | filtros en la plataforma, modificables, `supplyOrder.archivedAt` |  |
| `supplyOrder_assignedUserId` | `varchar2` | N.º de usuario asignado al pedido de suministro | [ ] | filtros en la plataforma, modificables, `supplyOrder.assignedUserId` |  |
| `supplyOrder_companyId` | `varchar2` | N.º de identificación de la empresa en el pedido de suministro | [ ] | filtros en la plataforma, modificables, `supplyOrder.companyId` |  |
| `supplyOrder_completed` | `char` | Pedido de suministro completado | [ ] | filtros en la plataforma, modificables, `supplyOrder.completed` |  |
| `supplyOrder_completionPercentage` | `decimal` | Porcentaje de cumplimiento de los pedidos de suministro | [ ] | filtros en la plataforma, modificables, `supplyOrder.completionPercentage` |  |
| `supplyOrder_createdAt` | `datetime` | Pedido de suministro creado el | [ ] | filtros en la plataforma, modificables, `supplyOrder.createdAt` |  |
| `supplyOrder_deletedAt` | `datetime` | Pedido de suministro eliminado el | [ ] | filtros en la plataforma, modificables, `supplyOrder.deletedAt` |  |
| `supplyOrder_extraFields` | `varchar2` | Campos adicionales de la orden de suministro | [ ] | writable | The JSON text of the nested object. |
| `supplyOrder_footerText` | `varchar2` | Texto del pie de página de la orden de suministro | [ ] | filtros en la plataforma, modificables, `supplyOrder.footerText` | When reading, only present if requested via 'include' query parameter, otherwise null.HTML content.Embedded images are resolved to URLs based on the 'x-robaws-html-image-mode' request header: TEMPORARY_URL (default) returns time-limited presigned URLs that require no authentication; PERMANENT_URL returns stable URLs that require an authenticated session; NONE returns the stored HTML, where each image is an <img> with a data-robaws-id and an empty src — keep that tag and its data-robaws-id when writing the HTML back, or the image is lost.Any other value (e.g.BASE64_INLINE) returns 400 Bad Request.When writing, omit it or send null to keep the current text; send an empty string to clear it. |
| `supplyOrder_id` | `varchar2` | N.º de pedido de suministro | [ ] | filtros en la plataforma, modificables, `supplyOrder.id` |  |
| `supplyOrder_introText` | `varchar2` | Texto introductorio de la orden de suministro | [ ] | filtros en la plataforma, modificables, `supplyOrder.introText` | When reading, only present if requested via 'include' query parameter, otherwise null.HTML content.Embedded images are resolved to URLs based on the 'x-robaws-html-image-mode' request header: TEMPORARY_URL (default) returns time-limited presigned URLs that require no authentication; PERMANENT_URL returns stable URLs that require an authenticated session; NONE returns the stored HTML, where each image is an <img> with a data-robaws-id and an empty src — keep that tag and its data-robaws-id when writing the HTML back, or the image is lost.Any other value (e.g.BASE64_INLINE) returns 400 Bad Request.When writing, omit it or send null to keep the current text; send an empty string to clear it. |
| `supplyOrder_lockedAt` | `datetime` | Pedido de suministro bloqueado en | [ ] | filtros en la plataforma, modificables, `supplyOrder.lockedAt` |  |
| `supplyOrder_logicId` | `varchar2` | ID de la lógica de pedido de suministro | [ ] | filtros en la plataforma, modificables, `supplyOrder.logicId` |  |
| `supplyOrder_reference` | `varchar2` | Referencia del pedido de suministro | [ ] | filtros en la plataforma, modificables, `supplyOrder.reference` |  |
| `supplyOrder_remark` | `varchar2` | Observación sobre el pedido de suministro | [ ] | filtros en la plataforma, modificables, `supplyOrder.remark` |  |
| `supplyOrder_status` | `varchar2` | Estado del pedido de suministro | [ ] | filtros en la plataforma, modificables, `supplyOrder.status` |  |
| `supplyOrder_totalExclVat` | `decimal` | Total del pedido de suministro, sin IVA | [ ] | filtros en la plataforma, modificables, `supplyOrder.totalExclVat` |  |
| `supplyOrder_totalInclVat` | `decimal` | Total del pedido de suministro, IVA incluido | [ ] | filtros en la plataforma, modificables, `supplyOrder.totalInclVat` |  |
| `supplyOrder_type` | `varchar2` | Tipo de pedido de suministro | [ ] | filtros en la plataforma, modificables, `supplyOrder.type` |  |
| `supplyOrder_updatedAt` | `datetime` | Pedido de suministro actualizado el | [ ] | filtros en la plataforma, modificables, `supplyOrder.updatedAt` |  |
| `toClientId` | `varchar2` | Client ID | [ ] | filtros en la plataforma, modificables, `toClientId` |  |
| `toLocationId` | `varchar2` | A la identificación de la ubicación | [ ] | filtros en la plataforma, modificables, `toLocationId` |  |
| `updatedAt` | `datetime` | Actualizado en | [ ] | filtros en la plataforma, modificables, `updatedAt` |  |
| `workOrderId` | `varchar2` | N.º de orden de trabajo | [ ] | filtros en la plataforma, modificables, `workOrderId` |  |

## Teclas

| Key | Column | Se refiere a | Kind | Description |
|---|---|---|---|---|
| `StockChanges_assignedEmployeeId_fk` | `assignedEmployeeId` | [Employees](Robaws.Employees.Employees)`.id` | Key |  |
| `StockChanges_assignedSupplierId_fk` | `assignedSupplierId` | [Suppliers](Robaws.Suppliers.Suppliers)`.id` | Key |  |
| `StockChanges_assignedUserId_txt` | `assignedUserId` | [Users](Robaws.Users.Users)`.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. |
| `StockChanges_deliveryNoteId_fk` | `deliveryNoteId` | [DeliveryNotes](Robaws.DeliveryNotes.DeliveryNotes)`.id` | Key |  |
| `StockChanges_fromLocationId_fk` | `fromLocationId` | [StockLocations](Robaws.StockLocations.StockLocations)`.id` | Key |  |
| `StockChanges_salesOrderId_fk` | `salesOrderId` | [SalesOrders](Robaws.SalesOrders.SalesOrders)`.id` | Key |  |
| `StockChanges_toClientId_txt` | `toClientId` | [Clients](Robaws.Clients.Clients)`.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. |
| `StockChanges_toLocationId_fk` | `toLocationId` | [StockLocations](Robaws.StockLocations.StockLocations)`.id` | Key |  |
| `StockChanges_workOrderId_txt` | `workOrderId` | [WorkOrders](Robaws.WorkOrders.WorkOrders)`.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)
