OfferByDocumentNumber: Fortnox Offer by Document Number
read only REST
- Catálogo:
Fortnox - Esquema:
Offers - Label: Offer by Document Number
Retrieve a single offer
Solo puede recuperar datos.
Fuente de la API
- Punto final:
/3/offers/{DocumentNumber} - Operación:
get /3/offers/{DocumentNumber}
Características de rendimiento
| Characteristic | Value |
|---|---|
| Latencia media de acceso (ms) | 356 |
| Número de filas escaneadas por minuto | 85,000 |
| Número de filas de queries puntuales por minuto | 168 |
El resultado se puede almacenar en la Caché del cliente.
Parámetros
| Name | Tipo de Datos | Required | Default | Documentation |
|---|---|---|---|---|
Document |
`` | identifies the offer | ||
financialyear |
`` | Selects what financial year that should be used (does not work on every table). | ||
financialyeardate |
`` | Selects by date, what financial year that should be used (does not work on every table). | ||
fromdate |
`` | Defines a selection based on a start date.Only available for invoices, orders, offers, vouchers and supplierinvoices (does not work on every table). | ||
lastmodified |
`` | Retrieves all records since the provided timestamp (does not work on every table). | ||
todate |
`` | Defines a selection based on an end date.Only available for invoices, orders, offers, vouchers and supplierinvoices (does not work on every table). |
Columnas de la Tabla
A continuación se muestran las columnas de la tabla OfferByDocumentNumber. 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 |
|---|---|---|---|---|---|
Offer_ |
varchar2 |
Dirección de la oferta 1 | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Dirección de la oferta 2 | filters on the platform, writable, Offer. |
||
Offer_ |
double |
Cuota de gestión de la oferta | filters on the platform, writable, Offer. |
||
Offer_ |
double |
IVA sobre la tasa de gestión de la oferta | filters on the platform, writable, Offer. |
||
Offer_ |
double |
Reducción fiscal sobre la base de la oferta | filters on the platform, writable, Offer. |
||
Offer_ |
char |
Oferta cancelada | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Offer Ciudad | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Comentarios sobre la oferta | filters on the platform, writable, Offer. |
||
Offer_ |
double |
Porcentaje de contribución a la oferta | filters on the platform, writable, Offer. |
||
Offer_ |
double |
Valor de la contribución de la oferta | filters on the platform, writable, Offer. |
||
Offer_ |
char |
Comentarios sobre el texto de la oferta | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Centro de Costo de la oferta | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
País de la oferta | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Moneda de la oferta | filters on the platform, writable, Offer. |
||
Offer_ |
double |
Tipo de cambio de la moneda de la oferta | filters on the platform, writable, Offer. |
||
Offer_ |
int32 |
Moneda de la oferta | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Oferta: Nombre del cliente | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Indica el número de cliente | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Dirección de entrega de la oferta 1 | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Dirección de entrega de la oferta 2 | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Ciudad de entrega de la oferta | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
País de entrega de la oferta | filters on the platform, writable, Offer. |
||
Offer_ |
datetime |
Fecha de entrega de la oferta | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Nombre de la entrega de la oferta | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Código postal de entrega de la oferta | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Número del documento de oferta | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Información sobre la oferta Correo electrónico Dirección de correo electrónico CCO | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Oferta Información de correo electrónico Dirección de correo electrónico CC | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Información sobre la oferta por correo electrónico. Dirección de correo electrónico del remitente: | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Información sobre la oferta por correo electrónico. Dirección de correo electrónico: | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Información sobre la oferta por correo electrónico. Cuerpo del correo electrónico | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Información sobre la oferta por correo electrónico Asunto del correo electrónico | filters on the platform, writable, Offer. |
||
Offer_ |
datetime |
Fecha de vencimiento de la oferta | filters on the platform, writable, Offer. |
||
Offer_ |
double |
Oferta de transporte | filters on the platform, writable, Offer. |
||
Offer_ |
double |
Oferta de IVA sobre el transporte | filters on the platform, writable, Offer. |
||
Offer_ |
double |
Oferta bruta | filters on the platform, writable, Offer. |
||
Offer_ |
char |
Oferta de trabajo doméstico | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Referencia de la factura de la oferta | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Idioma de la oferta | filters on the platform, writable, Offer. |
||
Offer_ |
double |
Oferta neta | filters on the platform, writable, Offer. |
||
Offer_ |
char |
Oferta no completada | filters on the platform, writable, Offer. |
||
Offer_ |
datetime |
Fecha de la oferta | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Referencia del pedido de oferta | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Número de organización de la oferta | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Oferta de Ourreference | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Oferta Teléfono 1 | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Oferta Teléfono 2 | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Lista de precios de la oferta | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Plantilla de impresión de la oferta | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Proyecto de oferta | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Observaciones sobre la oferta | filters on the platform, writable, Offer. |
||
Offer_ |
double |
Redondeo de la oferta | filters on the platform, writable, Offer. |
||
Offer_ |
char |
Oferta enviada | filters on the platform, writable, Offer. |
||
Offer_ |
int32 |
Oferta de reducción fiscal | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Tipo de reducción fiscal ofrecida | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Condiciones de entrega de la oferta | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Condiciones de pago de la oferta | filters on the platform, writable, Offer. |
||
Offer_ |
double |
Total de la oferta | filters on the platform, writable, Offer. |
||
Offer_ |
double |
Importe total de la oferta a pagar | filters on the platform, writable, Offer. |
||
Offer_ |
double |
Importe total de la oferta (IVA incluido) | filters on the platform, writable, Offer. |
||
Offer_ |
char |
Oferta con IVA incluido | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Ofrecer forma de entrega | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Envía tu referencia | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Indica tu número de referencia de referencia | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Introduce el código postal | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
URL de la oferta | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Lista de reducciones fiscales en la URL de la oferta | filters on the platform, writable, Offer. |
Notas de la Versión
Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: