invantive documentation
Invantive Support ForumsLog In / Sign Up

OrderByDocumentNumber: Fortnox Order by Document Number

read only REST

  • Catalog: Fortnox
  • Schema: Orders
  • Label: Order by Document Number

Retrieve a single order

Can only retrieve data.

API Source

  • Endpoint: /3/orders/{DocumentNumber}
  • Operation: get /3/orders/{DocumentNumber}

Performance Characteristics

Characteristic Value
Average access latency (ms) 356
Full scan rows per minute 85,000
Point query rows per minute 168

The result can be cached on the client.

Parameters

Name Data Type 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).

Table Columns

The columns of the table OrderByDocumentNumber are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
Order_Address1 varchar2 Order Address 1 filters on the platform, writable, Order.Address1
Order_Address2 varchar2 Order Address 2 filters on the platform, writable, Order.Address2
Order_AdministrationFee double Order Administration Fee filters on the platform, writable, Order.AdministrationFee
Order_AdministrationFeeVAT double Order Administration Fee VAT filters on the platform, writable, Order.AdministrationFeeVAT
Order_BasisTaxReduction double Order Basis Tax Reduction filters on the platform, writable, Order.BasisTaxReduction
Order_Cancelled char Order Cancelled filters on the platform, writable, Order.Cancelled
Order_City varchar2 Order City filters on the platform, writable, Order.City
Order_Comments varchar2 Order Comments filters on the platform, writable, Order.Comments
Order_ContributionPercent double Order Contribution Percent filters on the platform, writable, Order.ContributionPercent
Order_ContributionValue double Order Contribution Value filters on the platform, writable, Order.ContributionValue
Order_CopyRemarks char Order Copy Remarks filters on the platform, writable, Order.CopyRemarks
Order_CostCenter varchar2 Order Cost Centre filters on the platform, writable, Order.CostCenter
Order_Country varchar2 Order Country filters on the platform, writable, Order.Country
Order_Currency varchar2(3) Order Currency filters on the platform, writable, Order.Currency
Order_CurrencyRate double Order Currency Rate filters on the platform, writable, Order.CurrencyRate
Order_CurrencyUnit double Order Currency Unit filters on the platform, writable, Order.CurrencyUnit
Order_CustomerName varchar2 Order Customer Name filters on the platform, writable, Order.CustomerName
Order_CustomerNumber varchar2 Order Customernumber filters on the platform, writable, Order.CustomerNumber
Order_DeliveryAddress1 varchar2 Order Delivery Address 1 filters on the platform, writable, Order.DeliveryAddress1
Order_DeliveryAddress2 varchar2 Order Delivery Address 2 filters on the platform, writable, Order.DeliveryAddress2
Order_DeliveryCity varchar2 Order Delivery City filters on the platform, writable, Order.DeliveryCity
Order_DeliveryCountry varchar2 Order Delivery Country filters on the platform, writable, Order.DeliveryCountry
Order_DeliveryDate datetime Order Delivery Date filters on the platform, writable, Order.DeliveryDate
Order_DeliveryName varchar2 Order Delivery Name filters on the platform, writable, Order.DeliveryName
Order_DeliveryState varchar2 Order Delivery State filters on the platform, writable, Order.DeliveryState
Order_DeliveryZipCode varchar2 Order Delivery Zip Code filters on the platform, writable, Order.DeliveryZipCode
Order_DocumentNumber varchar2 Order Document Number filters on the platform, writable, Order.DocumentNumber
Order_EmailInformation_EmailAddressBCC varchar2 Order Email Information Email Address Bcc filters on the platform, writable, Order.EmailInformation.EmailAddressBCC
Order_EmailInformation_EmailAddressCC varchar2 Order Email Information Email Address CC filters on the platform, writable, Order.EmailInformation.EmailAddressCC
Order_EmailInformation_EmailAddressFrom varchar2 Order Email Information Email Address From filters on the platform, writable, Order.EmailInformation.EmailAddressFrom
Order_EmailInformation_EmailAddressTo varchar2 Order Email Information Email Address To filters on the platform, writable, Order.EmailInformation.EmailAddressTo
Order_EmailInformation_EmailBody varchar2 Order Email Information Email Body filters on the platform, writable, Order.EmailInformation.EmailBody
Order_EmailInformation_EmailSubject varchar2 Order Email Information Email Subject filters on the platform, writable, Order.EmailInformation.EmailSubject
Order_ExternalInvoiceReference1 varchar2 Order External Invoice Reference 1 filters on the platform, writable, Order.ExternalInvoiceReference1
Order_ExternalInvoiceReference2 varchar2 Order External Invoice Reference 2 filters on the platform, writable, Order.ExternalInvoiceReference2
Order_Freight double Order Freight filters on the platform, writable, Order.Freight
Order_FreightVAT double Order Freight VAT filters on the platform, writable, Order.FreightVAT
Order_Gross double Order Gross filters on the platform, writable, Order.Gross
Order_HouseWork char Order House Work filters on the platform, writable, Order.HouseWork
Order_InvoiceReference varchar2 Order Invoice Reference filters on the platform, writable, Order.InvoiceReference
Order_Language varchar2 Order Language filters on the platform, writable, Order.Language
Order_Net double Order Net filters on the platform, writable, Order.Net
Order_NotCompleted char Order Notcompleted filters on the platform, writable, Order.NotCompleted
Order_OfferReference varchar2 Order Offer Reference filters on the platform, writable, Order.OfferReference
Order_OrderDate datetime Order Date filters on the platform, writable, Order.OrderDate
Order_OrderType varchar2 Order Type filters on the platform, writable, Order.OrderType
Order_OrganisationNumber varchar2 Order Organisation Number filters on the platform, writable, Order.OrganisationNumber
Order_OurReference varchar2(50) Order Ourreference filters on the platform, writable, Order.OurReference
Order_OutboundDate datetime Order Outbound Date filters on the platform, writable, Order.OutboundDate
Order_Phone1 varchar2 Order Phone 1 filters on the platform, writable, Order.Phone1
Order_Phone2 varchar2 Order Phone 2 filters on the platform, writable, Order.Phone2
Order_PriceList varchar2 Order Pricelist filters on the platform, writable, Order.PriceList
Order_PrintTemplate varchar2 Order Print Template filters on the platform, writable, Order.PrintTemplate
Order_Project varchar2 Order Project filters on the platform, writable, Order.Project
Order_Remarks varchar2(1024) Order Remarks filters on the platform, writable, Order.Remarks
Order_RoundOff double Order Round Off filters on the platform, writable, Order.RoundOff
Order_Sent char Order Sent filters on the platform, writable, Order.Sent
Order_StockPointCode varchar2 Order Stock Point Code filters on the platform, writable, Order.StockPointCode
Order_StockPointId varchar2 Order Stock Point ID filters on the platform, writable, Order.StockPointId
Order_TaxReduction double Order Tax Reduction filters on the platform, writable, Order.TaxReduction
Order_TaxReductionType varchar2 Order Tax Reduction Type filters on the platform, writable, Order.TaxReductionType
Order_TermsOfDelivery varchar2 Order Terms of Delivery filters on the platform, writable, Order.TermsOfDelivery
Order_TermsOfPayment varchar2 Order Terms of Payment filters on the platform, writable, Order.TermsOfPayment
Order_TimeBasisReference int32 Order Time Basis Reference filters on the platform, writable, Order.TimeBasisReference
Order_Total double Order Total filters on the platform, writable, Order.Total
Order_TotalToPay double Order Total to Pay filters on the platform, writable, Order.TotalToPay
Order_TotalVAT double Order Total VAT filters on the platform, writable, Order.TotalVAT
Order_VATIncluded char Order Vatincluded filters on the platform, writable, Order.VATIncluded
Order_WarehouseReady char Order Warehouse Ready filters on the platform, writable, Order.WarehouseReady
Order_WayOfDelivery varchar2 Order Way of Delivery filters on the platform, writable, Order.WayOfDelivery
Order_YourOrderNumber varchar2(75) Order Your Order Number filters on the platform, writable, Order.YourOrderNumber
Order_YourReference varchar2(50) Order Your Reference filters on the platform, writable, Order.YourReference
Order_ZipCode varchar2 Order Zip Code filters on the platform, writable, Order.ZipCode
Order__url varchar2 Order URL filters on the platform, writable, Order.@url
Order__urlTaxReductionList varchar2 Order URL Tax Reduction List filters on the platform, writable, Order.@urlTaxReductionList

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: