invantive documentation
Forum di supporto InvantiveAccedi / Registrati

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.

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
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).

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_Active char Cliente attivo filters on the platform, writable, Customer.Active
Customer_Address1 varchar2(1024) Indirizzo del cliente 1 filters on the platform, writable, Customer.Address1
Customer_Address2 varchar2(1024) Indirizzo del cliente 2 filters on the platform, writable, Customer.Address2
Customer_City varchar2(1024) Città del cliente filters on the platform, writable, Customer.City
Customer_Comments varchar2(1024) Commenti dei clienti filters on the platform, writable, Customer.Comments
Customer_CostCenter varchar2 Centro di costo cliente filters on the platform, writable, Customer.CostCenter
Customer_Country varchar2 Paese del cliente filters on the platform, writable, Customer.Country
Customer_CountryCode varchar2(2) Codice paese del cliente filters on the platform, writable, Customer.CountryCode
Customer_Currency varchar2(3) Valuta del cliente filters on the platform, writable, Customer.Currency
Customer_CustomerNumber varchar2(1024) Numero cliente filters on the platform, writable, Customer.CustomerNumber
Customer_DefaultDeliveryTypes_Invoice varchar2 Tipi di consegna predefiniti per cliente - Fattura filters on the platform, writable, Customer.DefaultDeliveryTypes.Invoice
Customer_DefaultDeliveryTypes_Offer varchar2 Tipi di consegna predefiniti per i clienti - Offerta filters on the platform, writable, Customer.DefaultDeliveryTypes.Offer
Customer_DefaultDeliveryTypes_Order varchar2 Tipi di consegna predefiniti per i clienti - Ordine filters on the platform, writable, Customer.DefaultDeliveryTypes.Order
Customer_DefaultTemplates_CashInvoice varchar2 Modelli predefiniti per i clienti - Fattura di incasso filters on the platform, writable, Customer.DefaultTemplates.CashInvoice
Customer_DefaultTemplates_Invoice varchar2 Modelli predefiniti di fattura per i clienti filters on the platform, writable, Customer.DefaultTemplates.Invoice
Customer_DefaultTemplates_Offer varchar2 Offerta di modelli predefiniti per i clienti filters on the platform, writable, Customer.DefaultTemplates.Offer
Customer_DefaultTemplates_Order varchar2 Ordine dei modelli predefiniti per i clienti filters on the platform, writable, Customer.DefaultTemplates.Order
Customer_DeliveryAddress1 varchar2(1024) Indirizzo di consegna del cliente 1 filters on the platform, writable, Customer.DeliveryAddress1
Customer_DeliveryAddress2 varchar2(1024) Indirizzo di consegna del cliente 2 filters on the platform, writable, Customer.DeliveryAddress2
Customer_DeliveryCity varchar2(1024) Città di consegna del cliente filters on the platform, writable, Customer.DeliveryCity
Customer_DeliveryCountry varchar2(1024) Paese di consegna del cliente filters on the platform, writable, Customer.DeliveryCountry
Customer_DeliveryCountryCode varchar2(2) Codice paese di destinazione della spedizione al cliente filters on the platform, writable, Customer.DeliveryCountryCode
Customer_DeliveryFax varchar2(1024) Fax di consegna al cliente filters on the platform, writable, Customer.DeliveryFax
Customer_DeliveryName varchar2(1024) Nome del destinatario della consegna filters on the platform, writable, Customer.DeliveryName
Customer_DeliveryPhone1 varchar2(1024) Numero di telefono per le consegne ai clienti 1 filters on the platform, writable, Customer.DeliveryPhone1
Customer_DeliveryPhone2 varchar2(1024) Numero di telefono per le consegne ai clienti 2 filters on the platform, writable, Customer.DeliveryPhone2
Customer_DeliveryZipCode varchar2(10) Codice postale di consegna del cliente filters on the platform, writable, Customer.DeliveryZipCode
Customer_Email varchar2(1024) E-mail del cliente filters on the platform, writable, Customer.Email
Customer_EmailInvoice varchar2(1024) Fattura inviata via e-mail al cliente filters on the platform, writable, Customer.EmailInvoice
Customer_EmailInvoiceBCC varchar2(1024) E-mail del cliente - Fattura - Cc nascosto filters on the platform, writable, Customer.EmailInvoiceBCC
Customer_EmailInvoiceCC varchar2(1024) E-mail del cliente in copia per conoscenza (CC) sulla fattura filters on the platform, writable, Customer.EmailInvoiceCC
Customer_EmailOffer varchar2(1024) Offerta via e-mail per i clienti filters on the platform, writable, Customer.EmailOffer
Customer_EmailOfferBCC varchar2(1024) Offerta via e-mail al cliente (Bcc) filters on the platform, writable, Customer.EmailOfferBCC
Customer_EmailOfferCC varchar2(1024) Offerta via e-mail al cliente CC filters on the platform, writable, Customer.EmailOfferCC
Customer_EmailOrder varchar2(1024) Ordine via e-mail del cliente filters on the platform, writable, Customer.EmailOrder
Customer_EmailOrderBCC varchar2(1024) E-mail del cliente - Ordine - Cc nascosto filters on the platform, writable, Customer.EmailOrderBCC
Customer_EmailOrderCC varchar2(1024) E-mail del cliente - Ordine - CC filters on the platform, writable, Customer.EmailOrderCC
Customer_ExternalReference varchar2(1024) Riferimento esterno del cliente filters on the platform, writable, Customer.ExternalReference
Customer_Fax varchar2(1024) Fax del cliente filters on the platform, writable, Customer.Fax
Customer_GLN varchar2(13) Codice cliente Gln filters on the platform, writable, Customer.GLN
Customer_GLNDelivery varchar2(13) Consegna Gln al cliente filters on the platform, writable, Customer.GLNDelivery
Customer_InvoiceAdministrationFee varchar2 Commissione amministrativa per le fatture dei clienti filters on the platform, writable, Customer.InvoiceAdministrationFee
Customer_InvoiceDiscount double Sconto sulla fattura del cliente filters on the platform, writable, Customer.InvoiceDiscount
Customer_InvoiceFreight varchar2 Fattura cliente - Spese di trasporto filters on the platform, writable, Customer.InvoiceFreight
Customer_InvoiceRemark varchar2(1024) Nota sulla fattura del cliente filters on the platform, writable, Customer.InvoiceRemark
Customer_Name varchar2(1024) Nome del cliente filters on the platform, writable, Customer.Name
Customer_OrganisationNumber varchar2 Numero di identificazione dell'organizzazione del cliente filters on the platform, writable, Customer.OrganisationNumber
Customer_OurReference varchar2(50) Cliente: Ourreference filters on the platform, writable, Customer.OurReference
Customer_Phone1 varchar2(1024) Numero di telefono del cliente 1 filters on the platform, writable, Customer.Phone1
Customer_Phone2 varchar2(1024) Numero di telefono del cliente 2 filters on the platform, writable, Customer.Phone2
Customer_PriceList varchar2 Listino prezzi per i clienti filters on the platform, writable, Customer.PriceList
Customer_Project varchar2 Progetto del cliente filters on the platform, writable, Customer.Project
Customer_SalesAccount varchar2(4) Account clienti filters on the platform, writable, Customer.SalesAccount
Customer_ShowPriceVATIncluded char Prezzo per il cliente, IVA inclusa filters on the platform, writable, Customer.ShowPriceVATIncluded
Customer_TermsOfDelivery varchar2 Condizioni di consegna per i clienti filters on the platform, writable, Customer.TermsOfDelivery
Customer_TermsOfPayment varchar2 Condizioni di pagamento per i clienti filters on the platform, writable, Customer.TermsOfPayment
Customer_Type varchar2 Tipo di cliente filters on the platform, writable, Customer.Type
Customer_VATNumber varchar2 Partita IVA del cliente filters on the platform, writable, Customer.VATNumber
Customer_VATType varchar2 Tipo di IVA del cliente filters on the platform, writable, Customer.VATType
Customer_VisitingAddress varchar2(128) Indirizzo per le visite dei clienti filters on the platform, writable, Customer.VisitingAddress
Customer_VisitingCity varchar2(128) Città visitata dal cliente filters on the platform, writable, Customer.VisitingCity
Customer_VisitingCountry varchar2(128) Paese di visita del cliente filters on the platform, writable, Customer.VisitingCountry
Customer_VisitingCountryCode varchar2(2) Codice paese di provenienza del cliente filters on the platform, writable, Customer.VisitingCountryCode
Customer_VisitingZipCode varchar2(10) Codice postale del cliente in visita filters on the platform, writable, Customer.VisitingZipCode
Customer_WWW varchar2(128) Cliente Www filters on the platform, writable, Customer.WWW
Customer_WayOfDelivery varchar2 Modalità di consegna scelta dal cliente filters on the platform, writable, Customer.WayOfDelivery
Customer_YourReference varchar2(50) Cliente - Riferimento del cliente filters on the platform, writable, Customer.YourReference
Customer_ZipCode varchar2(10) Codice postale del cliente filters on the platform, writable, Customer.ZipCode
Customer__url varchar2 URL del cliente filters on the platform, writable, Customer.@url

Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: