invantive documentation
Invantive SupportforenAnmelden / Eintragen

OrderLabelsByDocumentNumber: Fortnox Order Labels by Document Number

read only REST

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

Retrieve a single order

Es können nur Daten abgerufen werden.

API-Quelle

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

Tabellenspalten

Die Spalten der Tabelle OrderLabelsByDocumentNumber 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 Adresszeile 1 writable, ::ancestor.Address1
Address2 varchar2 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 City writable, ::ancestor.City
Comments varchar2 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(3) Currency writable, ::ancestor.Currency
CurrencyRate double Währung writable, ::ancestor.CurrencyRate
CurrencyUnit double Währungseinheit writable, ::ancestor.CurrencyUnit
CustomerName varchar2 Name des Kunden writable, ::ancestor.CustomerName
CustomerNumber varchar2 Kundennummer writable, ::ancestor.CustomerNumber
DeliveryAddress1 varchar2 Lieferadresse 1 writable, ::ancestor.DeliveryAddress1
DeliveryAddress2 varchar2 Lieferadresse 2 writable, ::ancestor.DeliveryAddress2
DeliveryCity varchar2 Stadt der Lieferung writable, ::ancestor.DeliveryCity
DeliveryCountry varchar2 Land der Lieferung writable, ::ancestor.DeliveryCountry
DeliveryDate datetime Liefertermin writable, ::ancestor.DeliveryDate
DeliveryName varchar2 Name des Lieferanten writable, ::ancestor.DeliveryName
DeliveryState varchar2 Lieferzustand writable, ::ancestor.DeliveryState
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 E-Mail-Informationen E-Mail-Text writable, ::ancestor.EmailInformation.EmailBody
EmailInformation_EmailSubject varchar2 E-Mail-Informationen E-Mail-Betreff writable, ::ancestor.EmailInformation.EmailSubject
ExternalInvoiceReference1 varchar2 Externe Geschäftszeichen / Bezug 1 writable, ::ancestor.ExternalInvoiceReference1
ExternalInvoiceReference2 varchar2 Externe Geschäftszeichen / Bezug 2 writable, ::ancestor.ExternalInvoiceReference2
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
OfferReference varchar2 Angebotsgeschäftszeichen / Bezug writable, ::ancestor.OfferReference
OrderDate datetime Orderdatum writable, ::ancestor.OrderDate
OrderType varchar2 Auftragsart writable, ::ancestor.OrderType
OrganisationNumber varchar2 Organisationsnummer writable, ::ancestor.OrganisationNumber
OurReference varchar2(50) Ourreference writable, ::ancestor.OurReference
OutboundDate datetime Versanddatum writable, ::ancestor.OutboundDate
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(1024) Remarks writable, ::ancestor.Remarks
RoundOff double Abrunden writable, ::ancestor.RoundOff
Sent char Sent writable, ::ancestor.Sent
StockPointCode varchar2 Lager-Artikelnummer writable, ::ancestor.StockPointCode
StockPointId varchar2 Lagerort-ID writable, ::ancestor.StockPointId
TaxReduction double 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
TimeBasisReference int32 Zeitliche Bezugsgrundlage writable, ::ancestor.TimeBasisReference
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
WarehouseReady char Auf Lager writable, ::ancestor.WarehouseReady
WayOfDelivery varchar2 Versandart writable, ::ancestor.WayOfDelivery
YourOrderNumber varchar2(75) Ihre Bestellnummer writable, ::ancestor.YourOrderNumber
YourReference varchar2(50) Ihre Referenz writable, ::ancestor.YourReference
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: