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

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
DocumentNumber `` 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_AccountingMethod varchar2 Método de contabilidad por factura filters on the platform, writable, Invoice.AccountingMethod
Invoice_Address1 varchar2 Dirección de facturación 1 filters on the platform, writable, Invoice.Address1
Invoice_Address2 varchar2 Dirección de facturación 2 filters on the platform, writable, Invoice.Address2
Invoice_AdministrationFee double Tasa de gestión de facturas filters on the platform, writable, Invoice.AdministrationFee
Invoice_AdministrationFeeVAT double Gastos de gestión de facturas (IVA incluido) filters on the platform, writable, Invoice.AdministrationFeeVAT
Invoice_Balance double Saldo de la factura filters on the platform, writable, Invoice.Balance
Invoice_BasisTaxReduction double Reducción fiscal basada en la factura filters on the platform, writable, Invoice.BasisTaxReduction
Invoice_Booked char Factura contabilizada filters on the platform, writable, Invoice.Booked
Invoice_Cancelled char Factura anulada filters on the platform, writable, Invoice.Cancelled
Invoice_City varchar2(1024) Ciudad de la Factura filters on the platform, writable, Invoice.City
Invoice_Comments varchar2(1024) Comentarios sobre la factura filters on the platform, writable, Invoice.Comments
Invoice_ContractReference int32 Referencia del contrato de la factura filters on the platform, writable, Invoice.ContractReference
Invoice_ContributionPercent double Porcentaje de contribución a la factura filters on the platform, writable, Invoice.ContributionPercent
Invoice_ContributionValue double Valor de la contribución de la factura filters on the platform, writable, Invoice.ContributionValue
Invoice_CostCenter varchar2 Centro de costo de la factura filters on the platform, writable, Invoice.CostCenter
Invoice_Country varchar2 País de la Factura filters on the platform, writable, Invoice.Country
Invoice_Credit varchar2 Crédito de factura filters on the platform, writable, Invoice.Credit
Invoice_CreditInvoiceReference varchar2 Factura Crédito Referencia de la factura filters on the platform, writable, Invoice.CreditInvoiceReference
Invoice_Currency varchar2 Moneda de la factura filters on the platform, writable, Invoice.Currency
Invoice_CurrencyRate double Tipo de cambio de la factura en moneda filters on the platform, writable, Invoice.CurrencyRate
Invoice_CurrencyUnit int32 Moneda de la factura filters on the platform, writable, Invoice.CurrencyUnit
Invoice_CustomerName varchar2 Nombre del cliente en la factura filters on the platform, writable, Invoice.CustomerName
Invoice_CustomerNumber varchar2 N.º de cliente de la factura filters on the platform, writable, Invoice.CustomerNumber
Invoice_DeliveryAddress1 varchar2(1024) Dirección de facturación 1 filters on the platform, writable, Invoice.DeliveryAddress1
Invoice_DeliveryAddress2 varchar2(1024) Dirección de facturación 2 filters on the platform, writable, Invoice.DeliveryAddress2
Invoice_DeliveryCity varchar2(1024) Ciudad de entrega de la factura filters on the platform, writable, Invoice.DeliveryCity
Invoice_DeliveryCountry varchar2 País de entrega de la factura filters on the platform, writable, Invoice.DeliveryCountry
Invoice_DeliveryDate datetime Fecha de entrega de la factura filters on the platform, writable, Invoice.DeliveryDate
Invoice_DeliveryName varchar2(1024) Nombre del destinatario de la factura filters on the platform, writable, Invoice.DeliveryName
Invoice_DeliveryZipCode varchar2(1024) Código postal de entrega de la factura filters on the platform, writable, Invoice.DeliveryZipCode
Invoice_DocumentNumber varchar2 Número de documento de factura filters on the platform, writable, Invoice.DocumentNumber
Invoice_DueDate datetime Fecha de vencimiento de la factura filters on the platform, writable, Invoice.DueDate
Invoice_EDIInformation_EDIGlobalLocationNumber varchar2(13) Información EDI de la factura: Número de ubicación global EDI filters on the platform, writable, Invoice.EDIInformation.EDIGlobalLocationNumber
Invoice_EDIInformation_EDIGlobalLocationNumberDelivery varchar2(13) Factura - Información EDI - Número de ubicación global EDI - Entrega filters on the platform, writable, Invoice.EDIInformation.EDIGlobalLocationNumberDelivery
Invoice_EDIInformation_EDIInvoiceExtra1 varchar2 Información de la factura EDI. Factura EDI adicional 1 filters on the platform, writable, Invoice.EDIInformation.EDIInvoiceExtra1
Invoice_EDIInformation_EDIInvoiceExtra2 varchar2 Información de la factura EDI. Factura EDI adicional 2 filters on the platform, writable, Invoice.EDIInformation.EDIInvoiceExtra2
Invoice_EDIInformation_EDIOurElectronicReference varchar2 Información sobre facturas EDI. EDI. Nuestra referencia electrónica. filters on the platform, writable, Invoice.EDIInformation.EDIOurElectronicReference
Invoice_EDIInformation_EDIStatus varchar2 Factura: Información EDI, Estado EDI filters on the platform, writable, Invoice.EDIInformation.EDIStatus
Invoice_EDIInformation_EDIYourElectronicReference varchar2 Información sobre facturas EDI. EDI: tu referencia electrónica filters on the platform, writable, Invoice.EDIInformation.EDIYourElectronicReference
Invoice_EUQuarterlyReport char Reporte trimestral de la UE sobre facturas filters on the platform, writable, Invoice.EUQuarterlyReport
Invoice_EmailInformation_EmailAddressBCC varchar2 Información del correo electrónico de la factura: Dirección de correo electrónico, CCO filters on the platform, writable, Invoice.EmailInformation.EmailAddressBCC
Invoice_EmailInformation_EmailAddressCC varchar2 Información del correo electrónico de la factura: Dirección de correo electrónico, CC filters on the platform, writable, Invoice.EmailInformation.EmailAddressCC
Invoice_EmailInformation_EmailAddressFrom varchar2 Información del correo electrónico de la factura: Dirección de correo electrónico del remitente filters on the platform, writable, Invoice.EmailInformation.EmailAddressFrom
Invoice_EmailInformation_EmailAddressTo varchar2 Información del correo electrónico de la factura Dirección de correo electrónico: Para filters on the platform, writable, Invoice.EmailInformation.EmailAddressTo
Invoice_EmailInformation_EmailBody varchar2(20000) Información del correo electrónico de la factura: cuerpo del mensaje filters on the platform, writable, Invoice.EmailInformation.EmailBody
Invoice_EmailInformation_EmailSubject varchar2(100) Información del correo electrónico de la factura: Asunto del correo electrónico filters on the platform, writable, Invoice.EmailInformation.EmailSubject
Invoice_ExternalInvoiceReference1 varchar2(80) Factura externa - Referencia de factura 1 filters on the platform, writable, Invoice.ExternalInvoiceReference1
Invoice_ExternalInvoiceReference2 varchar2(80) Factura externa - Referencia de factura 2 filters on the platform, writable, Invoice.ExternalInvoiceReference2
Invoice_FinalPayDate datetime Fecha límite de pago de la factura filters on the platform, writable, Invoice.FinalPayDate
Invoice_Freight double Factura de transporte filters on the platform, writable, Invoice.Freight
Invoice_FreightVAT double Factura, transporte, IVA filters on the platform, writable, Invoice.FreightVAT
Invoice_Gross double Importe bruto de la factura filters on the platform, writable, Invoice.Gross
Invoice_HouseWork char Tareas relacionadas con la facturación filters on the platform, writable, Invoice.HouseWork
Invoice_InvoiceDate datetime Fecha de la Factura filters on the platform, writable, Invoice.InvoiceDate
Invoice_InvoicePeriodEnd datetime Fin del período de facturación filters on the platform, writable, Invoice.InvoicePeriodEnd
Invoice_InvoicePeriodReference varchar2 Referencia del período de facturación filters on the platform, writable, Invoice.InvoicePeriodReference
Invoice_InvoicePeriodStart datetime Inicio del período de facturación filters on the platform, writable, Invoice.InvoicePeriodStart
Invoice_InvoiceType varchar2 Tipo de Factura filters on the platform, writable, Invoice.InvoiceType
Invoice_Language varchar2 Idioma de la factura filters on the platform, writable, Invoice.Language
Invoice_LastRemindDate datetime Fecha del último recordatorio de la factura filters on the platform, writable, Invoice.LastRemindDate
Invoice_Net double Factura neta filters on the platform, writable, Invoice.Net
Invoice_NotCompleted char Factura sin completar filters on the platform, writable, Invoice.NotCompleted
Invoice_NoxFinans char Factura de Nox Finans filters on the platform, writable, Invoice.NoxFinans
Invoice_OCR varchar2 Reconocimiento óptico de caracteres (OCR) de facturas filters on the platform, writable, Invoice.OCR
Invoice_OfferReference varchar2 Referencia de la oferta de factura filters on the platform, writable, Invoice.OfferReference
Invoice_OrderReference varchar2 Referencia de la factura y del pedido filters on the platform, writable, Invoice.OrderReference
Invoice_OrganisationNumber varchar2 Número de referencia de la factura filters on the platform, writable, Invoice.OrganisationNumber
Invoice_OurReference varchar2(50) Factura N.º de referencia filters on the platform, writable, Invoice.OurReference
Invoice_OutboundDate datetime Fecha de emisión de la factura filters on the platform, writable, Invoice.OutboundDate
Invoice_PaymentWay varchar2 Forma de pago de la factura filters on the platform, writable, Invoice.PaymentWay
Invoice_Phone1 varchar2(1024) Factura Teléfono 1 filters on the platform, writable, Invoice.Phone1
Invoice_Phone2 varchar2(1024) Factura Teléfono 2 filters on the platform, writable, Invoice.Phone2
Invoice_PriceList varchar2 Lista de precios de facturas filters on the platform, writable, Invoice.PriceList
Invoice_PrintTemplate varchar2 Plantilla de impresión de facturas filters on the platform, writable, Invoice.PrintTemplate
Invoice_Project varchar2 Proyecto de facturación filters on the platform, writable, Invoice.Project
Invoice_Remarks varchar2(1024) Observaciones de la factura filters on the platform, writable, Invoice.Remarks
Invoice_Reminders int32 Recordatorios de facturas filters on the platform, writable, Invoice.Reminders
Invoice_RoundOff double Redondeo de facturas filters on the platform, writable, Invoice.RoundOff
Invoice_Sent char Factura enviada filters on the platform, writable, Invoice.Sent
Invoice_TaxReduction int32 Reducción del impuesto sobre las facturas filters on the platform, writable, Invoice.TaxReduction
Invoice_TaxReductionType varchar2 Tipo de reducción fiscal en la factura filters on the platform, writable, Invoice.TaxReductionType
Invoice_TermsOfDelivery varchar2 Condiciones de entrega de la factura filters on the platform, writable, Invoice.TermsOfDelivery
Invoice_TermsOfPayment varchar2 Condiciones de pago de las facturas filters on the platform, writable, Invoice.TermsOfPayment
Invoice_TimeBasisReference int32 Referencia de la base temporal de la factura filters on the platform, writable, Invoice.TimeBasisReference
Invoice_Total double Total de la factura filters on the platform, writable, Invoice.Total
Invoice_TotalToPay double Importe total a pagar de la factura filters on the platform, writable, Invoice.TotalToPay
Invoice_TotalVAT double Total de la factura (IVA incluido) filters on the platform, writable, Invoice.TotalVAT
Invoice_VATIncluded char Factura con IVA incluido filters on the platform, writable, Invoice.VATIncluded
Invoice_VoucherNumber int32 Número de comprobante de factura filters on the platform, writable, Invoice.VoucherNumber
Invoice_VoucherSeries varchar2 Serie de comprobantes de factura filters on the platform, writable, Invoice.VoucherSeries
Invoice_VoucherYear int32 Factura, comprobante, año filters on the platform, writable, Invoice.VoucherYear
Invoice_WarehouseReady char Factura lista para el almacén filters on the platform, writable, Invoice.WarehouseReady
Invoice_WayOfDelivery varchar2 Forma de entrega indicada en la factura filters on the platform, writable, Invoice.WayOfDelivery
Invoice_YourOrderNumber varchar2(75) Factura con tu número de pedido filters on the platform, writable, Invoice.YourOrderNumber
Invoice_YourReference varchar2(50) N.º de referencia de la factura filters on the platform, writable, Invoice.YourReference
Invoice_ZipCode varchar2(1024) Código Postal de la Factura filters on the platform, writable, Invoice.ZipCode
Invoice__url varchar2 URL de la factura filters on the platform, writable, Invoice.@url
Invoice__urlTaxReductionList varchar2 Lista de reducciones fiscales de la URL de la factura filters on the platform, writable, Invoice.@urlTaxReductionList

Notas de la Versión

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