CustomerByNumber: Fortnox Customer by Number
read only REST
- Catalogo:
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.
È possibile solo recuperare i dati.
Riepilogo
You need to supply the unique customer number that was returned when the customer was created or retrieved from the list of customers.
Codice sorgente dell'API
- Punto finale:
/3/customers/{CustomerNumber} - Operazione:
get /3/customers/{CustomerNumber}
Caratteristiche prestazionali
| Characteristic | Value |
|---|---|
| Latenza media di accesso (ms) | 356 |
| Righe di scansione completa al minuto | 85,000 |
| Numero di righe di Query al minuto | 168 |
Il risultato può essere memorizzato nella memoria cache sul client.
Parametri
| Name | Tipo di dati | 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). |
Colonne della tabella
Di seguito sono riportate le colonne della tabella CustomerByNumber. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.
| Name | Tipo di dati | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
Customer_ |
char |
Cliente attivo | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Indirizzo del cliente 1 | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Indirizzo del cliente 2 | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Città del cliente | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Commenti dei clienti | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Centro di costo cliente | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Paese del cliente | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Codice paese del cliente | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Valuta del cliente | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Numero cliente | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Tipi di consegna predefiniti per cliente - Fattura | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Tipi di consegna predefiniti per i clienti - Offerta | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Tipi di consegna predefiniti per i clienti - Ordine | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Modelli predefiniti per i clienti - Fattura di incasso | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Modelli predefiniti di fattura per i clienti | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Offerta di modelli predefiniti per i clienti | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Ordine dei modelli predefiniti per i clienti | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Indirizzo di consegna del cliente 1 | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Indirizzo di consegna del cliente 2 | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Città di consegna del cliente | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Paese di consegna del cliente | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Codice paese di destinazione della spedizione al cliente | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Fax di consegna al cliente | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Nome del destinatario della consegna | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Numero di telefono per le consegne ai clienti 1 | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Numero di telefono per le consegne ai clienti 2 | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Codice postale di consegna del cliente | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
E-mail del cliente | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Fattura inviata via e-mail al cliente | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
E-mail del cliente - Fattura - Cc nascosto | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
E-mail del cliente in copia per conoscenza (CC) sulla fattura | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Offerta via e-mail per i clienti | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Offerta via e-mail al cliente (Bcc) | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Offerta via e-mail al cliente CC | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Ordine via e-mail del cliente | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
E-mail del cliente - Ordine - Cc nascosto | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
E-mail del cliente - Ordine - CC | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Riferimento esterno del cliente | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Fax del cliente | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Codice cliente Gln | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Consegna Gln al cliente | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Commissione amministrativa per le fatture dei clienti | filters on the platform, writable, Customer. |
||
Customer_ |
double |
Sconto sulla fattura del cliente | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Fattura cliente - Spese di trasporto | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Nota sulla fattura del cliente | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Nome del cliente | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Numero di identificazione dell'organizzazione del cliente | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Cliente: Ourreference | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Numero di telefono del cliente 1 | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Numero di telefono del cliente 2 | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Listino prezzi per i clienti | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Progetto del cliente | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Account clienti | filters on the platform, writable, Customer. |
||
Customer_ |
char |
Prezzo per il cliente, IVA inclusa | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Condizioni di consegna per i clienti | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Condizioni di pagamento per i clienti | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Tipo di cliente | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Partita IVA del cliente | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Tipo di IVA del cliente | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Indirizzo per le visite dei clienti | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Città visitata dal cliente | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Paese di visita del cliente | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Codice paese di provenienza del cliente | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Codice postale del cliente in visita | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Cliente Www | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Modalità di consegna scelta dal cliente | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Cliente - Riferimento del cliente | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Codice postale del cliente | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
URL del cliente | filters on the platform, writable, Customer. |
Note di rilascio
Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: