invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

OrderLabelsByDocumentNumber: Fortnox Order Labels by Document Number

read only REST

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

Retrieve a single order

Kan alleen gegevens ophalen.

API-bron

  • Eindpunt: /3/orders/{DocumentNumber}
  • Operatie: get /3/orders/{DocumentNumber}

Prestatiekenmerken

Characteristic Value
Gemiddelde toegangsvertraging (ms) 356
Aantal rijen per minuut bij volledige scan 85,000
Aantal rijen per minuut in een Query 168

Het resultaat kan op de client in de Cache worden opgeslagen.

Parameters

Name Datatype 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).

Tabelkolommen

De kolommen van de tabel OrderLabelsByDocumentNumber worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.

Name Datatype Label Required Marks Documentation
Address1 varchar2 Adresregel 1 writable, ::ancestor.Address1
Address2 varchar2 Adresregel 2 writable, ::ancestor.Address2
AdministrationFee double Administratiekosten writable, ::ancestor.AdministrationFee
AdministrationFeeVAT double Administratiekosten BTW writable, ::ancestor.AdministrationFeeVAT
BasisTaxReduction double Basisbelastingvermindering writable, ::ancestor.BasisTaxReduction
Cancelled char Cancelled writable, ::ancestor.Cancelled
City varchar2 City writable, ::ancestor.City
Comments varchar2 Comments writable, ::ancestor.Comments
ContributionPercent double Bijdragepercentage writable, ::ancestor.ContributionPercent
ContributionValue double Bijdragewaarde writable, ::ancestor.ContributionValue
CopyRemarks char Kopie Opmerkingen writable, ::ancestor.CopyRemarks
CostCenter varchar2 Kostenplaats writable, ::ancestor.CostCenter
Country varchar2 Country writable, ::ancestor.Country
Currency varchar2(3) Currency writable, ::ancestor.Currency
CurrencyRate double Valuta Classificatie writable, ::ancestor.CurrencyRate
CurrencyUnit double Valuta-eenheid writable, ::ancestor.CurrencyUnit
CustomerName varchar2 Naam Klant writable, ::ancestor.CustomerName
CustomerNumber varchar2 Klantnummer writable, ::ancestor.CustomerNumber
DeliveryAddress1 varchar2 Afleveradres 1 writable, ::ancestor.DeliveryAddress1
DeliveryAddress2 varchar2 Afleveradres 2 writable, ::ancestor.DeliveryAddress2
DeliveryCity varchar2 Afleverstad writable, ::ancestor.DeliveryCity
DeliveryCountry varchar2 Leveringsland writable, ::ancestor.DeliveryCountry
DeliveryDate datetime Leveringsdatum writable, ::ancestor.DeliveryDate
DeliveryName varchar2 Naam van de afzender writable, ::ancestor.DeliveryName
DeliveryState varchar2 Verzendstatus writable, ::ancestor.DeliveryState
DeliveryZipCode varchar2 Postcode voor levering writable, ::ancestor.DeliveryZipCode
DocumentNumber varchar2 Documentnummer writable, ::ancestor.DocumentNumber
EmailInformation_EmailAddressBCC varchar2 E-mailgegevens E-mailadres Bcc writable, ::ancestor.EmailInformation.EmailAddressBCC
EmailInformation_EmailAddressCC varchar2 E-mailgegevens CC-e-mail writable, ::ancestor.EmailInformation.EmailAddressCC
EmailInformation_EmailAddressFrom varchar2 E-mailgegevens E-mailadres Van writable, ::ancestor.EmailInformation.EmailAddressFrom
EmailInformation_EmailAddressTo varchar2 E-mailgegevens E-mailadres Aan writable, ::ancestor.EmailInformation.EmailAddressTo
EmailInformation_EmailBody varchar2 E-mailgegevens E-mailtekst writable, ::ancestor.EmailInformation.EmailBody
EmailInformation_EmailSubject varchar2 E-mailgegevens Onderwerp van de e-mail writable, ::ancestor.EmailInformation.EmailSubject
ExternalInvoiceReference1 varchar2 Externe factuurnummer 1 writable, ::ancestor.ExternalInvoiceReference1
ExternalInvoiceReference2 varchar2 Externe factuurnummer 2 writable, ::ancestor.ExternalInvoiceReference2
Freight double Freight writable, ::ancestor.Freight
FreightVAT double BTW op vrachtvervoer writable, ::ancestor.FreightVAT
Gross double Gross writable, ::ancestor.Gross
HouseWork char Huishoudelijk werk writable, ::ancestor.HouseWork
Id int32 ID writable, Id
InvoiceReference varchar2 Factuur Referentie writable, ::ancestor.InvoiceReference
Language varchar2 Language writable, ::ancestor.Language
Net double Net writable, ::ancestor.Net
NotCompleted char Notcompleted writable, ::ancestor.NotCompleted
OfferReference varchar2 Verwijzing van de aanbieding writable, ::ancestor.OfferReference
OrderDate datetime Besteldatum writable, ::ancestor.OrderDate
OrderType varchar2 Ordersoort writable, ::ancestor.OrderType
OrganisationNumber varchar2 Organisatienummer writable, ::ancestor.OrganisationNumber
OurReference varchar2(50) Ourreference writable, ::ancestor.OurReference
OutboundDate datetime Verzenddatum writable, ::ancestor.OutboundDate
Phone1 varchar2 Telefoon 1 writable, ::ancestor.Phone1
Phone2 varchar2 Telefoon 2 writable, ::ancestor.Phone2
PriceList varchar2 Prijslijst writable, ::ancestor.PriceList
PrintTemplate varchar2 Afdruksjabloon writable, ::ancestor.PrintTemplate
Project varchar2 Project writable, ::ancestor.Project
Remarks varchar2(1024) Remarks writable, ::ancestor.Remarks
RoundOff double Afronden writable, ::ancestor.RoundOff
Sent char Sent writable, ::ancestor.Sent
StockPointCode varchar2 Voorraadpuntcode writable, ::ancestor.StockPointCode
StockPointId varchar2 Voorraadpunt-ID writable, ::ancestor.StockPointId
TaxReduction double Belastingvermindering writable, ::ancestor.TaxReduction
TaxReductionType varchar2 Soort belastingvermindering writable, ::ancestor.TaxReductionType
TermsOfDelivery varchar2 Leveringsvoorwaarden writable, ::ancestor.TermsOfDelivery
TermsOfPayment varchar2 Betalingsvoorwaarden writable, ::ancestor.TermsOfPayment
TimeBasisReference int32 Tijdbasisverwijzing writable, ::ancestor.TimeBasisReference
Total double Total writable, ::ancestor.Total
TotalToPay double Totaal te betalen bedrag writable, ::ancestor.TotalToPay
TotalVAT double Totaal BTW writable, ::ancestor.TotalVAT
VATIncluded char Vatincluded writable, ::ancestor.VATIncluded
WarehouseReady char Klaar voor opslag writable, ::ancestor.WarehouseReady
WayOfDelivery varchar2 Wijze van levering writable, ::ancestor.WayOfDelivery
YourOrderNumber varchar2(75) Uw bestelnummer writable, ::ancestor.YourOrderNumber
YourReference varchar2(50) Uw Referentie writable, ::ancestor.YourReference
ZipCode varchar2 Postcode writable, ::ancestor.ZipCode
c_url varchar2 Aanroep-URL writable, ::ancestor.@url
c_urlTaxReductionList varchar2 Lijst met belastingverminderingen voor URL’s writable, ::ancestor.@urlTaxReductionList

Release Notes

Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: