InvoiceByDocumentNumber: Fortnox Invoice by Document Number
read only REST
- Catálogo:
Fortnox - Esquema:
Invoices - Label: Invoice by Document Number
Retrieve a single invoice
Solo puede recuperar datos.
Fuente de la API
- Punto final:
/3/invoices/{DocumentNumber} - Operación:
get /3/invoices/{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 invoice | ||
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 InvoiceByDocumentNumber. 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 |
|---|---|---|---|---|---|
Invoice_ |
varchar2 |
Método de contabilidad por factura | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Dirección de facturación 1 | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Dirección de facturación 2 | filters on the platform, writable, Invoice. |
||
Invoice_ |
double |
Tasa de gestión de facturas | filters on the platform, writable, Invoice. |
||
Invoice_ |
double |
Gastos de gestión de facturas (IVA incluido) | filters on the platform, writable, Invoice. |
||
Invoice_ |
double |
Saldo de la factura | filters on the platform, writable, Invoice. |
||
Invoice_ |
double |
Reducción fiscal basada en la factura | filters on the platform, writable, Invoice. |
||
Invoice_ |
char |
Factura contabilizada | filters on the platform, writable, Invoice. |
||
Invoice_ |
char |
Factura anulada | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Ciudad de la Factura | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Comentarios sobre la factura | filters on the platform, writable, Invoice. |
||
Invoice_ |
int32 |
Referencia del contrato de la factura | filters on the platform, writable, Invoice. |
||
Invoice_ |
double |
Porcentaje de contribución a la factura | filters on the platform, writable, Invoice. |
||
Invoice_ |
double |
Valor de la contribución de la factura | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Centro de costo de la factura | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
País de la Factura | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Crédito de factura | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Factura Crédito Referencia de la factura | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Moneda de la factura | filters on the platform, writable, Invoice. |
||
Invoice_ |
double |
Tipo de cambio de la factura en moneda | filters on the platform, writable, Invoice. |
||
Invoice_ |
int32 |
Moneda de la factura | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Nombre del cliente en la factura | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
N.º de cliente de la factura | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Dirección de facturación 1 | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Dirección de facturación 2 | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Ciudad de entrega de la factura | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
País de entrega de la factura | filters on the platform, writable, Invoice. |
||
Invoice_ |
datetime |
Fecha de entrega de la factura | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Nombre del destinatario de la factura | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Código postal de entrega de la factura | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Número de documento de factura | filters on the platform, writable, Invoice. |
||
Invoice_ |
datetime |
Fecha de vencimiento de la factura | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Información EDI de la factura: Número de ubicación global EDI | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Factura - Información EDI - Número de ubicación global EDI - Entrega | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Información de la factura EDI. Factura EDI adicional 1 | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Información de la factura EDI. Factura EDI adicional 2 | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Información sobre facturas EDI. EDI. Nuestra referencia electrónica. | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Factura: Información EDI, Estado EDI | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Información sobre facturas EDI. EDI: tu referencia electrónica | filters on the platform, writable, Invoice. |
||
Invoice_ |
char |
Reporte trimestral de la UE sobre facturas | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Información del correo electrónico de la factura: Dirección de correo electrónico, CCO | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Información del correo electrónico de la factura: Dirección de correo electrónico, CC | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Información del correo electrónico de la factura: Dirección de correo electrónico del remitente | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Información del correo electrónico de la factura Dirección de correo electrónico: Para | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Información del correo electrónico de la factura: cuerpo del mensaje | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Información del correo electrónico de la factura: Asunto del correo electrónico | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Factura externa - Referencia de factura 1 | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Factura externa - Referencia de factura 2 | filters on the platform, writable, Invoice. |
||
Invoice_ |
datetime |
Fecha límite de pago de la factura | filters on the platform, writable, Invoice. |
||
Invoice_ |
double |
Factura de transporte | filters on the platform, writable, Invoice. |
||
Invoice_ |
double |
Factura, transporte, IVA | filters on the platform, writable, Invoice. |
||
Invoice_ |
double |
Importe bruto de la factura | filters on the platform, writable, Invoice. |
||
Invoice_ |
char |
Tareas relacionadas con la facturación | filters on the platform, writable, Invoice. |
||
Invoice_ |
datetime |
Fecha de la Factura | filters on the platform, writable, Invoice. |
||
Invoice_ |
datetime |
Fin del período de facturación | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Referencia del período de facturación | filters on the platform, writable, Invoice. |
||
Invoice_ |
datetime |
Inicio del período de facturación | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Tipo de Factura | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Idioma de la factura | filters on the platform, writable, Invoice. |
||
Invoice_ |
datetime |
Fecha del último recordatorio de la factura | filters on the platform, writable, Invoice. |
||
Invoice_ |
double |
Factura neta | filters on the platform, writable, Invoice. |
||
Invoice_ |
char |
Factura sin completar | filters on the platform, writable, Invoice. |
||
Invoice_ |
char |
Factura de Nox Finans | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Reconocimiento óptico de caracteres (OCR) de facturas | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Referencia de la oferta de factura | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Referencia de la factura y del pedido | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Número de referencia de la factura | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Factura N.º de referencia | filters on the platform, writable, Invoice. |
||
Invoice_ |
datetime |
Fecha de emisión de la factura | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Forma de pago de la factura | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Factura Teléfono 1 | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Factura Teléfono 2 | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Lista de precios de facturas | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Plantilla de impresión de facturas | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Proyecto de facturación | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Observaciones de la factura | filters on the platform, writable, Invoice. |
||
Invoice_ |
int32 |
Recordatorios de facturas | filters on the platform, writable, Invoice. |
||
Invoice_ |
double |
Redondeo de facturas | filters on the platform, writable, Invoice. |
||
Invoice_ |
char |
Factura enviada | filters on the platform, writable, Invoice. |
||
Invoice_ |
int32 |
Reducción del impuesto sobre las facturas | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Tipo de reducción fiscal en la factura | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Condiciones de entrega de la factura | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Condiciones de pago de las facturas | filters on the platform, writable, Invoice. |
||
Invoice_ |
int32 |
Referencia de la base temporal de la factura | filters on the platform, writable, Invoice. |
||
Invoice_ |
double |
Total de la factura | filters on the platform, writable, Invoice. |
||
Invoice_ |
double |
Importe total a pagar de la factura | filters on the platform, writable, Invoice. |
||
Invoice_ |
double |
Total de la factura (IVA incluido) | filters on the platform, writable, Invoice. |
||
Invoice_ |
char |
Factura con IVA incluido | filters on the platform, writable, Invoice. |
||
Invoice_ |
int32 |
Número de comprobante de factura | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Serie de comprobantes de factura | filters on the platform, writable, Invoice. |
||
Invoice_ |
int32 |
Factura, comprobante, año | filters on the platform, writable, Invoice. |
||
Invoice_ |
char |
Factura lista para el almacén | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Forma de entrega indicada en la factura | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Factura con tu número de pedido | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
N.º de referencia de la factura | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Código Postal de la Factura | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
URL de la factura | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Lista de reducciones fiscales de la URL de la factura | filters on the platform, writable, Invoice. |
Notas de la Versión
Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: