PurchaseOrderLines: Exact Online Purchase Order Lines
insert update delete per partition webhook REST
- Catálogo:
ExactOnlineREST - Esquema:
PurchaseOrder - Llaves Primarias:
ID - Label: Purchase Order Lines
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.
Los cambios llegan a través del tema de webhook PurchaseOrders en PurchaseOrderID.
Fuente de la API
- Punto final:
/api/v1/{division}/purchaseorder/PurchaseOrderLines - Metadatos:
/api/v1/{division}/purchaseorder/$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 PurchaseOrderLines. 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 |
|---|---|---|---|---|---|
Amount |
double |
Importe División Moneda | filters on the platform, writable | Amount in the default currency of the company. | |
Amount |
double |
Cantidad Moneda Extranjera | filters on the platform, writable | Amount in the currency of the transaction. | |
Cost |
varchar2 |
Centro de Costo | filters on the platform, writable | Reference to Cost center. | |
Cost |
varchar2 |
Descripción del Centro de Costo | filters on the platform, writable | Description of CostCenter. | |
Cost |
varchar2 |
Unidad de Costo | filters on the platform, writable | Reference to Cost unit. | |
Cost |
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. | |
Custom |
varchar2 |
Campo personalizado | writable | ||
Description |
varchar2 |
Description | filters on the platform, writable | Description of the purchase order line. | |
Discount |
double |
Discount | filters on the platform, writable | Discount in percentage for item. | |
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. | |
Expense |
guid |
Expense | filters on the platform, writable | Expense related to the Work Breakdown Structure of the selected project.Only available with a professional service license. | |
Expense |
varchar2 |
Descripción del Gasto | filters on the platform, writable | Description of expense.Only available with a professional service license. | |
ID |
guid |
ID | filters on the platform, writable | Primary key. | |
In |
double |
En stock | writable | The current stock level of items shown in stock unit.The information is displayed only for items with the stock property selected. | |
Invoiced |
double |
Cantidad facturada | writable | Quantity of item that has been invoiced. | |
Is |
int16 |
¿Es el número de lote del artículo? | filtros de la plataforma | ||
Is |
int16 |
¿Es un artículo con número de serie? | filtros de la plataforma | ||
Item |
guid |
Item | filters on the platform, writable | Reference to the item for purchase order. | |
Item |
varchar2 |
Código de barras del artículo | filtros de la plataforma | ||
Item |
varchar2 |
itgen_eol_itembarcodeadditional | filters on the platform, writable | ||
Item |
varchar2 |
Código del Artículo | filters on the platform, writable | Item code. | |
Item |
varchar2 |
Descripción del Elemento | filters on the platform, writable | Description of item. | |
Item |
char |
Artículo divisible | filters on the platform, writable | Indicates if fractional quantities of the item can be used, for example quantity = 0.4. | |
Line |
int32 |
Número de Línea | filters on the platform, writable | Line number. | |
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. | |
Net |
double |
Precio Neto | filters on the platform, writable | The net price is the unit price (VAT code taken into account) with any discount applied. | |
Notes |
varchar2 |
Notes | filters on the platform, writable | Notes. | |
Project |
guid |
Project | filters on the platform, writable | Reference to project.Only available with a professional service license. | |
Project |
varchar2 |
Código de Proyecto | filters on the platform, writable | Project code.Only available with a professional service license. | |
Project |
varchar2 |
Descripción del Proyecto | filters on the platform, writable | Description of the project.Only available with a professional service license. | |
Projected |
double |
Existencias previstas | writable | The current stock level + the planned quantity to be received - the planned quantity to deliver shown in stock unit. | |
Purchase |
guid |
N.º de orden de compra | filters on the platform, writable | Identifies the purchase order.All the lines of a purchase order have the same PurchaseOrderID. | |
Quantity |
double |
Quantity | filters on the platform, writable | Quantity in item units. | |
Quantity |
double |
Cantidad en unidades de compra | writable | Quantity in purchase units.Use this field when creating a purchase order. | |
Rebill |
char |
Rebill | filters on the platform, writable | Indicates whether the purchase order line needs to be rebilled.Only available with a professional service license. | |
Receipt |
datetime |
Fecha del Recibo | filters on the platform, writable | Date the goods are expected to be received. | |
Received |
double |
Cantidad recibida | writable | Quantity of goods received. | |
Sales |
guid |
Orden de Venta | filters on the platform, writable | Sales order that is linked to a back to back sales order in purchase order. | |
Sales |
guid |
Línea de Orden de Ventas | filters on the platform, writable | Sales order line of the sales order that is linked to a back to back sales order in purchase order. | |
Sales |
int32 |
Número de línea del pedido de venta | filters on the platform, writable | Number of the sales order line. | |
Sales |
int32 |
Número de Orden de Venta | filters on the platform, writable | Number of the sales order. | |
Shop |
guid |
Orden de Producción | filters on the platform, writable | ||
Shop |
guid |
itgen_eol_shopordermaterialplan | filters on the platform, writable | ||
Shop |
int32 |
itgen_eol_shopordermaterialplanlinenumber | filtros de la plataforma | ||
Shop |
int32 |
Número de Orden de la Tienda | filtros de la plataforma | ||
Shop |
guid |
itgen_eol_shoporderroutingstepplan | filters on the platform, writable | ||
Shop |
int32 |
itgen_eol_shoporderroutingstepplanlinenumber | filtros de la plataforma | ||
Supplier |
varchar2 |
Código del Elemento del Proveedor | writable | Code the supplier uses for this item. | |
Supplier |
int16 |
itgen_eol_supplieritemcopyremarks | writable | Indicate if the notes content should be copied from SupplierItem's remarks.The default follows the CopyRemarks value from SupplierItem.Values: 0 = Do not copy remark, 1 = Copy remark. | |
Unit |
varchar2 |
Unit | filters on the platform, writable | Code of item unit. | |
Unit |
varchar2 |
Descripción de la Unidad | filters on the platform, writable | Description of unit. | |
Unit |
double |
Precio de la Unidad | writable | Item price per purchase unit. | |
VAT |
double |
Cantidad VAT | filters on the platform, writable | Amount of VAT charges calculated from total amount and vat percentage. | |
VAT |
varchar2 |
Código VAT | filters on the platform, writable | The VAT code used when the invoice was registered. | |
VAT |
varchar2 |
Descripción de VAT | filters on the platform, writable | Description of the VAT code. | |
VAT |
double |
Porcentaje VAT | filters on the platform, writable | The VAT percentage of the VAT code.This is the percentage at the moment the invoice is created.It's also used by the default calculation of VAT amounts and VAT base amounts. |
Teclas
| Key | Column | Se refiere a | Kind | Description |
|---|---|---|---|---|
Purchase |
Cost |
Costcenters.Code |
Key | |
Purchase |
Cost |
Costunits.Code |
Key | |
Purchase |
Creator |
Users. |
Key | |
Purchase |
Item |
Items.ID |
Key | |
Purchase |
Modifier |
Users. |
Key | |
Purchase |
Project |
Projects.ID |
Key | |
Purchase |
Purchase |
PurchaseOrders. |
Key | |
Purchase |
Sales |
SalesOrderLines.ID |
Key | |
Purchase |
Sales |
SalesOrders. |
Key | |
Purchase |
Unit |
Units.Code |
Key | |
Purchase |
VAT |
VATCodes.Code |
Key |
Referenciado por
- PurchaseInvoiceLines
PurchaseOrderLine(Key) - GoodsReceiptLines
PurchaseOrderLineID(Key) - SalesOrderLines
PurchaseOrderLine(Key) - SalesOrderLinesBulk
PurchaseOrderLine(Key)
Notas de la Versión
Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: