invantive documentation
Invantive SupportforenAnmelden / Eintragen

OfferByDocumentNumber: Fortnox Offer by Document Number

read only REST

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

Retrieve a single offer

Es können nur Daten abgerufen werden.

API-Quelle

  • Endpunkt: /3/offers/{DocumentNumber}
  • Operation: get /3/offers/{DocumentNumber}

Leistungsmerkmale

Characteristic Value
Durchschnittliche Zugriffsverzögerung (ms) 356
Anzahl der Vollscan-Zeilen pro Minute 85,000
Anzahl der Query-Zeilen pro Minute 168

Das Ergebnis kann auf dem Client im Cache zwischengespeichert werden.

Parameter

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

Tabellenspalten

Die Spalten der Tabelle OfferByDocumentNumber sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.

Name Datentyp Label Required Marks Documentation
Offer_Address1 varchar2(1024) Angebotsadresse 1 filters on the platform, writable, Offer.Address1
Offer_Address2 varchar2(1024) Angebotsadresse 2 filters on the platform, writable, Offer.Address2
Offer_AdministrationFee double Verwaltungsgebühr für das Angebot filters on the platform, writable, Offer.AdministrationFee
Offer_AdministrationFeeVAT double Offer Administration Fee VAT filters on the platform, writable, Offer.AdministrationFeeVAT
Offer_BasisTaxReduction double Steuerermäßigung auf der Grundlage des Angebots filters on the platform, writable, Offer.BasisTaxReduction
Offer_Cancelled char Angebot storniert filters on the platform, writable, Offer.Cancelled
Offer_City varchar2(1024) Angebotsort filters on the platform, writable, Offer.City
Offer_Comments varchar2(1024) Kommentare zum Angebot filters on the platform, writable, Offer.Comments
Offer_ContributionPercent double Angebotsprozentsatz filters on the platform, writable, Offer.ContributionPercent
Offer_ContributionValue double Wert des Angebotsbeitrags filters on the platform, writable, Offer.ContributionValue
Offer_CopyRemarks char Anzeigentext – Anmerkungen filters on the platform, writable, Offer.CopyRemarks
Offer_CostCenter varchar2 Kostenstelle für Angebote filters on the platform, writable, Offer.CostCenter
Offer_Country varchar2 Angebotsland filters on the platform, writable, Offer.Country
Offer_Currency varchar2 Währung des Angebots filters on the platform, writable, Offer.Currency
Offer_CurrencyRate double Angebotswechselkurs für die Währung filters on the platform, writable, Offer.CurrencyRate
Offer_CurrencyUnit int32 Angebotswährungseinheit filters on the platform, writable, Offer.CurrencyUnit
Offer_CustomerName varchar2 Angebot – Name des Kunden filters on the platform, writable, Offer.CustomerName
Offer_CustomerNumber varchar2 Kundennummer angeben filters on the platform, writable, Offer.CustomerNumber
Offer_DeliveryAddress1 varchar2(1024) Lieferadresse 1 für das Angebot filters on the platform, writable, Offer.DeliveryAddress1
Offer_DeliveryAddress2 varchar2(1024) Lieferadresse 2 für das Angebot filters on the platform, writable, Offer.DeliveryAddress2
Offer_DeliveryCity varchar2(1024) Ort des Angebots filters on the platform, writable, Offer.DeliveryCity
Offer_DeliveryCountry varchar2 Lieferland des Angebots filters on the platform, writable, Offer.DeliveryCountry
Offer_DeliveryDate datetime Liefertermin des Angebots filters on the platform, writable, Offer.DeliveryDate
Offer_DeliveryName varchar2(1024) Name der Angebotszustellung filters on the platform, writable, Offer.DeliveryName
Offer_DeliveryZipCode varchar2 Postleitzahl für die Zustellung des Angebots filters on the platform, writable, Offer.DeliveryZipCode
Offer_DocumentNumber varchar2 Nummer des Angebotsdokuments filters on the platform, writable, Offer.DocumentNumber
Offer_EmailInformation_EmailAddressBCC varchar2 Angebot E-Mail-Informationen E-Mail-Adresse Bcc filters on the platform, writable, Offer.EmailInformation.EmailAddressBCC
Offer_EmailInformation_EmailAddressCC varchar2 Angebot E-Mail-Informationen E-Mail-Adresse CC filters on the platform, writable, Offer.EmailInformation.EmailAddressCC
Offer_EmailInformation_EmailAddressFrom varchar2 Angebot E-Mail-Informationen E-Mail-Adresse Absender filters on the platform, writable, Offer.EmailInformation.EmailAddressFrom
Offer_EmailInformation_EmailAddressTo varchar2 Angebot E-Mail-Informationen E-Mail-Adresse an filters on the platform, writable, Offer.EmailInformation.EmailAddressTo
Offer_EmailInformation_EmailBody varchar2(20000) Informationen zum Angebot E-Mail-Text filters on the platform, writable, Offer.EmailInformation.EmailBody
Offer_EmailInformation_EmailSubject varchar2(100) Informationen zum Angebot per E-Mail Betreff der E-Mail filters on the platform, writable, Offer.EmailInformation.EmailSubject
Offer_ExpireDate datetime Ablaufdatum des Angebots filters on the platform, writable, Offer.ExpireDate
Offer_Freight double Frachtangebot filters on the platform, writable, Offer.Freight
Offer_FreightVAT double Offer Freight VAT filters on the platform, writable, Offer.FreightVAT
Offer_Gross double Angebotsbrutto filters on the platform, writable, Offer.Gross
Offer_HouseWork char Hausarbeit anbieten filters on the platform, writable, Offer.HouseWork
Offer_InvoiceReference varchar2 Angebotsgeschäftszeichen / Bezug filters on the platform, writable, Offer.InvoiceReference
Offer_Language varchar2 Sprache des Angebots filters on the platform, writable, Offer.Language
Offer_Net double Angebotsnetto filters on the platform, writable, Offer.Net
Offer_NotCompleted char Angebot noch nicht abgeschlossen filters on the platform, writable, Offer.NotCompleted
Offer_OfferDate datetime Angebotsdatum filters on the platform, writable, Offer.OfferDate
Offer_OrderReference varchar2 Angebots- und Auftragsgeschäftszeichen filters on the platform, writable, Offer.OrderReference
Offer_OrganisationNumber varchar2 Angebotsnummer der Organisation filters on the platform, writable, Offer.OrganisationNumber
Offer_OurReference varchar2 Angebot von Ourreference filters on the platform, writable, Offer.OurReference
Offer_Phone1 varchar2 Angebot Telefon 1 filters on the platform, writable, Offer.Phone1
Offer_Phone2 varchar2 Angebot Telefon 2 filters on the platform, writable, Offer.Phone2
Offer_PriceList varchar2 Angebots-Preisliste filters on the platform, writable, Offer.PriceList
Offer_PrintTemplate varchar2 Angebotsschablone drucken filters on the platform, writable, Offer.PrintTemplate
Offer_Project varchar2 Projektangebot filters on the platform, writable, Offer.Project
Offer_Remarks varchar2 Anmerkungen zum Angebot filters on the platform, writable, Offer.Remarks
Offer_RoundOff double Angebot abrunden filters on the platform, writable, Offer.RoundOff
Offer_Sent char Angebot gesendet filters on the platform, writable, Offer.Sent
Offer_TaxReduction int32 Steuererleichterung anbieten filters on the platform, writable, Offer.TaxReduction
Offer_TaxReductionType varchar2 Art der Steuerermäßigung filters on the platform, writable, Offer.TaxReductionType
Offer_TermsOfDelivery varchar2 Lieferbedingungen des Angebots filters on the platform, writable, Offer.TermsOfDelivery
Offer_TermsOfPayment varchar2 Zahlungsbedingungen des Angebots filters on the platform, writable, Offer.TermsOfPayment
Offer_Total double Gesamtbetrag des Angebots filters on the platform, writable, Offer.Total
Offer_TotalToPay double Gesamtbetrag des Angebots filters on the platform, writable, Offer.TotalToPay
Offer_TotalVAT double Offer Total VAT filters on the platform, writable, Offer.TotalVAT
Offer_VATIncluded char Angebot inklusive Mehrwertsteuer filters on the platform, writable, Offer.VATIncluded
Offer_WayOfDelivery varchar2 Angebot – Versandart filters on the platform, writable, Offer.WayOfDelivery
Offer_YourReference varchar2 Geben Sie Ihr Geschäftszeichen / Bezug an filters on the platform, writable, Offer.YourReference
Offer_YourReferenceNumber varchar2 Geben Sie Ihre Referenznummer an filters on the platform, writable, Offer.YourReferenceNumber
Offer_ZipCode varchar2 Angebot Postleitzahl filters on the platform, writable, Offer.ZipCode
Offer__url varchar2 Angebots-URL filters on the platform, writable, Offer.@url
Offer__urlTaxReductionList varchar2 Liste der Steuererleichterungen für Angebots-URLs filters on the platform, writable, Offer.@urlTaxReductionList

Anmerkungen zu dieser Version

Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: