QuotationsBulk: Exact Online Quotations
read only per partition webhook REST
- Catálogo:
ExactOnlineREST - Esquema:
CRM - Llaves Primarias:
QuotationID - Label: Quotations
Los datos de esta tabla están divididos por el valor de la columna Division.
Solo puede recuperar datos.
Los cambios llegan a través del tema de webhook Quotations.
Fuente de la API
- Punto final:
/api/v1/{division}/bulk/CRM/Quotations - Metadatos:
/api/v1/{division}/bulk/CRM/$metadata
Características de rendimiento
| Characteristic | Value |
|---|---|
| Latencia media de acceso (ms) | 5 |
| Número de filas escaneadas por minuto | 20,000 |
| 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 QuotationsBulk. 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 | Amount in the default currency of the company. | ||
Amount |
double |
Importe del descuento | writable | ||
Amount |
double |
Importe del descuento sin IVA | writable | ||
Amount |
double |
Cantidad Moneda Extranjera | Amount in the currency of the transaction. | ||
Close |
datetime |
Fecha de cierre | Date on which the customer accepted or rejected the quotation version. | ||
Closing |
datetime |
Fecha de cierre | Date on which you expect to close/win the deal. | ||
Created |
datetime |
Created | Date and time on which the quotation was created. | ||
Created |
datetime |
Creado | writable | Creation date in UTC. | |
Creator |
guid |
Creator | User ID of the creator. | ||
Creator |
varchar2 |
Nombre Completo del Creador | Name of the creator. | ||
Currency |
varchar2 |
Currency | The currency of the quotation. | ||
Delivery |
guid |
Cuenta de Entrega | filtros de la plataforma | The account where the items should delivered. | |
Delivery |
varchar2 |
Código de cuenta de entrega | The code of the delivery account. | ||
Delivery |
guid |
Entrega, cuenta y contacto | filtros de la plataforma | The contact person of the delivery account. | |
Delivery |
varchar2 |
Entrega Cuenta Contacto Nombre y apellidos completos | Full name of the delivery account contact person. | ||
Delivery |
varchar2 |
Nombre de la cuenta de entrega | The name of the delivery account. | ||
Delivery |
guid |
Dirección de Entrega | filtros de la plataforma | The id of the delivery address. | |
Delivery |
datetime |
Fecha de Entrega | |||
Description |
varchar2 |
Description | The description of the quotation. | ||
Division |
int32 |
ID de la Empresa | Unique number of the Exact Online division. | ||
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 | filtros de la plataforma | Document linked to the quotation. | |
Document |
varchar2 |
Tema del Documento | The subject of the document. | ||
Due |
datetime |
Fecha de Vencimiento | Date after which the quotation is no longer valid. | ||
Incoterm |
varchar2 |
Dirección según los Incoterms | |||
Incoterm |
varchar2 |
Código Incoterm | |||
Incoterm |
int16 |
Versión de Incoterm | |||
Invoice |
guid |
Cuenta de la Factura | filtros de la plataforma | The account to which the invoice is sent. | |
Invoice |
varchar2 |
Código de Cuenta de la Factura | The code of the invoice account. | ||
Invoice |
guid |
Factura, cuenta, contacto | filtros de la plataforma | The contact person of the invoice account. | |
Invoice |
varchar2 |
Factura Cuenta Nombre completo del contacto | Full name of the invoice account contact person. | ||
Invoice |
varchar2 |
Nombre de Cuenta de la Factura | The name of the invoice account. | ||
Modified |
datetime |
Modified | Date and time on which the quotation was last modified. | ||
Modified |
datetime |
Modificado (UTC) | writable | Last modified date in UTC. | |
Modifier |
guid |
Modifier | User ID of the modifier. | ||
Modifier |
varchar2 |
Nombre completo modificado | Name of the modifier. | ||
Opportunity |
guid |
Opportunity | filtros de la plataforma | Opportunity linked to the quotation. | |
Opportunity |
varchar2 |
Nombre de la oportunidad | The name of the opportunity. | ||
Order |
guid |
Cuenta de pedidos | filtros de la plataforma | The account that requested the quotation. | |
Order |
varchar2 |
Código de cuenta de pedido | The code of the order account. | ||
Order |
guid |
Pedido, Cuenta, Contacto | filtros de la plataforma | The contact person of the order account. | |
Order |
varchar2 |
itgen_eol_orderaccountcontactfullname | Full name of the order account contact person. | ||
Order |
varchar2 |
Nombre de la cuenta de pedido | The name of the order account. | ||
Payment |
varchar2 |
Condición de Pago | writable | ||
Payment |
varchar2 |
Descripción de la Condición de Pago | |||
Project |
guid |
Project | filtros de la plataforma | The project linked to the quotation. | |
Project |
varchar2 |
Código de Proyecto | The code of the project. | ||
Project |
varchar2 |
Descripción del Proyecto | The description of the project. | ||
Quotation |
datetime |
Fecha de la Oferta | filtros de la plataforma | Date on which the quotation version is entered or printed.Both during entering and printing this date can be adjusted. | |
Quotation |
guid |
N.º de presupuesto | filtros de la plataforma | Identifier of the quotation. | |
Quotation |
int32 |
Número de la Oferta | filtros de la plataforma | Unique number to indentify the quotation.By default this number is based on the setting for first available number. | |
Remarks |
varchar2 |
Remarks | Extra text that can be added to the quotation. | ||
Sales |
guid |
Canal de Ventas | |||
Sales |
varchar2 |
Código del canal de ventas | |||
Sales |
varchar2 |
Descripción del canal de ventas | |||
Sales |
guid |
Vendedor | The user that is responsible for the quotation version. | ||
Sales |
varchar2 |
Nombre Completo del Vendedor | Full name of the sales person. | ||
Selection |
guid |
Código de selección | filtros de la plataforma | ID of selection code.Only supported by the Advanced and Premium editions for Wholesale & Distribution and Manufacturing. | |
Selection |
varchar2 |
Código de selección | Code of selection code. | ||
Selection |
varchar2 |
itgen_eol_selectioncodedescription | Description of selection code. | ||
Shipping |
guid |
Modo de Envío | writable | ||
Shipping |
varchar2 |
Descripción del método de envío | |||
Status |
int16 |
Status | filtros de la plataforma | The status of the quotation version.5 = Rejected, 6 = Reviewed and closed, 10 = Recovery, 20 = Draft, 25 = Open, 35 = Processing... , 40 = Printed, 50 = Accepted. | |
Status |
varchar2 |
Descripción del Estado | The description of the status. | ||
VAT |
double |
Moneda Extranjera de la Cantidad VAT | Total VAT amount in the currency of the transaction. | ||
Version |
int32 |
Número de la Versión | filtros de la plataforma | Number indicating the different reviews which are made for the quotation. | |
Your |
varchar2 |
Su Referencia | The number by which this quotation is identified by the order account. |
Teclas
| Key | Column | Se refiere a | Kind | Description |
|---|---|---|---|---|
Quotations |
Creator |
Users. |
Key | |
Quotations |
Currency |
Currencies.Code |
Key | |
Quotations |
Delivery |
Contacts.ID |
Key | |
Quotations |
Delivery |
Accounts.ID |
Key | |
Quotations |
Delivery |
Addresses.ID |
Key | |
Quotations |
Document |
Documents.ID |
Key | |
Quotations |
Invoice |
Contacts.ID |
Key | |
Quotations |
Invoice |
Accounts.ID |
Key | |
Quotations |
Modifier |
Users. |
Key | |
Quotations |
Opportunity |
Opportunities.ID |
Key | |
Quotations |
Order |
Contacts.ID |
Key | |
Quotations |
Order |
Accounts.ID |
Key | |
Quotations |
Project |
Projects.ID |
Key | |
Quotations |
Sales |
Users. |
Key | |
Quotations |
Selection |
SelectionCodes.ID |
Key |
Notas de la Versión
Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: