AccountsFullTextSearch: Exact Online Accounts Full-Text Search
read only per partition REST
- Catalogo:
ExactOnlineREST - Schema:
CRM - Chiavi primarie:
ID - Label: Accounts Full-Text Search
Search for legal counter parties using a text query.
I dati in questa tabella sono partizionati per valore della colonna Division.
È possibile solo recuperare i dati.
Codice sorgente dell'API
- Punto finale:
/api/v1/{division}/read/crm/AccountsFullTextSearch - Metadati:
/api/v1/{division}/read/crm/$metadata
Caratteristiche prestazionali
| Characteristic | Value |
|---|---|
| Latenza media di accesso (ms) | 5 |
| Righe di scansione completa al minuto | 7,200 |
| Numero di righe di Query al minuto | 300 |
| Scrittura di righe al minuto | 300 |
Il risultato può essere memorizzato nella memoria cache sul client.
Parametri
| Name | Tipo di dati | Required | Default | Documentation |
|---|---|---|---|---|
division |
int32 |
ID of the division to retrieve data for. | ||
search |
varchar2 |
Colonne della tabella
Di seguito sono riportate le colonne della tabella AccountsFullTextSearch. 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 |
|---|---|---|---|---|---|
Account |
guid |
Account Manager | filters on the platform, writable | ||
Account |
varchar2 |
Nome e cognome del responsabile clienti | filters on the platform, writable | ||
Account |
int32 |
Gestore dell'account HID | filters on the platform, writable | ||
Accountant |
guid |
Accountant | filters on the platform, writable | ||
Activity |
guid |
Settore di attività | filters on the platform, writable | ||
Activity |
guid |
Sottosettore di attività | filters on the platform, writable | ||
Address |
varchar2 |
Indirizzo 1 | filters on the platform, writable | Visit address first line. | |
Address |
varchar2 |
Indirizzo 2 | filters on the platform, writable | Second address line. | |
Address |
varchar2 |
Indirizzo 3 | filters on the platform, writable | Third address line. | |
Address |
int16 |
Fonte dell'indirizzo | filters on the platform, writable | ||
Automatic |
int16 |
Inserimento automatico proposto dal processo | filtri sulla piattaforma | ||
BRIN |
guid |
BRIN | filters on the platform, writable | ||
BSN |
varchar2 |
Numero della sicurezza sociale | filters on the platform, writable | Citizen Service Number for the Netherlands. | |
Blocked |
char |
Blocked | filters on the platform, writable | ||
Business |
guid |
Tipo di affare | filters on the platform, writable | ||
Can |
char |
È possibile effettuare la spedizione diretta | filters on the platform, writable | ||
Chamber |
varchar2 |
Camera di Commercio | filters on the platform, writable | Chamber of commerce number. | |
City |
varchar2 |
City | filters on the platform, writable | City. | |
Classification |
varchar2 |
Classification | filters on the platform, writable | ||
Classification1 |
guid |
Classificazione 1 | filters on the platform, writable | ||
Classification2 |
guid |
Classificazione 2 | filters on the platform, writable | ||
Classification3 |
guid |
Classificazione 3 | filters on the platform, writable | ||
Classification4 |
guid |
Classificazione 4 | filters on the platform, writable | ||
Classification5 |
guid |
Classificazione 5 | filters on the platform, writable | ||
Classification6 |
guid |
Classificazione 6 | filters on the platform, writable | ||
Classification7 |
guid |
Classificazione 7 | filters on the platform, writable | ||
Classification8 |
guid |
Classificazione 8 | filters on the platform, writable | ||
Classification |
varchar2 |
Descrizione della classificazione | filters on the platform, writable | ||
Code |
varchar2 |
Code | filters on the platform, writable | ||
Code |
varchar2 |
Codice presso il fornitore | filters on the platform, writable | Code under which your own company is known at the account. | |
Company |
guid |
Dimensioni dell'impresa | filters on the platform, writable | ||
Consolidation |
int16 |
Scenario di consolidamento | filters on the platform, writable | ||
Controlled |
datetime |
Data di verifica | filters on the platform, writable | ||
Cost |
int16 |
Costo pagato | filters on the platform, writable | ||
Costcenter |
varchar2 |
Centro di costo | filters on the platform, writable | ||
Costcenter |
varchar2 |
Descrizione del centro di costo | filters on the platform, writable | ||
Country |
varchar2 |
Country | filters on the platform, writable | Country code. | |
Country |
varchar2 |
Nome del paese | filters on the platform, writable | Country name. | |
Created |
datetime |
Created | filters on the platform, writable | Creation date. | |
Created |
datetime |
Creato | writable | Creation date in UTC. | |
Creator |
guid |
Creator | filters on the platform, writable | User ID of creator. | |
Creator |
varchar2 |
Nome completo del creatore | filters on the platform, writable | Name of creator. | |
Credit |
double |
Linea di credito per acquisti | filters on the platform, writable | ||
Credit |
double |
Linea di credito per le vendite | filters on the platform, writable | ||
Currency |
varchar2 |
Currency | filters on the platform, writable | Code of Currency. | |
Custom |
varchar2 |
Campo personalizzato | filters on the platform, writable | ||
Customer |
datetime |
Cliente dal | filters on the platform, writable | ||
Datev |
varchar2 |
Codice creditore DATEV | filters on the platform, writable | ||
Datev |
varchar2 |
Codice debitore DATEV | filters on the platform, writable | ||
Delivery |
int16 |
Informazioni sulla consegna | filtri sulla piattaforma | ||
Discount |
double |
Sconto sull'acquisto | filters on the platform, writable | ||
Discount |
double |
Sconto sulle vendite | filters on the platform, writable | ||
Division |
int32 |
Division | writable | ||
Division |
varchar2 |
Numero di iscrizione alla Camera di Commercio della Divisione | writable | Chamber of commerce number of the Exact Online division. | |
Division |
varchar2 |
Codice IBAN della divisione | writable | IBAN number of the Exact Online division. | |
Division |
varchar2 |
Divisione - Nome dell'azienda | writable | Company name of the Exact Online division. | |
Division |
varchar2 |
Numero di divisione RSIN | writable | RSIN number of the Exact Online division. | |
Division |
varchar2 |
Partita IVA della divisione | writable | VAT number of the Exact Online division. | |
Division |
varchar2 |
Codice fiscale salariale della divisione | writable | Wage tax number of the Exact Online division. | |
Division |
varchar2 |
Etichetta della divisione | writable | Label of the Exact Online division. | |
Division |
varchar2 |
Nome dell'amministrazione | writable | Name of the Exact Online division. | |
Division |
varchar2 |
Nome del titolare dell'abbonamento | writable | Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
varchar2 |
Numero di abbonato | writable | Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
int64 |
Nome abbreviato della divisione | writable | Short name of the Exact Online division. | |
Document |
guid |
Document | filters on the platform, writable | ||
Duns |
varchar2 |
Numero DUNS | filters on the platform, writable | ||
EORI |
varchar2 |
Numero EORI | writable | EORI number (United Kingdom). | |
Email |
varchar2 |
filters on the platform, writable | |||
Enable |
char |
Abilita il link di pagamento per le vendite | filtri sulla piattaforma | ||
End |
datetime |
Data di fine | filters on the platform, writable | ||
Established |
datetime |
Data di fondazione | filters on the platform, writable | ||
Fax |
varchar2 |
Fax | filters on the platform, writable | Fax number. | |
GLAP |
guid |
Contabilità fornitori - Contabilità generale | filters on the platform, writable | ||
GLAR |
guid |
Contabilità clienti - Contabilità generale | filters on the platform, writable | ||
GL |
guid |
Conto GL per l'acquisto | filters on the platform, writable | ||
GL |
guid |
Conto GL delle vendite | filters on the platform, writable | ||
Gln |
varchar2 |
Numero GLN | filters on the platform, writable | Global Location Number can be used by companies to identify their locations, giving them complete flexibility to identify any type or level of location required. | |
Has |
char |
Vendite soggette a ritenuta alla fonte | filters on the platform, writable | ||
ID |
guid |
ID | filters on the platform, writable | ||
Ignore |
char |
Ignora il messaggio di avviso DATEV | filters on the platform, writable | ||
Incoterm |
varchar2 |
Acquisto di indirizzi Incoterm | filters on the platform, writable | ||
Incoterm |
varchar2 |
Incoterm: Indirizzo di vendita | filters on the platform, writable | ||
Incoterm |
varchar2 |
Acquisto del codice Incoterm | filters on the platform, writable | ||
Incoterm |
varchar2 |
Codici Incoterms per le vendite | filters on the platform, writable | ||
Incoterm |
int16 |
Acquisto della versione Incoterm | filters on the platform, writable | ||
Incoterm |
int16 |
Vendite con versione Incoterm | filters on the platform, writable | ||
Intra |
varchar2 |
Area Intrastat | filters on the platform, writable | ||
Intra |
varchar2 |
Termine di consegna Intrastat | filters on the platform, writable | ||
Intra |
varchar2 |
Sistema Intrastat | filters on the platform, writable | ||
Intra |
varchar2 |
Transazione Intrastat A | filters on the platform, writable | ||
Intra |
varchar2 |
Operazione Intrastat B | filters on the platform, writable | ||
Intra |
varchar2 |
Metodo di trasporto Intrastat | filters on the platform, writable | ||
Invoice |
guid |
Account di fatturazione | filters on the platform, writable | ||
Invoice |
varchar2 |
Codice del conto della fattura | filters on the platform, writable | ||
Invoice |
varchar2 |
Nome dell'account di fatturazione | filters on the platform, writable | Name of account. | |
Invoice |
int32 |
Tipo di allegato alla fattura | filters on the platform, writable | ||
Invoicing |
int32 |
Modalità di fatturazione | filters on the platform, writable | ||
Is |
int16 |
È un contabile | filters on the platform, writable | ||
Is |
int16 |
È un'agenzia | filters on the platform, writable | ||
Is |
int16 |
È anonimizzato | filters on the platform, writable | Indicates whether the account is anonymised. | |
IsBank |
char |
È una banca | filters on the platform, writable | ||
Is |
int16 |
È un concorrente | filters on the platform, writable | ||
Is |
char |
È un servizio straordinario | filters on the platform, writable | ||
Is |
int16 |
È una spedizione postale | filters on the platform, writable | ||
Is |
char |
È membro | filters on the platform, writable | ||
Is |
char |
È Pilot | filters on the platform, writable | ||
Is |
char |
È un acquisto | filters on the platform, writable | ||
Is |
char |
È un rivenditore | filters on the platform, writable | ||
Is |
char |
È il reparto vendite | filters on the platform, writable | ||
Is |
char |
È un fornitore | filters on the platform, writable | ||
Language |
varchar2 |
Language | filters on the platform, writable | Codice lingua. | |
Language |
varchar2 |
Descrizione della lingua | filters on the platform, writable | Language description. | |
Latitude |
double |
Latitude | filters on the platform, writable | ||
Lead |
guid |
Obiettivo principale | filters on the platform, writable | Reference to Lead Purpose of an account. | |
Lead |
guid |
Database di origine del cliente potenziale | filters on the platform, writable | ||
Logo |
blob |
Logo | filters on the platform, writable | ||
Logo |
varchar2 |
Nome del file del logo | filters on the platform, writable | ||
Logo |
varchar2 |
Miniatura del logo (URL) | writable | ||
Logo |
varchar2 |
Logo (URL) | filters on the platform, writable | ||
Longitude |
double |
Longitude | filters on the platform, writable | ||
Main |
guid |
Contatto principale | filters on the platform, writable | ||
Modified |
datetime |
Modified | filters on the platform, writable | Last modified date. | |
Modified |
datetime |
Modificato (UTC) | writable | Last modified date in UTC. | |
Modifier |
guid |
Modifier | filters on the platform, writable | User ID of modifier. | |
Modifier |
varchar2 |
Nome completo modificato | filters on the platform, writable | Name of modifier. | |
Name |
varchar2 |
Name | filters on the platform, writable | Name of account. | |
OIN |
varchar2 |
Numero OIN | filters on the platform, writable | Dutch government identification number. | |
Parent |
guid |
Parent | filters on the platform, writable | ||
Pay |
varchar2 |
Pay-as-you-Earn | filters on the platform, writable | ||
Payment |
varchar2 |
Condizioni di pagamento Acquisto | filters on the platform, writable | ||
Payment |
varchar2 |
Condizioni di pagamento Descrizione dell'acquisto | filters on the platform, writable | ||
Payment |
varchar2 |
Condizioni di pagamento Vendite | filters on the platform, writable | ||
Payment |
varchar2 |
Condizioni di pagamento Descrizione delle vendite | filters on the platform, writable | ||
Peppol |
varchar2 |
Identificatore Peppol | filtri sulla piattaforma | ||
Peppol |
int32 |
Tipo di identificatore Peppol | filtri sulla piattaforma | ||
Phone |
varchar2 |
Phone | filters on the platform, writable | Numero di telefono. | |
Phone |
varchar2 |
Estensione del telefono | filters on the platform, writable | Phone number extension. | |
Postcode |
varchar2 |
Codice postale | filters on the platform, writable | Postcode. | |
Price |
guid |
Listino prezzi | filters on the platform, writable | ||
Purchase |
varchar2 |
Valuta di acquisto | filters on the platform, writable | Currency of purchase. | |
Purchase |
varchar2 |
Valuta di acquisto Descrizione | filters on the platform, writable | Description of purchase currency. | |
Purchase |
int32 |
Giorni di acquisizione dei clienti potenziali | filters on the platform, writable | ||
Purchase |
varchar2 |
Codice IVA per l'acquisto | filters on the platform, writable | Purchase VAT code. | |
Purchase |
varchar2 |
Codice IVA di acquisto Descrizione | filters on the platform, writable | Description of Purchase VAT code. | |
RSIN |
varchar2 |
Numero RSIN | filters on the platform, writable | Fiscal number for NL legislation. | |
Recepient |
char |
Destinatario delle commissioni | filters on the platform, writable | ||
Remarks |
varchar2 |
Remarks | filters on the platform, writable | ||
Reseller |
guid |
Reseller | filters on the platform, writable | ||
Reseller |
varchar2 |
Codice rivenditore | filters on the platform, writable | Code of Reseller. | |
Reseller |
varchar2 |
Nome del rivenditore | filters on the platform, writable | Name of reseller. | |
Sales |
varchar2 |
Valuta di vendita | filters on the platform, writable | Currency of sales price. | |
Sales |
varchar2 |
Valuta di vendita Descrizione | filters on the platform, writable | Description of sales currency. | |
Sales |
guid |
Tabella delle imposte sulle vendite | filters on the platform, writable | ||
Sales |
varchar2 |
Codice tariffario dell'imposta sulle vendite | filters on the platform, writable | ||
Sales |
varchar2 |
Descrizione della tabella delle imposte sulle vendite | filters on the platform, writable | ||
Sales |
varchar2 |
Codice IVA di vendita | filters on the platform, writable | Sales VAT code. | |
Sales |
varchar2 |
Codice IVA vendite Descrizione | filters on the platform, writable | Description of Sales VAT code. | |
Search |
varchar2 |
Codice di ricerca | filters on the platform, writable | Search code. | |
Security |
int32 |
Livello di sicurezza | filters on the platform, writable | ||
Separate |
int16 |
Fattura separata per progetto | filters on the platform, writable | ||
Separate |
int16 |
Fattura separata per ogni abbonamento | filters on the platform, writable | ||
Shipping |
int32 |
Tempi di consegna stimati | filters on the platform, writable | ||
Shipping |
guid |
Metodo di spedizione | filters on the platform, writable | ||
Show |
char |
Mostra commento per le vendite | filters on the platform, writable | ||
Source |
int16 |
Source | filtri sulla piattaforma | ||
Start |
datetime |
Data di inizio | filters on the platform, writable | ||
State |
varchar2 |
State | filters on the platform, writable | State/Province code. | |
State |
varchar2 |
Stato | filters on the platform, writable | Name of state/province. | |
Status |
varchar2 |
Status | filters on the platform, writable | If the status field is filled this means the account is a customer.The value indicates the customer status.Possible values: A=None, S=Suspect, P=Prospect, C=Customer. | |
Status |
datetime |
Stato dal | filters on the platform, writable | ||
Trade |
varchar2 |
Tradename | filters on the platform, writable | ||
Type |
varchar2 |
Type | filters on the platform, writable | Account type: Values: A = Relation, D = Division. | |
Unique |
varchar2 |
Riferimento unico del contribuente | filters on the platform, writable | ||
VAT |
varchar2 |
Responsabilità IVA | filters on the platform, writable | ||
VAT |
varchar2 |
Numero di partita IVA | filters on the platform, writable | VAT number. | |
Website |
varchar2 |
Website | filters on the platform, writable | Website of the account. |
Note di rilascio
Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: