invantive documentation
Invantive SupportforenAnmelden / Eintragen

CustomerByNumber: Fortnox Customer by Number

read only REST

  • Katalog: Fortnox
  • Schema: Customers
  • Label: Customer by Number

Retrieve a customer You need to supply the unique customer number that was returned when the customer was created or retrieved from the list of customers.

Es können nur Daten abgerufen werden.

Zusammenfassung

You need to supply the unique customer number that was returned when the customer was created or retrieved from the list of customers.

API-Quelle

  • Endpunkt: /3/customers/{CustomerNumber}
  • Operation: get /3/customers/{CustomerNumber}

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
CustomerNumber `` identifies the customer
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 CustomerByNumber 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
Customer_Active char Kunde aktiv filters on the platform, writable, Customer.Active
Customer_Address1 varchar2(1024) Kundenadresse 1 filters on the platform, writable, Customer.Address1
Customer_Address2 varchar2(1024) Kundenadresse 2 filters on the platform, writable, Customer.Address2
Customer_City varchar2(1024) Ort des Kunden filters on the platform, writable, Customer.City
Customer_Comments varchar2(1024) Kundenkommentare filters on the platform, writable, Customer.Comments
Customer_CostCenter varchar2 Kundenkostenstelle filters on the platform, writable, Customer.CostCenter
Customer_Country varchar2 Land des Kunden filters on the platform, writable, Customer.Country
Customer_CountryCode varchar2(2) Ländercode des Kunden filters on the platform, writable, Customer.CountryCode
Customer_Currency varchar2(3) Kundenwährung filters on the platform, writable, Customer.Currency
Customer_CustomerNumber varchar2(1024) Kundennummer filters on the platform, writable, Customer.CustomerNumber
Customer_DefaultDeliveryTypes_Invoice varchar2 Kunden-Standardlieferarten – Rechnung filters on the platform, writable, Customer.DefaultDeliveryTypes.Invoice
Customer_DefaultDeliveryTypes_Offer varchar2 Angebot zu den Standardlieferarten für Kunden filters on the platform, writable, Customer.DefaultDeliveryTypes.Offer
Customer_DefaultDeliveryTypes_Order varchar2 Kunden-Standardlieferarten Bestellung filters on the platform, writable, Customer.DefaultDeliveryTypes.Order
Customer_DefaultTemplates_CashInvoice varchar2 Kunden-Schablonen für Barrechnungen filters on the platform, writable, Customer.DefaultTemplates.CashInvoice
Customer_DefaultTemplates_Invoice varchar2 Kunden-Standard-Schablonen für Rechnungen filters on the platform, writable, Customer.DefaultTemplates.Invoice
Customer_DefaultTemplates_Offer varchar2 Angebot für kundenspezifische Schablonen filters on the platform, writable, Customer.DefaultTemplates.Offer
Customer_DefaultTemplates_Order varchar2 Kunden-Standard-Schablonen – Bestellung filters on the platform, writable, Customer.DefaultTemplates.Order
Customer_DeliveryAddress1 varchar2(1024) Lieferadresse des Kunden 1 filters on the platform, writable, Customer.DeliveryAddress1
Customer_DeliveryAddress2 varchar2(1024) Lieferadresse des Kunden 2 filters on the platform, writable, Customer.DeliveryAddress2
Customer_DeliveryCity varchar2(1024) Lieferort des Kunden filters on the platform, writable, Customer.DeliveryCity
Customer_DeliveryCountry varchar2(1024) Lieferland des Kunden filters on the platform, writable, Customer.DeliveryCountry
Customer_DeliveryCountryCode varchar2(2) Ländercode für die Lieferung an den Kunden filters on the platform, writable, Customer.DeliveryCountryCode
Customer_DeliveryFax varchar2(1024) Fax zur Kundenlieferung filters on the platform, writable, Customer.DeliveryFax
Customer_DeliveryName varchar2(1024) Name des Empfängers filters on the platform, writable, Customer.DeliveryName
Customer_DeliveryPhone1 varchar2(1024) Kundenlieferung Telefon 1 filters on the platform, writable, Customer.DeliveryPhone1
Customer_DeliveryPhone2 varchar2(1024) Kundenlieferung Telefon 2 filters on the platform, writable, Customer.DeliveryPhone2
Customer_DeliveryZipCode varchar2(10) Postleitzahl des Empfängers filters on the platform, writable, Customer.DeliveryZipCode
Customer_Email varchar2(1024) E-Mail-Adresse des Kunden filters on the platform, writable, Customer.Email
Customer_EmailInvoice varchar2(1024) Rechnung per E-Mail an den Kunden filters on the platform, writable, Customer.EmailInvoice
Customer_EmailInvoiceBCC varchar2(1024) Kunden-E-Mail-Rechnung (Bcc) filters on the platform, writable, Customer.EmailInvoiceBCC
Customer_EmailInvoiceCC varchar2(1024) Kunde E-Mail-Rechnung CC filters on the platform, writable, Customer.EmailInvoiceCC
Customer_EmailOffer varchar2(1024) E-Mail-Angebot für Kunden filters on the platform, writable, Customer.EmailOffer
Customer_EmailOfferBCC varchar2(1024) Kunden-E-Mail-Angebot (Bcc) filters on the platform, writable, Customer.EmailOfferBCC
Customer_EmailOfferCC varchar2(1024) Kunden-E-Mail-Angebot CC filters on the platform, writable, Customer.EmailOfferCC
Customer_EmailOrder varchar2(1024) Kundenbestellung per E-Mail filters on the platform, writable, Customer.EmailOrder
Customer_EmailOrderBCC varchar2(1024) E-Mail-Bestellung des Kunden (Bcc) filters on the platform, writable, Customer.EmailOrderBCC
Customer_EmailOrderCC varchar2(1024) Kunden-E-Mail-Bestellung (Kopie) filters on the platform, writable, Customer.EmailOrderCC
Customer_ExternalReference varchar2(1024) Externe Geschäftszeichen / Bezüge filters on the platform, writable, Customer.ExternalReference
Customer_Fax varchar2(1024) Kundenfax filters on the platform, writable, Customer.Fax
Customer_GLN varchar2(13) Kunden-Gln filters on the platform, writable, Customer.GLN
Customer_GLNDelivery varchar2(13) Kunden-GLN-Lieferung filters on the platform, writable, Customer.GLNDelivery
Customer_InvoiceAdministrationFee varchar2 Verwaltungsgebühr für Kundenrechnungen filters on the platform, writable, Customer.InvoiceAdministrationFee
Customer_InvoiceDiscount double Skonto auf Kundenrechnungen filters on the platform, writable, Customer.InvoiceDiscount
Customer_InvoiceFreight varchar2 Kundenrechnung Fracht filters on the platform, writable, Customer.InvoiceFreight
Customer_InvoiceRemark varchar2(1024) Vermerk auf der Kundenrechnung filters on the platform, writable, Customer.InvoiceRemark
Customer_Name varchar2(1024) Name des Kunden filters on the platform, writable, Customer.Name
Customer_OrganisationNumber varchar2 Kundenorganisationsnummer filters on the platform, writable, Customer.OrganisationNumber
Customer_OurReference varchar2(50) Kunde Unsere Referenz filters on the platform, writable, Customer.OurReference
Customer_Phone1 varchar2(1024) Kundennummer 1 filters on the platform, writable, Customer.Phone1
Customer_Phone2 varchar2(1024) Kundennummer 2 filters on the platform, writable, Customer.Phone2
Customer_PriceList varchar2 Kundenpreisliste filters on the platform, writable, Customer.PriceList
Customer_Project varchar2 Kundenprojekt filters on the platform, writable, Customer.Project
Customer_SalesAccount varchar2(4) Kunden-Vertriebskonto filters on the platform, writable, Customer.SalesAccount
Customer_ShowPriceVATIncluded char Customer Show Price Vatincluded filters on the platform, writable, Customer.ShowPriceVATIncluded
Customer_TermsOfDelivery varchar2 Lieferbedingungen für Kunden filters on the platform, writable, Customer.TermsOfDelivery
Customer_TermsOfPayment varchar2 Zahlungsbedingungen für Kunden filters on the platform, writable, Customer.TermsOfPayment
Customer_Type varchar2 Kundentyp filters on the platform, writable, Customer.Type
Customer_VATNumber varchar2 Umsatzsteuer-Identifikationsnummer des Kunden filters on the platform, writable, Customer.VATNumber
Customer_VATType varchar2 USt.-Typ des Kunden filters on the platform, writable, Customer.VATType
Customer_VisitingAddress varchar2(128) Besuchsadresse des Kunden filters on the platform, writable, Customer.VisitingAddress
Customer_VisitingCity varchar2(128) Ort, den der Kunde besucht filters on the platform, writable, Customer.VisitingCity
Customer_VisitingCountry varchar2(128) Land, das der Kunde besucht filters on the platform, writable, Customer.VisitingCountry
Customer_VisitingCountryCode varchar2(2) Ländercode des Kundenbesuchs filters on the platform, writable, Customer.VisitingCountryCode
Customer_VisitingZipCode varchar2(10) Postleitzahl des Kundenbesuchs filters on the platform, writable, Customer.VisitingZipCode
Customer_WWW varchar2(128) Kunde Www filters on the platform, writable, Customer.WWW
Customer_WayOfDelivery varchar2 Lieferart des Kunden filters on the platform, writable, Customer.WayOfDelivery
Customer_YourReference varchar2(50) Kunde Ihr Geschäftszeichen / Bezug filters on the platform, writable, Customer.YourReference
Customer_ZipCode varchar2(10) Postleitzahl des Kunden filters on the platform, writable, Customer.ZipCode
Customer__url varchar2 Kunden-URL filters on the platform, writable, Customer.@url

Anmerkungen zu dieser Version

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