invantive documentation
Forum di supporto InvantiveAccedi / Registrati

OrderLabelsByDocumentNumber: Fortnox Order Labels by Document Number

read only REST

  • Catalogo: Fortnox
  • Schema: Orders
  • Label: Order Labels by Document Number

Retrieve a single order

È possibile solo recuperare i dati.

Codice sorgente dell'API

  • Punto finale: /3/orders/{DocumentNumber}
  • Operazione: get /3/orders/{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 order
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 OrderLabelsByDocumentNumber. 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
Address1 varchar2 Indirizzo 1 writable, ::ancestor.Address1
Address2 varchar2 Indirizzo 2 writable, ::ancestor.Address2
AdministrationFee double Spese amministrative writable, ::ancestor.AdministrationFee
AdministrationFeeVAT double Spese amministrative IVA writable, ::ancestor.AdministrationFeeVAT
BasisTaxReduction double Riduzione fiscale di base writable, ::ancestor.BasisTaxReduction
Cancelled char Cancelled writable, ::ancestor.Cancelled
City varchar2 City writable, ::ancestor.City
Comments varchar2 Comments writable, ::ancestor.Comments
ContributionPercent double Percentuale di contribuzione writable, ::ancestor.ContributionPercent
ContributionValue double Valore del contributo writable, ::ancestor.ContributionValue
CopyRemarks char Copiare i commenti writable, ::ancestor.CopyRemarks
CostCenter varchar2 Centro di costo writable, ::ancestor.CostCenter
Country varchar2 Country writable, ::ancestor.Country
Currency varchar2(3) Currency writable, ::ancestor.Currency
CurrencyRate double Tasso di cambio della valuta writable, ::ancestor.CurrencyRate
CurrencyUnit double Valuta writable, ::ancestor.CurrencyUnit
CustomerName varchar2 Nome del cliente writable, ::ancestor.CustomerName
CustomerNumber varchar2 Numero del cliente writable, ::ancestor.CustomerNumber
DeliveryAddress1 varchar2 Indirizzo di consegna 1 writable, ::ancestor.DeliveryAddress1
DeliveryAddress2 varchar2 Indirizzo di consegna 2 writable, ::ancestor.DeliveryAddress2
DeliveryCity varchar2 Città di consegna writable, ::ancestor.DeliveryCity
DeliveryCountry varchar2 Paese della consegna writable, ::ancestor.DeliveryCountry
DeliveryDate datetime Data di consegna writable, ::ancestor.DeliveryDate
DeliveryName varchar2 Nome del destinatario writable, ::ancestor.DeliveryName
DeliveryState varchar2 Stato della consegna writable, ::ancestor.DeliveryState
DeliveryZipCode varchar2 Codice postale di consegna writable, ::ancestor.DeliveryZipCode
DocumentNumber varchar2 Numero del documento writable, ::ancestor.DocumentNumber
EmailInformation_EmailAddressBCC varchar2 Informazioni sull'e-mail Indirizzo e-mail Ccn writable, ::ancestor.EmailInformation.EmailAddressBCC
EmailInformation_EmailAddressCC varchar2 Informazioni sull'e-mail Indirizzo e-mail CC writable, ::ancestor.EmailInformation.EmailAddressCC
EmailInformation_EmailAddressFrom varchar2 Informazioni sull'e-mail Indirizzo e-mail del mittente writable, ::ancestor.EmailInformation.EmailAddressFrom
EmailInformation_EmailAddressTo varchar2 Informazioni sull'e-mail Indirizzo e-mail A writable, ::ancestor.EmailInformation.EmailAddressTo
EmailInformation_EmailBody varchar2 Informazioni sull'e-mail Testo dell'e-mail writable, ::ancestor.EmailInformation.EmailBody
EmailInformation_EmailSubject varchar2 Informazioni sull'e-mail Oggetto dell'e-mail writable, ::ancestor.EmailInformation.EmailSubject
ExternalInvoiceReference1 varchar2 Riferimento fattura esterna 1 writable, ::ancestor.ExternalInvoiceReference1
ExternalInvoiceReference2 varchar2 Riferimento fattura esterna 2 writable, ::ancestor.ExternalInvoiceReference2
Freight double Freight writable, ::ancestor.Freight
FreightVAT double IVA sulle merci writable, ::ancestor.FreightVAT
Gross double Gross writable, ::ancestor.Gross
HouseWork char Lavori domestici writable, ::ancestor.HouseWork
Id int32 ID writable, Id
InvoiceReference varchar2 Riferimento della fattura writable, ::ancestor.InvoiceReference
Language varchar2 Language writable, ::ancestor.Language
Net double Net writable, ::ancestor.Net
NotCompleted char Notcompleted writable, ::ancestor.NotCompleted
OfferReference varchar2 Riferimento dell'offerta writable, ::ancestor.OfferReference
OrderDate datetime Data dell'ordine writable, ::ancestor.OrderDate
OrderType varchar2 Tipo d'ordine writable, ::ancestor.OrderType
OrganisationNumber varchar2 Numero di registrazione dell'organizzazione writable, ::ancestor.OrganisationNumber
OurReference varchar2(50) Ourreference writable, ::ancestor.OurReference
OutboundDate datetime Data di partenza writable, ::ancestor.OutboundDate
Phone1 varchar2 Telefono 1 writable, ::ancestor.Phone1
Phone2 varchar2 Telefono 2 writable, ::ancestor.Phone2
PriceList varchar2 Listino prezzi writable, ::ancestor.PriceList
PrintTemplate varchar2 Stampa modello writable, ::ancestor.PrintTemplate
Project varchar2 Project writable, ::ancestor.Project
Remarks varchar2(1024) Remarks writable, ::ancestor.Remarks
RoundOff double Arrotondamento writable, ::ancestor.RoundOff
Sent char Sent writable, ::ancestor.Sent
StockPointCode varchar2 Codice articolo writable, ::ancestor.StockPointCode
StockPointId varchar2 ID punto di magazzino writable, ::ancestor.StockPointId
TaxReduction double Riduzione delle imposte writable, ::ancestor.TaxReduction
TaxReductionType varchar2 Tipo di riduzione fiscale writable, ::ancestor.TaxReductionType
TermsOfDelivery varchar2 Condizioni di consegna writable, ::ancestor.TermsOfDelivery
TermsOfPayment varchar2 Condizioni di pagamento writable, ::ancestor.TermsOfPayment
TimeBasisReference int32 Riferimento temporale writable, ::ancestor.TimeBasisReference
Total double Total writable, ::ancestor.Total
TotalToPay double Totale da pagare writable, ::ancestor.TotalToPay
TotalVAT double IVA totale writable, ::ancestor.TotalVAT
VATIncluded char Vatincluded writable, ::ancestor.VATIncluded
WarehouseReady char Pronto per il magazzino writable, ::ancestor.WarehouseReady
WayOfDelivery varchar2 Modalità di consegna writable, ::ancestor.WayOfDelivery
YourOrderNumber varchar2(75) Il numero del tuo ordine writable, ::ancestor.YourOrderNumber
YourReference varchar2(50) Il tuo Riferimento writable, ::ancestor.YourReference
ZipCode varchar2 Codice postale writable, ::ancestor.ZipCode
c_url varchar2 URL di chiamata writable, ::ancestor.@url
c_urlTaxReductionList varchar2 Elenco delle riduzioni fiscali relative agli URL writable, ::ancestor.@urlTaxReductionList

Note di rilascio

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