ItemWarehouses: Exact Online Item Warehouses
insert update delete per partition REST
- Catálogo:
ExactOnlineREST - Esquema:
Inventory - Llaves Primarias:
ID - Label: Item Warehouses
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.
Fuente de la API
- Punto final:
/api/v1/{division}/inventory/ItemWarehouses - Metadatos:
/api/v1/{division}/inventory/$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 ItemWarehouses. 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 |
|---|---|---|---|---|---|
Counting |
int16 |
itgen_eol_countingcycle | filtros de la plataforma | ||
Created |
datetime |
Created | filters on the platform, writable | Creation date. | |
Created |
datetime |
Creado | writable | Creation date in UTC. | |
Creator |
guid |
Creator | filters on the platform, writable | User ID of creator. | |
Creator |
varchar2 |
Nombre Completo del Creador | filters on the platform, writable | Name of creator. | |
Current |
double |
Stock actual | filters on the platform, writable | Quantity that is currently on stock, sales/purchase orders excluded. | |
Default |
guid |
itgen_eol_defaultstoragelocation | filters on the platform, writable | This is a default storage location. | |
Default |
varchar2 |
itgen_eol_defaultstoragelocationcode | filters on the platform, writable | Default storage location's code. | |
Default |
varchar2 |
itgen_eol_defaultstoragelocationdescription | filters on the platform, writable | Default storage location's description. | |
Division |
int32 |
Division | Division code. | ||
Division |
varchar2 |
Número de la Cámara de Comercio de la División | writable | Chamber of commerce number of the Exact Online division. | |
Division |
varchar2 |
Número IBAN de la división | writable | IBAN number of the Exact Online division. | |
Division |
varchar2 |
División: Nombre de la empresa | writable | Company name of the Exact Online division. | |
Division |
varchar2 |
Número de la división RSIN | writable | RSIN number of the Exact Online division. | |
Division |
varchar2 |
Número de IVA de la división | writable | VAT number of the Exact Online division. | |
Division |
varchar2 |
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. | |
Division |
varchar2 |
Etiqueta de división | writable | Label of the Exact Online division. | |
Division |
varchar2 |
Nombre de la Adminisración | writable | Name of the Exact Online division. | |
Division |
varchar2 |
Nombre del titular de la suscripción | writable | Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
varchar2 |
Número de titular de la suscripción | writable | Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
int64 |
Nombre abreviado de la división | writable | Short name of the Exact Online division. | |
ID |
guid |
ID | filters on the platform, writable | Primary key. | |
Item |
guid |
Item | filters on the platform, writable | Item ID. | |
Item |
varchar2 |
Código de barras del artículo | filters on the platform, writable | Barcode of item. | |
Item |
varchar2 |
Código del Artículo | filters on the platform, writable | Code of item. | |
Item |
varchar2 |
Descripción del Elemento | filters on the platform, writable | Description of item. | |
Item |
datetime |
Fecha de finalización del artículo | filters on the platform, writable | Together with ItemStartDate this determines if the item is active. | |
Item |
char |
itgen_eol_itemisfractionalloweditem | filters on the platform, writable | Indicates if fractions (for example 0.35) are allowed for quantities of this item. | |
Item |
char |
El artículo está en stock | filters on the platform, writable | Indicates if this is a stock item. | |
Item |
datetime |
Fecha de inicio del artículo | filters on the platform, writable | Together with ItemEndDate this determines if the item is active. | |
Item |
varchar2 |
Unidad de artículo | filters on the platform, writable | The standard unit code of this item. | |
Item |
varchar2 |
Artículo Unidad Descripción | filters on the platform, writable | Description of item's unit. | |
Maximum |
double |
Stock Máximo | filters on the platform, writable | Maximum number of stock could enter warehouse. | |
Modified |
datetime |
Modified | filters on the platform, writable | Last modified date. | |
Modified |
datetime |
Modificado (UTC) | writable | Last modified date in UTC. | |
Modifier |
guid |
Modifier | filters on the platform, writable | User ID of modifier. | |
Modifier |
varchar2 |
Nombre completo modificado | filters on the platform, writable | Name of modifier. | |
Next |
datetime |
Próximo ciclo de recuento | filtros de la plataforma | ||
Order |
int16 |
Política de pedidos | filtros de la plataforma | ||
Period |
int16 |
Period | filtros de la plataforma | ||
Planned |
double |
Entrada de existencias prevista | filters on the platform, writable | The quantity still open to be received based on i.e. purchase orders and assembly orders. | |
Planned |
double |
Agotamiento previsto de existencias | filters on the platform, writable | The quantity still open to be delivered based on i.e. sales orders and assembly orders. | |
Planning |
varchar2 |
Detalles de la planificación (URL) | writable | URL of the stock planning details of this record. | |
Projected |
double |
Existencias previstas | filters on the platform, writable | The quantity of stock projected given all planned future stock changes. | |
Reorder |
double |
Punto de hacer nuevo pedido | filters on the platform, writable | Reorder point when stock depletes. | |
Reorder |
double |
Cantidad de reposición | filtros de la plataforma | ||
Replenishment |
int16 |
Tipo de reposición | filtros de la plataforma | ||
Reserved |
double |
Existencias reservadas | filters on the platform, writable | The quantity in a back to back order process which is already received from the purchase order, but not yet delivered for the sales order. | |
Safety |
double |
Existencias de Seguridad | filters on the platform, writable | Safety stock. | |
Storage |
int32 |
itgen_eol_storagelocationsequencenumber | filters on the platform, writable | ||
Storage |
varchar2 |
Ubicación de almacenamiento (URL) | writable | URL pointing to details of which storage locations this ItemWarehouse's stock is located. | |
Warehouse |
guid |
Warehouse | filters on the platform, writable | Warehouse ID. | |
Warehouse |
varchar2 |
Código del Almacén | filters on the platform, writable | Code of warehouse. | |
Warehouse |
varchar2 |
Descripción del Almacén | filters on the platform, writable | Description of warehouse. |
Teclas
| Key | Column | Se refiere a | Kind | Description |
|---|---|---|---|---|
Item |
Creator |
Users. |
Key | |
Item |
Default |
StorageLocations.ID |
Key | |
Item |
Item |
Units.Code |
Key | |
Item |
Item |
Items.ID |
Key | |
Item |
Modifier |
Users. |
Key | |
Item |
Warehouse |
Warehouses.ID |
Key |
Notas de la Versión
Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: