ShopOrders: Exact Online Shop Orders
popular insert update delete per partition REST
- Catálogo:
ExactOnlineREST - Esquema:
Manufacturing - Llaves Primarias:
ID - Label: Shop Orders
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}/manufacturing/ShopOrders - Metadatos:
/api/v1/{division}/manufacturing/$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 ShopOrders. 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 |
|---|---|---|---|---|---|
CAD |
varchar2 |
Dibujo CAD (URL) | filters on the platform, writable | URL to CAD Drawing Specified on Manufacturing Bill of Material. | |
Costcenter |
varchar2 |
Centro de Costo | filters on the platform, writable | The cost center linked to the shop order. | |
Costcenter |
varchar2 |
Descripción del Centro de Costo | filters on the platform, writable | Description of Costcenter. | |
Costunit |
varchar2 |
Unidad de Costo | filters on the platform, writable | The cost unit linked to the shop order. | |
Costunit |
varchar2 |
Descripción de la Unidad de Costo | filters on the platform, writable | Description of Costunit. | |
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. | |
Description |
varchar2 |
Description | filters on the platform, writable | Description of the shop order. | |
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. | |
Entry |
datetime |
Fecha de la Entrada | filters on the platform, writable | Date on which the shop order was placed. | |
ID |
guid |
ID | filters on the platform, writable | Primary key. | |
Is |
int16 |
Es Lote | filters on the platform, writable | Does the material plan's item use batch numbers. | |
Is |
int16 |
¿Se permite introducir fracciones en el artículo? | filters on the platform, writable | Indicates if fractions (for example 0.35) are allowed for quantities of the material plan's item. | |
Is |
int16 |
Está en fase de planificación | filters on the platform, writable | Indicator that Shop order is in planning. | |
Is |
int16 |
Está en espera | filters on the platform, writable | Indicator if the Shop order is on hold. | |
Is |
int16 |
Se ha publicado | filters on the platform, writable | Indicator that the Shop order has been released to production. | |
Is |
int16 |
Es Serial | filters on the platform, writable | Does the material plan's item use serial numbers. | |
Item |
guid |
Item | filters on the platform, writable | Reference to the item. | |
Item |
varchar2 |
Código de barras del artículo | filtros de la plataforma | ||
Item |
varchar2 |
Código del Artículo | filters on the platform, writable | Code of the item created by this shop order. | |
Item |
varchar2 |
Descripción del Elemento | filters on the platform, writable | Description of the item created by this shop order. | |
Item |
varchar2 |
Imagen del artículo (URL) | writable | URL of the item created by this shop order. | |
Item |
guid |
Versión del artículo | filters on the platform, writable | Reference to ItemVersion. | |
Item |
varchar2 |
Artículo Versión Descripción | filters on the platform, writable | Description of Item Version. | |
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. | |
Notes |
varchar2 |
Notes | filters on the platform, writable | Notes - only viewed internally. | |
Planned |
datetime |
Fecha planeada | filters on the platform, writable | Planned end date of this shop order. | |
Planned |
double |
Cantidad Planeada | filters on the platform, writable | Planned quantity. | |
Planned |
datetime |
Fecha de inicio prevista | filters on the platform, writable | Planned start date of this shop order. | |
Produced |
double |
Cantidad producida | filters on the platform, writable | Produced quantity. | |
Production |
int32 |
Días del responsable de producción | filters on the platform, writable | Production lead days. | |
Project |
guid |
Project | filters on the platform, writable | Reference to Project. | |
Project |
varchar2 |
Descripción del Proyecto | filters on the platform, writable | Description of Project. | |
Ready |
double |
Cantidad lista para enviar | filters on the platform, writable | Quantity ready to ship. | |
Sales |
int32 |
Número de líneas del pedido de venta | filters on the platform, writable | Number of sales orders linked to this shop order. | |
Selection |
guid |
Código de selección | filtros de la plataforma | ID of Selection code. | |
Selection |
varchar2 |
Código de selección | filtros de la plataforma | Code of Selection code. | |
Selection |
varchar2 |
itgen_eol_selectioncodedescription | filtros de la plataforma | Description of Selection code. | |
Shop |
int32 |
itgen_eol_shoporderbyproductplanbackflushcount | filters on the platform, writable | Number of shop order by-product plans, which are backflushed, for this shop order. | |
Shop |
int32 |
itgen_eol_shoporderbyproductplancount | filters on the platform, writable | Number of shop order by-product plans for this shop order. | |
Shop |
guid |
Página principal de pedidos de taller | filters on the platform, writable | Shop order main. | |
Shop |
int32 |
Número principal de la orden de taller | filters on the platform, writable | Shop order main number. | |
Shop |
int32 |
itgen_eol_shopordermaterialplanbackflushcount | filters on the platform, writable | Number of shop order material plans, which are backflushed, for this shop order. | |
Shop |
int32 |
itgen_eol_shopordermaterialplancount | filters on the platform, writable | Number of shop order material plans for this shop order. | |
Shop |
int32 |
itgen_eol_shopordermaterialplansnonissuedbyproductscount | filtros de la plataforma | ||
Shop |
int32 |
itgen_eol_shopordermaterialplansnonissuedmaterialscount | filtros de la plataforma | ||
Shop |
int32 |
Número de Orden de la Tienda | filters on the platform, writable | Unique number to indentify the shop order. | |
Shop |
varchar2 |
itgen_eol_shopordernumberstring | filters on the platform, writable | Unique number to indentify the shop order (as a string to allow OData filtering, e.g. $filter=substringof('123',ShopOrderNumberString) eq true. | |
Shop |
guid |
Orden de taller principal | filters on the platform, writable | Shop order parent. | |
Shop |
int32 |
itgen_eol_shoporderparentnumber | filters on the platform, writable | Shop order parent number. | |
Shop |
int32 |
itgen_eol_shoporderroutingstepplancount | filters on the platform, writable | Number of shop order routing step plans for this shop order. | |
Status |
int32 |
Status | filters on the platform, writable | Indicates the type of Shop Order: 10 Open, 20 In process, 30 Finished, 40 Completed. | |
Sub |
int32 |
Número de pedidos de la tienda de bocadillos | filters on the platform, writable | The count of material lines of this shop order, which have been linked to a sub order. | |
Type |
int32 |
Type | filters on the platform, writable | Overall status of the line: 9040 Regular. | |
Unit |
varchar2 |
Unit | filters on the platform, writable | Unit of the item created by this shop order. | |
Unit |
varchar2 |
Descripción de la Unidad | filters on the platform, writable | Unit description of the unit of the item created by this shop order. | |
Warehouse |
guid |
Warehouse | filters on the platform, writable | Reference to the Warehouse associated with the Shop order. | |
Warehouse |
varchar2 |
Código del Almacén | filtros de la plataforma | ||
Warehouse |
varchar2 |
Descripción del Almacén | filtros de la plataforma | ||
Your |
varchar2 |
Su Referencia | filters on the platform, writable | Your reference (of the customer). |
Teclas
| Key | Column | Se refiere a | Kind | Description |
|---|---|---|---|---|
Shop |
Costcenter |
Costcenters.Code |
Key | |
Shop |
Costunit |
Costunits.Code |
Key | |
Shop |
Creator |
Users. |
Key | |
Shop |
Item |
ItemVersions.ID |
Key | |
Shop |
Item |
Items.ID |
Key | |
Shop |
Modifier |
Users. |
Key | |
Shop |
Project |
Projects.ID |
Key | |
Shop |
Selection |
SelectionCodes.ID |
Key | |
Shop |
Shop |
ShopOrders.ID |
Key | |
Shop |
Shop |
ShopOrders.ID |
Key | |
Shop |
Unit |
Units.Code |
Key | |
Shop |
Warehouse |
Warehouses.ID |
Key |
Referenciado por
- TransactionLines
ShopOrder(Key) - TransactionLinesBulk
ShopOrder(Key) - ByProductReceipts
ShopOrder(Key) - ByProductReversals
ShopOrder(Key) - MaterialIssues
ShopOrder(Key) - MaterialReversals
ShopOrder(Key) - MfgTimeTransactions
ShopOrder(Key) - ShopOrderMaterialPlans
ShopOrder(Key) - ShopOrderReceipts
ParentShopOrder(Key) - ShopOrderReceipts
ShopOrder(Key) - ShopOrderReversals
ShopOrder(Key) - ShopOrderRoutingStepPlans
ShopOrder(Key) - ShopOrders
ShopOrderMain(Key) - ShopOrders
ShopOrderParent(Key) - StageForDeliveryReceipts
ShopOrder(Key) - StageForDeliveryReversals
ShopOrder(Key) - SubOrderReceipts
ParentShopOrder(Key) - SubOrderReceipts
SubShopOrder(Key) - SubOrderReversals
ParentShopOrder(Key) - SubOrderReversals
SubShopOrder(Key) - SalesOrderLines
ShopOrder(Key) - SalesOrderLinesBulk
ShopOrder(Key)
Notas de la Versión
Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: