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

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
DocumentNumber `` 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_Address1 varchar2(1024) Dirección de la oferta 1 filters on the platform, writable, Offer.Address1
Offer_Address2 varchar2(1024) Dirección de la oferta 2 filters on the platform, writable, Offer.Address2
Offer_AdministrationFee double Cuota de gestión de la oferta filters on the platform, writable, Offer.AdministrationFee
Offer_AdministrationFeeVAT double IVA sobre la tasa de gestión de la oferta filters on the platform, writable, Offer.AdministrationFeeVAT
Offer_BasisTaxReduction double Reducción fiscal sobre la base de la oferta filters on the platform, writable, Offer.BasisTaxReduction
Offer_Cancelled char Oferta cancelada filters on the platform, writable, Offer.Cancelled
Offer_City varchar2(1024) Offer Ciudad filters on the platform, writable, Offer.City
Offer_Comments varchar2(1024) Comentarios sobre la oferta filters on the platform, writable, Offer.Comments
Offer_ContributionPercent double Porcentaje de contribución a la oferta filters on the platform, writable, Offer.ContributionPercent
Offer_ContributionValue double Valor de la contribución de la oferta filters on the platform, writable, Offer.ContributionValue
Offer_CopyRemarks char Comentarios sobre el texto de la oferta filters on the platform, writable, Offer.CopyRemarks
Offer_CostCenter varchar2 Centro de Costo de la oferta filters on the platform, writable, Offer.CostCenter
Offer_Country varchar2 País de la oferta filters on the platform, writable, Offer.Country
Offer_Currency varchar2 Moneda de la oferta filters on the platform, writable, Offer.Currency
Offer_CurrencyRate double Tipo de cambio de la moneda de la oferta filters on the platform, writable, Offer.CurrencyRate
Offer_CurrencyUnit int32 Moneda de la oferta filters on the platform, writable, Offer.CurrencyUnit
Offer_CustomerName varchar2 Oferta: Nombre del cliente filters on the platform, writable, Offer.CustomerName
Offer_CustomerNumber varchar2 Indica el número de cliente filters on the platform, writable, Offer.CustomerNumber
Offer_DeliveryAddress1 varchar2(1024) Dirección de entrega de la oferta 1 filters on the platform, writable, Offer.DeliveryAddress1
Offer_DeliveryAddress2 varchar2(1024) Dirección de entrega de la oferta 2 filters on the platform, writable, Offer.DeliveryAddress2
Offer_DeliveryCity varchar2(1024) Ciudad de entrega de la oferta filters on the platform, writable, Offer.DeliveryCity
Offer_DeliveryCountry varchar2 País de entrega de la oferta filters on the platform, writable, Offer.DeliveryCountry
Offer_DeliveryDate datetime Fecha de entrega de la oferta filters on the platform, writable, Offer.DeliveryDate
Offer_DeliveryName varchar2(1024) Nombre de la entrega de la oferta filters on the platform, writable, Offer.DeliveryName
Offer_DeliveryZipCode varchar2 Código postal de entrega de la oferta filters on the platform, writable, Offer.DeliveryZipCode
Offer_DocumentNumber varchar2 Número del documento de oferta filters on the platform, writable, Offer.DocumentNumber
Offer_EmailInformation_EmailAddressBCC varchar2 Información sobre la oferta Correo electrónico Dirección de correo electrónico CCO filters on the platform, writable, Offer.EmailInformation.EmailAddressBCC
Offer_EmailInformation_EmailAddressCC varchar2 Oferta Información de correo electrónico Dirección de correo electrónico CC filters on the platform, writable, Offer.EmailInformation.EmailAddressCC
Offer_EmailInformation_EmailAddressFrom varchar2 Información sobre la oferta por correo electrónico. Dirección de correo electrónico del remitente: filters on the platform, writable, Offer.EmailInformation.EmailAddressFrom
Offer_EmailInformation_EmailAddressTo varchar2 Información sobre la oferta por correo electrónico. Dirección de correo electrónico: filters on the platform, writable, Offer.EmailInformation.EmailAddressTo
Offer_EmailInformation_EmailBody varchar2(20000) Información sobre la oferta por correo electrónico. Cuerpo del correo electrónico filters on the platform, writable, Offer.EmailInformation.EmailBody
Offer_EmailInformation_EmailSubject varchar2(100) Información sobre la oferta por correo electrónico Asunto del correo electrónico filters on the platform, writable, Offer.EmailInformation.EmailSubject
Offer_ExpireDate datetime Fecha de vencimiento de la oferta filters on the platform, writable, Offer.ExpireDate
Offer_Freight double Oferta de transporte filters on the platform, writable, Offer.Freight
Offer_FreightVAT double Oferta de IVA sobre el transporte filters on the platform, writable, Offer.FreightVAT
Offer_Gross double Oferta bruta filters on the platform, writable, Offer.Gross
Offer_HouseWork char Oferta de trabajo doméstico filters on the platform, writable, Offer.HouseWork
Offer_InvoiceReference varchar2 Referencia de la factura de la oferta filters on the platform, writable, Offer.InvoiceReference
Offer_Language varchar2 Idioma de la oferta filters on the platform, writable, Offer.Language
Offer_Net double Oferta neta filters on the platform, writable, Offer.Net
Offer_NotCompleted char Oferta no completada filters on the platform, writable, Offer.NotCompleted
Offer_OfferDate datetime Fecha de la oferta filters on the platform, writable, Offer.OfferDate
Offer_OrderReference varchar2 Referencia del pedido de oferta filters on the platform, writable, Offer.OrderReference
Offer_OrganisationNumber varchar2 Número de organización de la oferta filters on the platform, writable, Offer.OrganisationNumber
Offer_OurReference varchar2 Oferta de Ourreference filters on the platform, writable, Offer.OurReference
Offer_Phone1 varchar2 Oferta Teléfono 1 filters on the platform, writable, Offer.Phone1
Offer_Phone2 varchar2 Oferta Teléfono 2 filters on the platform, writable, Offer.Phone2
Offer_PriceList varchar2 Lista de precios de la oferta filters on the platform, writable, Offer.PriceList
Offer_PrintTemplate varchar2 Plantilla de impresión de la oferta filters on the platform, writable, Offer.PrintTemplate
Offer_Project varchar2 Proyecto de oferta filters on the platform, writable, Offer.Project
Offer_Remarks varchar2 Observaciones sobre la oferta filters on the platform, writable, Offer.Remarks
Offer_RoundOff double Redondeo de la oferta filters on the platform, writable, Offer.RoundOff
Offer_Sent char Oferta enviada filters on the platform, writable, Offer.Sent
Offer_TaxReduction int32 Oferta de reducción fiscal filters on the platform, writable, Offer.TaxReduction
Offer_TaxReductionType varchar2 Tipo de reducción fiscal ofrecida filters on the platform, writable, Offer.TaxReductionType
Offer_TermsOfDelivery varchar2 Condiciones de entrega de la oferta filters on the platform, writable, Offer.TermsOfDelivery
Offer_TermsOfPayment varchar2 Condiciones de pago de la oferta filters on the platform, writable, Offer.TermsOfPayment
Offer_Total double Total de la oferta filters on the platform, writable, Offer.Total
Offer_TotalToPay double Importe total de la oferta a pagar filters on the platform, writable, Offer.TotalToPay
Offer_TotalVAT double Importe total de la oferta (IVA incluido) filters on the platform, writable, Offer.TotalVAT
Offer_VATIncluded char Oferta con IVA incluido filters on the platform, writable, Offer.VATIncluded
Offer_WayOfDelivery varchar2 Ofrecer forma de entrega filters on the platform, writable, Offer.WayOfDelivery
Offer_YourReference varchar2 Envía tu referencia filters on the platform, writable, Offer.YourReference
Offer_YourReferenceNumber varchar2 Indica tu número de referencia de referencia filters on the platform, writable, Offer.YourReferenceNumber
Offer_ZipCode varchar2 Introduce el código postal filters on the platform, writable, Offer.ZipCode
Offer__url varchar2 URL de la oferta filters on the platform, writable, Offer.@url
Offer__urlTaxReductionList varchar2 Lista de reducciones fiscales en la URL de la oferta filters on the platform, writable, Offer.@urlTaxReductionList

Notas de la Versión

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