invantive documentation
Foros de Soporte de InvantiveIniciar Sesión / Registrarse

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
AmountDC double Importe División Moneda filters on the platform, writable Amount in the default currency of the company.
AmountFC double Cantidad Moneda Extranjera filters on the platform, writable Amount in the currency of the transaction.
CostCenter varchar2(8) Centro de Costo filters on the platform, writable Reference to Cost center.
CostCenterDescription varchar2(60) Descripción del Centro de Costo filters on the platform, writable Description of CostCenter.
CostUnit varchar2(8) Unidad de Costo filters on the platform, writable Reference to Cost unit.
CostUnitDescription varchar2(60) 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.
CreatedUtc datetime Creado writable Creation date in UTC.
Creator guid Creator filters on the platform, writable User ID of creator.
CreatorFullName varchar2(240) Nombre Completo del Creador filters on the platform, writable Name of creator.
CustomField 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.
DivisionCompanyCoCNumber varchar2(60) Número de la Cámara de Comercio de la División writable Chamber of commerce number of the Exact Online division.
DivisionCompanyIBANNumber varchar2(50) Número IBAN de la división writable IBAN number of the Exact Online division.
DivisionCompanyName varchar2(50) División: Nombre de la empresa writable Company name of the Exact Online division.
DivisionCompanyRSINNumber varchar2(9) Número de la división RSIN writable RSIN number of the Exact Online division.
DivisionCompanyVATNumber varchar2(35) Número de IVA de la división writable VAT number of the Exact Online division.
DivisionCompanyWageTaxNumber varchar2(60) 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.
DivisionLabel varchar2(128) Etiqueta de división writable Label of the Exact Online division.
DivisionName varchar2(50) Nombre de la Adminisración writable Name of the Exact Online division.
DivisionOwnerCompanyName varchar2(50) 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.
DivisionOwnerCompanyNumber varchar2(18) 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.
DivisionShortName 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.
ExpenseDescription 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.
InStock 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.
InvoicedQuantity double Cantidad facturada writable Quantity of item that has been invoiced.
IsBatchNumberItem int16 ¿Es el número de lote del artículo? filtros de la plataforma
IsSerialNumberItem 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.
ItemBarcode varchar2 Código de barras del artículo filtros de la plataforma
ItemBarcodeAdditional varchar2 itgen_eol_itembarcodeadditional filters on the platform, writable
ItemCode varchar2(30) Código del Artículo filters on the platform, writable Item code.
ItemDescription varchar2(255) Descripción del Elemento filters on the platform, writable Description of item.
ItemDivisable char Artículo divisible filters on the platform, writable Indicates if fractional quantities of the item can be used, for example quantity = 0.4.
LineNumber int32 Número de Línea filters on the platform, writable Line number.
Modified datetime Modified filters on the platform, writable Last modified date.
ModifiedUtc datetime Modificado (UTC) writable Last modified date in UTC.
Modifier guid Modifier filters on the platform, writable User ID of modifier.
ModifierFullName varchar2(240) Nombre completo modificado filters on the platform, writable Name of modifier.
NetPrice 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.
ProjectCode varchar2(20) Código de Proyecto filters on the platform, writable Project code.Only available with a professional service license.
ProjectDescription varchar2(60) Descripción del Proyecto filters on the platform, writable Description of the project.Only available with a professional service license.
ProjectedStock double Existencias previstas writable The current stock level + the planned quantity to be received - the planned quantity to deliver shown in stock unit.
PurchaseOrderID 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.
QuantityInPurchaseUnits 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.
ReceiptDate datetime Fecha del Recibo filters on the platform, writable Date the goods are expected to be received.
ReceivedQuantity double Cantidad recibida writable Quantity of goods received.
SalesOrder guid Orden de Venta filters on the platform, writable Sales order that is linked to a back to back sales order in purchase order.
SalesOrderLine 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.
SalesOrderLineNumber int32 Número de línea del pedido de venta filters on the platform, writable Number of the sales order line.
SalesOrderNumber int32 Número de Orden de Venta filters on the platform, writable Number of the sales order.
ShopOrder guid Orden de Producción filters on the platform, writable
ShopOrderMaterialPlan guid itgen_eol_shopordermaterialplan filters on the platform, writable
ShopOrderMaterialPlanLineNumber int32 itgen_eol_shopordermaterialplanlinenumber filtros de la plataforma
ShopOrderNumber int32 Número de Orden de la Tienda filtros de la plataforma
ShopOrderRoutingStepPlan guid itgen_eol_shoporderroutingstepplan filters on the platform, writable
ShopOrderRoutingStepPlanLineNumber int32 itgen_eol_shoporderroutingstepplanlinenumber filtros de la plataforma
SupplierItemCode varchar2(240) Código del Elemento del Proveedor writable Code the supplier uses for this item.
SupplierItemCopyRemarks 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(8) Unit filters on the platform, writable Code of item unit.
UnitDescription varchar2(60) Descripción de la Unidad filters on the platform, writable Description of unit.
UnitPrice double Precio de la Unidad writable Item price per purchase unit.
VATAmount double Cantidad VAT filters on the platform, writable Amount of VAT charges calculated from total amount and vat percentage.
VATCode varchar2(3) Código VAT filters on the platform, writable The VAT code used when the invoice was registered.
VATDescription varchar2(60) Descripción de VAT filters on the platform, writable Description of the VAT code.
VATPercentage 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
PurchaseOrderLines_CostCenter_Costcenters_fk CostCenter Costcenters.Code Key
PurchaseOrderLines_CostUnit_Costunits_fk CostUnit Costunits.Code Key
PurchaseOrderLines_Creator_Users_fk Creator Users.UserID Key
PurchaseOrderLines_Item_Items_fk Item Items.ID Key
PurchaseOrderLines_Modifier_Users_fk Modifier Users.UserID Key
PurchaseOrderLines_Project_Projects_fk Project Projects.ID Key
PurchaseOrderLines_PurchaseOrderID_PurchaseOrders_fk PurchaseOrderID PurchaseOrders.PurchaseOrderID Key
PurchaseOrderLines_SalesOrderLine_SalesOrderLines_fk SalesOrderLine SalesOrderLines.ID Key
PurchaseOrderLines_SalesOrder_SalesOrders_fk SalesOrder SalesOrders.OrderID Key
PurchaseOrderLines_Unit_Units_fk Unit Units.Code Key
PurchaseOrderLines_VATCode_VATCodes_fk VATCode VATCodes.Code Key

Referenciado por

Notas de la Versión

Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: