invantive documentation
Invantive SupportforenAnmelden / Eintragen

OfferLabelsByDocumentNumber: Fortnox Offer Labels by Document Number

read only REST

  • Katalog: Fortnox
  • Schema: Offers
  • Label: Offer Labels 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 OfferLabelsByDocumentNumber 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
Address1 varchar2(1024) Adresszeile 1 writable, ::ancestor.Address1
Address2 varchar2(1024) Adresszeile 2 writable, ::ancestor.Address2
AdministrationFee double Verwaltungsgebühr writable, ::ancestor.AdministrationFee
AdministrationFeeVAT double Administration Fee VAT writable, ::ancestor.AdministrationFeeVAT
BasisTaxReduction double Steuerermäßigung auf der Bemessungsgrundlage writable, ::ancestor.BasisTaxReduction
Cancelled char Cancelled writable, ::ancestor.Cancelled
City varchar2(1024) City writable, ::ancestor.City
Comments varchar2(1024) Comments writable, ::ancestor.Comments
ContributionPercent double Beitragsprozentsatz writable, ::ancestor.ContributionPercent
ContributionValue double Beitragswert writable, ::ancestor.ContributionValue
CopyRemarks char Bemerkungen kopieren writable, ::ancestor.CopyRemarks
CostCenter varchar2 Kostenstelle writable, ::ancestor.CostCenter
Country varchar2 Country writable, ::ancestor.Country
Currency varchar2 Currency writable, ::ancestor.Currency
CurrencyRate double Währung writable, ::ancestor.CurrencyRate
CurrencyUnit int32 Währungseinheit writable, ::ancestor.CurrencyUnit
CustomerName varchar2 Name des Kunden writable, ::ancestor.CustomerName
CustomerNumber varchar2 Kundennummer writable, ::ancestor.CustomerNumber
DeliveryAddress1 varchar2(1024) Lieferadresse 1 writable, ::ancestor.DeliveryAddress1
DeliveryAddress2 varchar2(1024) Lieferadresse 2 writable, ::ancestor.DeliveryAddress2
DeliveryCity varchar2(1024) Stadt der Lieferung writable, ::ancestor.DeliveryCity
DeliveryCountry varchar2 Land der Lieferung writable, ::ancestor.DeliveryCountry
DeliveryDate datetime Liefertermin writable, ::ancestor.DeliveryDate
DeliveryName varchar2(1024) Name des Lieferanten writable, ::ancestor.DeliveryName
DeliveryZipCode varchar2 Postleitzahl für die Lieferung writable, ::ancestor.DeliveryZipCode
DocumentNumber varchar2 Dokumentnummer writable, ::ancestor.DocumentNumber
EmailInformation_EmailAddressBCC varchar2 E-Mail-Informationen E-Mail-Adresse Bcc writable, ::ancestor.EmailInformation.EmailAddressBCC
EmailInformation_EmailAddressCC varchar2 E-Mail-Informationen E-Mail-Adresse CC writable, ::ancestor.EmailInformation.EmailAddressCC
EmailInformation_EmailAddressFrom varchar2 E-Mail-Informationen Absender-E-Mail-Adresse writable, ::ancestor.EmailInformation.EmailAddressFrom
EmailInformation_EmailAddressTo varchar2 E-Mail-Informationen E-Mail-Adresse An writable, ::ancestor.EmailInformation.EmailAddressTo
EmailInformation_EmailBody varchar2(20000) E-Mail-Informationen E-Mail-Text writable, ::ancestor.EmailInformation.EmailBody
EmailInformation_EmailSubject varchar2(100) E-Mail-Informationen E-Mail-Betreff writable, ::ancestor.EmailInformation.EmailSubject
ExpireDate datetime Ablaufdatum writable, ::ancestor.ExpireDate
Freight double Freight writable, ::ancestor.Freight
FreightVAT double Mehrwertsteuer auf Frachtkosten writable, ::ancestor.FreightVAT
Gross double Gross writable, ::ancestor.Gross
HouseWork char Hausarbeit writable, ::ancestor.HouseWork
Id int32 ID writable, Id
InvoiceReference varchar2 Geschäftszeichen / Bezug writable, ::ancestor.InvoiceReference
Language varchar2 Language writable, ::ancestor.Language
Net double Net writable, ::ancestor.Net
NotCompleted char Notcompleted writable, ::ancestor.NotCompleted
OfferDate datetime Angebotsdatum writable, ::ancestor.OfferDate
OrderReference varchar2 Auftragsreferenz writable, ::ancestor.OrderReference
OrganisationNumber varchar2 Organisationsnummer writable, ::ancestor.OrganisationNumber
OurReference varchar2 Ourreference writable, ::ancestor.OurReference
Phone1 varchar2 Telefon 1 writable, ::ancestor.Phone1
Phone2 varchar2 Telefon 2 writable, ::ancestor.Phone2
PriceList varchar2 Preisliste writable, ::ancestor.PriceList
PrintTemplate varchar2 Druck-Schablone writable, ::ancestor.PrintTemplate
Project varchar2 Project writable, ::ancestor.Project
Remarks varchar2 Remarks writable, ::ancestor.Remarks
RoundOff double Abrunden writable, ::ancestor.RoundOff
Sent char Sent writable, ::ancestor.Sent
TaxReduction int32 Steuersenkung writable, ::ancestor.TaxReduction
TaxReductionType varchar2 Art der Steuerermäßigung writable, ::ancestor.TaxReductionType
TermsOfDelivery varchar2 Lieferbedingungen writable, ::ancestor.TermsOfDelivery
TermsOfPayment varchar2 Zahlungsbedingungen writable, ::ancestor.TermsOfPayment
Total double Total writable, ::ancestor.Total
TotalToPay double Zu zahlender Gesamtbetrag writable, ::ancestor.TotalToPay
TotalVAT double Total VAT writable, ::ancestor.TotalVAT
VATIncluded char Vatincluded writable, ::ancestor.VATIncluded
WayOfDelivery varchar2 Versandart writable, ::ancestor.WayOfDelivery
YourReference varchar2 Ihre Referenz writable, ::ancestor.YourReference
YourReferenceNumber varchar2 Ihre Referenznummer writable, ::ancestor.YourReferenceNumber
ZipCode varchar2 Postleitzahl writable, ::ancestor.ZipCode
c_url varchar2 URL aufrufen writable, ::ancestor.@url
c_urlTaxReductionList varchar2 Liste der URL-Steuerermäßigungen writable, ::ancestor.@urlTaxReductionList

Anmerkungen zu dieser Version

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