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 |
|---|---|---|---|---|
Customer |
`` | 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_ |
char |
Kunde aktiv | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Kundenadresse 1 | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Kundenadresse 2 | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Ort des Kunden | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Kundenkommentare | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Kundenkostenstelle | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Land des Kunden | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Ländercode des Kunden | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Kundenwährung | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Kundennummer | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Kunden-Standardlieferarten – Rechnung | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Angebot zu den Standardlieferarten für Kunden | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Kunden-Standardlieferarten Bestellung | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Kunden-Schablonen für Barrechnungen | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Kunden-Standard-Schablonen für Rechnungen | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Angebot für kundenspezifische Schablonen | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Kunden-Standard-Schablonen – Bestellung | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Lieferadresse des Kunden 1 | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Lieferadresse des Kunden 2 | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Lieferort des Kunden | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Lieferland des Kunden | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Ländercode für die Lieferung an den Kunden | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Fax zur Kundenlieferung | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Name des Empfängers | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Kundenlieferung Telefon 1 | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Kundenlieferung Telefon 2 | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Postleitzahl des Empfängers | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
E-Mail-Adresse des Kunden | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Rechnung per E-Mail an den Kunden | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Kunden-E-Mail-Rechnung (Bcc) | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Kunde E-Mail-Rechnung CC | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
E-Mail-Angebot für Kunden | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Kunden-E-Mail-Angebot (Bcc) | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Kunden-E-Mail-Angebot CC | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Kundenbestellung per E-Mail | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
E-Mail-Bestellung des Kunden (Bcc) | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Kunden-E-Mail-Bestellung (Kopie) | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Externe Geschäftszeichen / Bezüge | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Kundenfax | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Kunden-Gln | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Kunden-GLN-Lieferung | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Verwaltungsgebühr für Kundenrechnungen | filters on the platform, writable, Customer. |
||
Customer_ |
double |
Skonto auf Kundenrechnungen | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Kundenrechnung Fracht | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Vermerk auf der Kundenrechnung | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Name des Kunden | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Kundenorganisationsnummer | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Kunde Unsere Referenz | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Kundennummer 1 | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Kundennummer 2 | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Kundenpreisliste | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Kundenprojekt | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Kunden-Vertriebskonto | filters on the platform, writable, Customer. |
||
Customer_ |
char |
Customer Show Price Vatincluded | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Lieferbedingungen für Kunden | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Zahlungsbedingungen für Kunden | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Kundentyp | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Umsatzsteuer-Identifikationsnummer des Kunden | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
USt.-Typ des Kunden | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Besuchsadresse des Kunden | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Ort, den der Kunde besucht | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Land, das der Kunde besucht | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Ländercode des Kundenbesuchs | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Postleitzahl des Kundenbesuchs | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Kunde Www | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Lieferart des Kunden | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Kunde Ihr Geschäftszeichen / Bezug | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Postleitzahl des Kunden | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Kunden-URL | filters on the platform, writable, Customer. |
Anmerkungen zu dieser Version
Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: