invantive documentation
Invantive Support ForumsLog In / Sign Up

OfferByDocumentNumber: Fortnox Offer by Document Number

read only REST

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

Retrieve a single offer

Can only retrieve data.

API Source

  • Endpoint: /3/offers/{DocumentNumber}
  • Operation: get /3/offers/{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 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).

Table Columns

The columns of the table OfferByDocumentNumber 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
Offer_Address1 varchar2(1024) Offer Address 1 filters on the platform, writable, Offer.Address1
Offer_Address2 varchar2(1024) Offer Address 2 filters on the platform, writable, Offer.Address2
Offer_AdministrationFee double Offer Administration Fee filters on the platform, writable, Offer.AdministrationFee
Offer_AdministrationFeeVAT double Offer Administration Fee VAT filters on the platform, writable, Offer.AdministrationFeeVAT
Offer_BasisTaxReduction double Offer Basis Tax Reduction filters on the platform, writable, Offer.BasisTaxReduction
Offer_Cancelled char Offer Cancelled filters on the platform, writable, Offer.Cancelled
Offer_City varchar2(1024) Offer City filters on the platform, writable, Offer.City
Offer_Comments varchar2(1024) Offer Comments filters on the platform, writable, Offer.Comments
Offer_ContributionPercent double Offer Contribution Percent filters on the platform, writable, Offer.ContributionPercent
Offer_ContributionValue double Offer Contribution Value filters on the platform, writable, Offer.ContributionValue
Offer_CopyRemarks char Offer Copy Remarks filters on the platform, writable, Offer.CopyRemarks
Offer_CostCenter varchar2 Offer Cost Centre filters on the platform, writable, Offer.CostCenter
Offer_Country varchar2 Offer Country filters on the platform, writable, Offer.Country
Offer_Currency varchar2 Offer Currency filters on the platform, writable, Offer.Currency
Offer_CurrencyRate double Offer Currency Rate filters on the platform, writable, Offer.CurrencyRate
Offer_CurrencyUnit int32 Offer Currency Unit filters on the platform, writable, Offer.CurrencyUnit
Offer_CustomerName varchar2 Offer Customer Name filters on the platform, writable, Offer.CustomerName
Offer_CustomerNumber varchar2 Offer Customernumber filters on the platform, writable, Offer.CustomerNumber
Offer_DeliveryAddress1 varchar2(1024) Offer Delivery Address 1 filters on the platform, writable, Offer.DeliveryAddress1
Offer_DeliveryAddress2 varchar2(1024) Offer Delivery Address 2 filters on the platform, writable, Offer.DeliveryAddress2
Offer_DeliveryCity varchar2(1024) Offer Delivery City filters on the platform, writable, Offer.DeliveryCity
Offer_DeliveryCountry varchar2 Offer Delivery Country filters on the platform, writable, Offer.DeliveryCountry
Offer_DeliveryDate datetime Offer Delivery Date filters on the platform, writable, Offer.DeliveryDate
Offer_DeliveryName varchar2(1024) Offer Delivery Name filters on the platform, writable, Offer.DeliveryName
Offer_DeliveryZipCode varchar2 Offer Delivery Zip Code filters on the platform, writable, Offer.DeliveryZipCode
Offer_DocumentNumber varchar2 Offer Document Number filters on the platform, writable, Offer.DocumentNumber
Offer_EmailInformation_EmailAddressBCC varchar2 Offer Email Information Email Address Bcc filters on the platform, writable, Offer.EmailInformation.EmailAddressBCC
Offer_EmailInformation_EmailAddressCC varchar2 Offer Email Information Email Address CC filters on the platform, writable, Offer.EmailInformation.EmailAddressCC
Offer_EmailInformation_EmailAddressFrom varchar2 Offer Email Information Email Address From filters on the platform, writable, Offer.EmailInformation.EmailAddressFrom
Offer_EmailInformation_EmailAddressTo varchar2 Offer Email Information Email Address To filters on the platform, writable, Offer.EmailInformation.EmailAddressTo
Offer_EmailInformation_EmailBody varchar2(20000) Offer Email Information Email Body filters on the platform, writable, Offer.EmailInformation.EmailBody
Offer_EmailInformation_EmailSubject varchar2(100) Offer Email Information Email Subject filters on the platform, writable, Offer.EmailInformation.EmailSubject
Offer_ExpireDate datetime Offer Expire Date filters on the platform, writable, Offer.ExpireDate
Offer_Freight double Offer Freight filters on the platform, writable, Offer.Freight
Offer_FreightVAT double Offer Freight VAT filters on the platform, writable, Offer.FreightVAT
Offer_Gross double Offer Gross filters on the platform, writable, Offer.Gross
Offer_HouseWork char Offer House Work filters on the platform, writable, Offer.HouseWork
Offer_InvoiceReference varchar2 Offer Invoice Reference filters on the platform, writable, Offer.InvoiceReference
Offer_Language varchar2 Offer Language filters on the platform, writable, Offer.Language
Offer_Net double Offer Net filters on the platform, writable, Offer.Net
Offer_NotCompleted char Offer Notcompleted filters on the platform, writable, Offer.NotCompleted
Offer_OfferDate datetime Offer Date filters on the platform, writable, Offer.OfferDate
Offer_OrderReference varchar2 Offer Order Reference filters on the platform, writable, Offer.OrderReference
Offer_OrganisationNumber varchar2 Offer Organisation Number filters on the platform, writable, Offer.OrganisationNumber
Offer_OurReference varchar2 Offer Ourreference filters on the platform, writable, Offer.OurReference
Offer_Phone1 varchar2 Offer Phone 1 filters on the platform, writable, Offer.Phone1
Offer_Phone2 varchar2 Offer Phone 2 filters on the platform, writable, Offer.Phone2
Offer_PriceList varchar2 Offer Pricelist filters on the platform, writable, Offer.PriceList
Offer_PrintTemplate varchar2 Offer Print Template filters on the platform, writable, Offer.PrintTemplate
Offer_Project varchar2 Offer Project filters on the platform, writable, Offer.Project
Offer_Remarks varchar2 Offer Remarks filters on the platform, writable, Offer.Remarks
Offer_RoundOff double Offer Round Off filters on the platform, writable, Offer.RoundOff
Offer_Sent char Offer Sent filters on the platform, writable, Offer.Sent
Offer_TaxReduction int32 Offer Tax Reduction filters on the platform, writable, Offer.TaxReduction
Offer_TaxReductionType varchar2 Offer Tax Reduction Type filters on the platform, writable, Offer.TaxReductionType
Offer_TermsOfDelivery varchar2 Offer Terms of Delivery filters on the platform, writable, Offer.TermsOfDelivery
Offer_TermsOfPayment varchar2 Offer Terms of Payment filters on the platform, writable, Offer.TermsOfPayment
Offer_Total double Offer Total filters on the platform, writable, Offer.Total
Offer_TotalToPay double Offer Total to Pay filters on the platform, writable, Offer.TotalToPay
Offer_TotalVAT double Offer Total VAT filters on the platform, writable, Offer.TotalVAT
Offer_VATIncluded char Offer Vatincluded filters on the platform, writable, Offer.VATIncluded
Offer_WayOfDelivery varchar2 Offer Way of Delivery filters on the platform, writable, Offer.WayOfDelivery
Offer_YourReference varchar2 Offer Your Reference filters on the platform, writable, Offer.YourReference
Offer_YourReferenceNumber varchar2 Offer Your Reference Number filters on the platform, writable, Offer.YourReferenceNumber
Offer_ZipCode varchar2 Offer Zip Code filters on the platform, writable, Offer.ZipCode
Offer__url varchar2 Offer URL filters on the platform, writable, Offer.@url
Offer__urlTaxReductionList varchar2 Offer URL Tax Reduction List filters on the platform, writable, Offer.@urlTaxReductionList

Release Notes

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