PurchaseOrders: Exact Online Purchase Orders
insert update delete per partition webhook REST
- Catálogo:
ExactOnlineREST - Esquema:
PurchaseOrder - Llaves Primarias:
PurchaseOrderID - Label: Purchase 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.
Los cambios llegan a través del tema de webhook PurchaseOrders.
Fuente de la API
- Punto final:
/api/v1/{division}/purchaseorder/PurchaseOrders - 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 PurchaseOrders. 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 | Total amount in the default currency of the company. | |
Amount |
double |
Importe del descuento | filters on the platform, writable | ||
Amount |
double |
Importe del descuento sin IVA | filtros de la plataforma | ||
Amount |
double |
Cantidad Moneda Extranjera | filters on the platform, writable | Total amount in the currency of the transaction. | |
Amount |
double |
Importe en moneda extranjera, sin IVA | filtros de la plataforma | ||
Approval |
int16 |
Estado de la Aprobación | filtros de la plataforma | ||
Approval |
varchar2 |
Descripción del Estado de Aprobación | filtros de la plataforma | ||
Approved |
datetime |
Approved | filtros de la plataforma | ||
Approver |
guid |
Approver | filtros de la plataforma | ||
Approver |
varchar2 |
Nombre Completo del Aprobador | 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. | |
Currency |
varchar2 |
Currency | filters on the platform, writable | Currency code. | |
Delivery |
guid |
Cuenta de Entrega | filters on the platform, writable | Reference to account for delivery. | |
Delivery |
varchar2 |
Código de cuenta de entrega | filters on the platform, writable | Delivery account code. | |
Delivery |
varchar2 |
Nombre de la cuenta de entrega | filters on the platform, writable | Name of account. | |
Delivery |
guid |
Dirección de Entrega | filters on the platform, writable | Reference to shipping address. | |
Delivery |
guid |
Persona de contacto para la entrega | filters on the platform, writable | Reference to contact for delivery. | |
Delivery |
varchar2 |
Nombre completo de la persona de contacto para la entrega | filters on the platform, writable | Name of the contact person of the customer who will receive delivered goods. | |
Description |
varchar2 |
Description | filters on the platform, writable | Description of the purchase order. | |
Discount |
double |
Discount | filters on the platform, writable | ||
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. | |
Document |
guid |
Document | filters on the platform, writable | Document that is manually linked to the purchase order. | |
Document |
varchar2 |
Tema del Documento | filters on the platform, writable | Subject of the document. | |
Drop |
char |
Entrega directa | filters on the platform, writable | Shows if it is a drop shipment purchase order. | |
Exchange |
double |
Tasa de Cambio | filters on the platform, writable | Allows you to set the currency for the invoice.You can only do this if you have checked the Variable: Currency and Variable: Exchange rate fields in the sales journal settings.Once a line has been created in the invoice, the currency can no longer be changed. | |
Incoterm |
varchar2 |
Dirección según los Incoterms | filters on the platform, writable | ||
Incoterm |
varchar2 |
Código Incoterm | filters on the platform, writable | ||
Incoterm |
int16 |
Versión de Incoterm | filters on the platform, writable | ||
Invoice |
int32 |
Estatus de la Factura | filters on the platform, writable | Invoice status of purchase order: 10-Open, 20-Partial, 30-Complete, 40-Canceled. | |
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. | |
Order |
datetime |
Fecha de la Orden | filters on the platform, writable | Order date. | |
Order |
int32 |
Número de la Orden | filters on the platform, writable | Human readable id of the purchase order. | |
Order |
int32 |
Estado de la Orden | filters on the platform, writable | Purchase order status: 10-Open, 20-Partial, 30-Complete, 40-Canceled. | |
Payment |
varchar2 |
Condición de Pago | filters on the platform, writable | The payment condition code used for due date and discount calculation. | |
Payment |
varchar2 |
Descripción de la Condición de Pago | filters on the platform, writable | Description of payment condition. | |
Purchase |
guid |
Agente de compras | filters on the platform, writable | Purchase agent. | |
Purchase |
varchar2 |
Nombre completo del agente de compras | filters on the platform, writable | Name of purchase agent. | |
Purchase |
guid |
N.º de orden de compra | filters on the platform, writable | Primary key. | |
Purchase |
int32 |
itgen_eol_purchaseorderlinecount | filtros de la plataforma | ||
Receipt |
datetime |
Fecha del Recibo | filters on the platform, writable | This field shows the date the goods are expected to be received. | |
Receipt |
int32 |
Estado de la recepción | filters on the platform, writable | Receipt status of purchase order: 10-Open, 20-Partial, 30-Complete, 40-Canceled. | |
Remarks |
varchar2 |
Remarks | filters on the platform, writable | Include any relevant remarks regarding the purchase order. | |
Sales |
guid |
Orden de Venta | filters on the platform, writable | Reference to sales order when purchase order generated via back to back sales order. | |
Sales |
int32 |
Número de Orden de Venta | filters on the platform, writable | Number of the sales 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. | |
Shipping |
guid |
Modo de Envío | filters on the platform, writable | ShippingMethod. | |
Shipping |
varchar2 |
Código del método de envío | filtros de la plataforma | ||
Shipping |
varchar2 |
Descripción del método de envío | filters on the platform, writable | Description of ShippingMethod. | |
Source |
int16 |
Source | filters on the platform, writable | This shows how the purchase order was created: 1-Manual entry, 2-Import, 3-Other, 4-Purchase order, 5-Sales order, 6-Supplier's items, 7-Subcontract, 8-Purchase order advice, 9-Shop order, 10-MRP calculation. | |
Supplier |
guid |
Supplier | filters on the platform, writable | Reference to supplier account. | |
Supplier |
varchar2 |
Código del Proveedor | filters on the platform, writable | Code of supplier. | |
Supplier |
guid |
Persona de contacto del proveedor | filters on the platform, writable | Contact of supplier. | |
Supplier |
varchar2 |
Nombre completo de la persona de contacto del proveedor | filters on the platform, writable | Contact person full name of supplier. | |
Supplier |
varchar2 |
Nombre del Proveedor | filters on the platform, writable | Name of supplier. | |
VAT |
double |
Cantidad VAT | filters on the platform, writable | Total VAT amount in the currency of the transaction. | |
Warehouse |
guid |
Warehouse | filters on the platform, writable | Warehouse. | |
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. | |
Your |
varchar2 |
Su Referencia | filters on the platform, writable | Shows the reference number associated with the purchase order.Enter a description and reference to make the purchase order easier to identify. |
Teclas
| Key | Column | Se refiere a | Kind | Description |
|---|---|---|---|---|
Purchase |
Creator |
Users. |
Key | |
Purchase |
Currency |
Currencies.Code |
Key | |
Purchase |
Delivery |
Accounts.ID |
Key | |
Purchase |
Delivery |
Addresses.ID |
Key | |
Purchase |
Delivery |
Contacts.ID |
Key | |
Purchase |
Document |
Documents.ID |
Key | |
Purchase |
Modifier |
Users. |
Key | |
Purchase |
Purchase |
Users. |
Key | |
Purchase |
Sales |
SalesOrders. |
Key | |
Purchase |
Selection |
SelectionCodes.ID |
Key | |
Purchase |
Shipping |
ShippingMethods.ID |
Key | |
Purchase |
Supplier |
Contacts.ID |
Key | |
Purchase |
Supplier |
Accounts.ID |
Key | |
Purchase |
Warehouse |
Warehouses.ID |
Key |
Referenciado por
- GoodsReceiptLines
PurchaseOrderID(Key) - PurchaseOrderLines
PurchaseOrderID(Key) - SalesOrderLines
PurchaseOrder(Key) - SalesOrderLinesBulk
PurchaseOrder(Key)
Notas de la Versión
Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: