invantive documentation
Forum di supporto InvantiveAccedi / Registrati

OfferByDocumentNumber: Fortnox Offer by Document Number

read only REST

  • Catalogo: Fortnox
  • Schema: Offers
  • Label: Offer by Document Number

Retrieve a single offer

È possibile solo recuperare i dati.

Codice sorgente dell'API

  • Punto finale: /3/offers/{DocumentNumber}
  • Operazione: get /3/offers/{DocumentNumber}

Caratteristiche prestazionali

Characteristic Value
Latenza media di accesso (ms) 356
Righe di scansione completa al minuto 85,000
Numero di righe di Query al minuto 168

Il risultato può essere memorizzato nella memoria cache sul client.

Parametri

Name Tipo di dati 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).

Colonne della tabella

Di seguito sono riportate le colonne della tabella OfferByDocumentNumber. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.

Name Tipo di dati Label Required Marks Documentation
Offer_Address1 varchar2(1024) Indirizzo dell'offerta 1 filters on the platform, writable, Offer.Address1
Offer_Address2 varchar2(1024) Indirizzo dell'offerta 2 filters on the platform, writable, Offer.Address2
Offer_AdministrationFee double Commissione di gestione dell'offerta filters on the platform, writable, Offer.AdministrationFee
Offer_AdministrationFeeVAT double IVA sulla commissione di gestione dell'offerta filters on the platform, writable, Offer.AdministrationFeeVAT
Offer_BasisTaxReduction double Riduzione fiscale sulla base dell'offerta filters on the platform, writable, Offer.BasisTaxReduction
Offer_Cancelled char Offerta annullata filters on the platform, writable, Offer.Cancelled
Offer_City varchar2(1024) Città dell'offerta filters on the platform, writable, Offer.City
Offer_Comments varchar2(1024) Commenti sull'offerta filters on the platform, writable, Offer.Comments
Offer_ContributionPercent double Percentuale di contributo all'offerta filters on the platform, writable, Offer.ContributionPercent
Offer_ContributionValue double Valore del contributo all'offerta filters on the platform, writable, Offer.ContributionValue
Offer_CopyRemarks char Note sul testo dell'offerta filters on the platform, writable, Offer.CopyRemarks
Offer_CostCenter varchar2 Centro di costo dell'offerta filters on the platform, writable, Offer.CostCenter
Offer_Country varchar2 Paese dell'offerta filters on the platform, writable, Offer.Country
Offer_Currency varchar2 Valuta dell'offerta filters on the platform, writable, Offer.Currency
Offer_CurrencyRate double Tasso di cambio della valuta dell'offerta filters on the platform, writable, Offer.CurrencyRate
Offer_CurrencyUnit int32 Unità di valuta dell'offerta filters on the platform, writable, Offer.CurrencyUnit
Offer_CustomerName varchar2 Nome del cliente dell'offerta filters on the platform, writable, Offer.CustomerName
Offer_CustomerNumber varchar2 Inserisci il numero cliente filters on the platform, writable, Offer.CustomerNumber
Offer_DeliveryAddress1 varchar2(1024) Indirizzo di consegna dell'offerta 1 filters on the platform, writable, Offer.DeliveryAddress1
Offer_DeliveryAddress2 varchar2(1024) Indirizzo di consegna dell'offerta 2 filters on the platform, writable, Offer.DeliveryAddress2
Offer_DeliveryCity varchar2(1024) Città di consegna dell'offerta filters on the platform, writable, Offer.DeliveryCity
Offer_DeliveryCountry varchar2 Paese di consegna dell'offerta filters on the platform, writable, Offer.DeliveryCountry
Offer_DeliveryDate datetime Data di consegna dell'offerta filters on the platform, writable, Offer.DeliveryDate
Offer_DeliveryName varchar2(1024) Nome del destinatario della consegna filters on the platform, writable, Offer.DeliveryName
Offer_DeliveryZipCode varchar2 Codice postale per la consegna dell'offerta filters on the platform, writable, Offer.DeliveryZipCode
Offer_DocumentNumber varchar2 Numero del documento di offerta filters on the platform, writable, Offer.DocumentNumber
Offer_EmailInformation_EmailAddressBCC varchar2 Informazioni sull'offerta Indirizzo e-mail Copia nascosta filters on the platform, writable, Offer.EmailInformation.EmailAddressBCC
Offer_EmailInformation_EmailAddressCC varchar2 Informazioni sull'offerta Indirizzo e-mail CC filters on the platform, writable, Offer.EmailInformation.EmailAddressCC
Offer_EmailInformation_EmailAddressFrom varchar2 Informazioni sull'e-mail dell'offerta Indirizzo e-mail del mittente filters on the platform, writable, Offer.EmailInformation.EmailAddressFrom
Offer_EmailInformation_EmailAddressTo varchar2 Invia le informazioni via e-mail Indirizzo e-mail a filters on the platform, writable, Offer.EmailInformation.EmailAddressTo
Offer_EmailInformation_EmailBody varchar2(20000) Informazioni sull'offerta via e-mail Testo dell'e-mail filters on the platform, writable, Offer.EmailInformation.EmailBody
Offer_EmailInformation_EmailSubject varchar2(100) Informazioni sull'offerta via e-mail Oggetto dell'e-mail filters on the platform, writable, Offer.EmailInformation.EmailSubject
Offer_ExpireDate datetime Data di scadenza dell'offerta filters on the platform, writable, Offer.ExpireDate
Offer_Freight double Offerta di trasporto merci filters on the platform, writable, Offer.Freight
Offer_FreightVAT double IVA sul trasporto dell'offerta filters on the platform, writable, Offer.FreightVAT
Offer_Gross double Offerta lorda filters on the platform, writable, Offer.Gross
Offer_HouseWork char Offerta di lavoro domestico filters on the platform, writable, Offer.HouseWork
Offer_InvoiceReference varchar2 Riferimento della fattura dell'offerta filters on the platform, writable, Offer.InvoiceReference
Offer_Language varchar2 Lingua dell'offerta filters on the platform, writable, Offer.Language
Offer_Net double Offerta netta filters on the platform, writable, Offer.Net
Offer_NotCompleted char Offerta non completata filters on the platform, writable, Offer.NotCompleted
Offer_OfferDate datetime Data dell'offerta filters on the platform, writable, Offer.OfferDate
Offer_OrderReference varchar2 Riferimento dell'ordine di offerta filters on the platform, writable, Offer.OrderReference
Offer_OrganisationNumber varchar2 Numero di identificazione dell'organizzazione che presenta l'offerta filters on the platform, writable, Offer.OrganisationNumber
Offer_OurReference varchar2 Offerta Ourreference filters on the platform, writable, Offer.OurReference
Offer_Phone1 varchar2 Offerta Telefono 1 filters on the platform, writable, Offer.Phone1
Offer_Phone2 varchar2 Offerta Telefono 2 filters on the platform, writable, Offer.Phone2
Offer_PriceList varchar2 Listino prezzi delle offerte filters on the platform, writable, Offer.PriceList
Offer_PrintTemplate varchar2 Modello di stampa dell'offerta filters on the platform, writable, Offer.PrintTemplate
Offer_Project varchar2 Progetto di offerta filters on the platform, writable, Offer.Project
Offer_Remarks varchar2 Note sull'offerta filters on the platform, writable, Offer.Remarks
Offer_RoundOff double Arrotondamento dell'offerta filters on the platform, writable, Offer.RoundOff
Offer_Sent char Offerta inviata filters on the platform, writable, Offer.Sent
Offer_TaxReduction int32 Offerta di riduzione fiscale filters on the platform, writable, Offer.TaxReduction
Offer_TaxReductionType varchar2 Tipo di riduzione fiscale offerta filters on the platform, writable, Offer.TaxReductionType
Offer_TermsOfDelivery varchar2 Condizioni di consegna dell'offerta filters on the platform, writable, Offer.TermsOfDelivery
Offer_TermsOfPayment varchar2 Condizioni di pagamento dell'offerta filters on the platform, writable, Offer.TermsOfPayment
Offer_Total double Totale dell'offerta filters on the platform, writable, Offer.Total
Offer_TotalToPay double Totale da pagare filters on the platform, writable, Offer.TotalToPay
Offer_TotalVAT double Offerta Totale IVA inclusa filters on the platform, writable, Offer.TotalVAT
Offer_VATIncluded char Offerta IVA inclusa filters on the platform, writable, Offer.VATIncluded
Offer_WayOfDelivery varchar2 Modalità di consegna dell'offerta filters on the platform, writable, Offer.WayOfDelivery
Offer_YourReference varchar2 Fornisci i tuoi riferimenti filters on the platform, writable, Offer.YourReference
Offer_YourReferenceNumber varchar2 Inserisci il tuo numero di riferimento per il riferimento filters on the platform, writable, Offer.YourReferenceNumber
Offer_ZipCode varchar2 Inserisci il codice postale filters on the platform, writable, Offer.ZipCode
Offer__url varchar2 URL dell'offerta filters on the platform, writable, Offer.@url
Offer__urlTaxReductionList varchar2 Elenco delle riduzioni fiscali relative agli URL delle offerte filters on the platform, writable, Offer.@urlTaxReductionList

Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: