invantive documentation
Forum di supporto InvantiveAccedi / Registrati

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.
searchText 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
AccountManager guid Account Manager filters on the platform, writable
AccountManagerFullName varchar2(240) Nome e cognome del responsabile clienti filters on the platform, writable
AccountManagerHID int32 Gestore dell'account HID filters on the platform, writable
Accountant guid Accountant filters on the platform, writable
ActivitySector guid Settore di attività filters on the platform, writable
ActivitySubSector guid Sottosettore di attività filters on the platform, writable
AddressLine1 varchar2(80) Indirizzo 1 filters on the platform, writable Visit address first line.
AddressLine2 varchar2(80) Indirizzo 2 filters on the platform, writable Second address line.
AddressLine3 varchar2(80) Indirizzo 3 filters on the platform, writable Third address line.
AddressSource int16 Fonte dell'indirizzo filters on the platform, writable
AutomaticProcessProposedEntry 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
BusinessType guid Tipo di affare filters on the platform, writable
CanDropShip char È possibile effettuare la spedizione diretta filters on the platform, writable
ChamberOfCommerce varchar2(60) Camera di Commercio filters on the platform, writable Chamber of commerce number.
City varchar2(30) 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
ClassificationDescription varchar2 Descrizione della classificazione filters on the platform, writable
Code varchar2 Code filters on the platform, writable
CodeAtSupplier varchar2(20) Codice presso il fornitore filters on the platform, writable Code under which your own company is known at the account.
CompanySize guid Dimensioni dell'impresa filters on the platform, writable
ConsolidationScenario int16 Scenario di consolidamento filters on the platform, writable
ControlledDate datetime Data di verifica filters on the platform, writable
CostPaid int16 Costo pagato filters on the platform, writable
Costcenter varchar2(8) Centro di costo filters on the platform, writable
CostcenterDescription varchar2(60) Descrizione del centro di costo filters on the platform, writable
Country varchar2(30) Country filters on the platform, writable Country code.
CountryName varchar2 Nome del paese filters on the platform, writable Country name.
Created datetime Created filters on the platform, writable Creation date.
CreatedUtc datetime Creato writable Creation date in UTC.
Creator guid Creator filters on the platform, writable User ID of creator.
CreatorFullName varchar2(240) Nome completo del creatore filters on the platform, writable Name of creator.
CreditLinePurchase double Linea di credito per acquisti filters on the platform, writable
CreditLineSales double Linea di credito per le vendite filters on the platform, writable
Currency varchar2(30) Currency filters on the platform, writable Code of Currency.
CustomField varchar2 Campo personalizzato filters on the platform, writable
CustomerSince datetime Cliente dal filters on the platform, writable
DatevCreditorCode varchar2(30) Codice creditore DATEV filters on the platform, writable
DatevDebtorCode varchar2(30) Codice debitore DATEV filters on the platform, writable
DeliveryAdvice int16 Informazioni sulla consegna filtri sulla piattaforma
DiscountPurchase double Sconto sull'acquisto filters on the platform, writable
DiscountSales double Sconto sulle vendite filters on the platform, writable
Division int32 Division writable
DivisionCompanyCoCNumber varchar2(60) Numero di iscrizione alla Camera di Commercio della Divisione writable Chamber of commerce number of the Exact Online division.
DivisionCompanyIBANNumber varchar2(50) Codice IBAN della divisione writable IBAN number of the Exact Online division.
DivisionCompanyName varchar2(50) Divisione - Nome dell'azienda writable Company name of the Exact Online division.
DivisionCompanyRSINNumber varchar2(9) Numero di divisione RSIN writable RSIN number of the Exact Online division.
DivisionCompanyVATNumber varchar2(35) Partita IVA della divisione writable VAT number of the Exact Online division.
DivisionCompanyWageTaxNumber varchar2(60) Codice fiscale salariale della divisione writable Wage tax number of the Exact Online division.
DivisionLabel varchar2(128) Etichetta della divisione writable Label of the Exact Online division.
DivisionName varchar2(50) Nome dell'amministrazione writable Name of the Exact Online division.
DivisionOwnerCompanyName varchar2(50) Nome del titolare dell'abbonamento writable Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs.
DivisionOwnerCompanyNumber varchar2(18) Numero di abbonato writable Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs.
DivisionShortName int64 Nome abbreviato della divisione writable Short name of the Exact Online division.
Document guid Document filters on the platform, writable
DunsNumber varchar2(9) Numero DUNS filters on the platform, writable
EORINumber varchar2 Numero EORI writable EORI number (United Kingdom).
Email varchar2(128) Email filters on the platform, writable
EnableSalesPaymentLink char Abilita il link di pagamento per le vendite filtri sulla piattaforma
EndDate datetime Data di fine filters on the platform, writable
EstablishedDate datetime Data di fondazione filters on the platform, writable
Fax varchar2(25) 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
GLAccountPurchase guid Conto GL per l'acquisto filters on the platform, writable
GLAccountSales guid Conto GL delle vendite filters on the platform, writable
GlnNumber varchar2(13) 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.
HasWithholdingTaxSales char Vendite soggette a ritenuta alla fonte filters on the platform, writable
ID guid ID filters on the platform, writable
IgnoreDatevWarningMessage char Ignora il messaggio di avviso DATEV filters on the platform, writable
IncotermAddressPurchase varchar2 Acquisto di indirizzi Incoterm filters on the platform, writable
IncotermAddressSales varchar2 Incoterm: Indirizzo di vendita filters on the platform, writable
IncotermCodePurchase varchar2 Acquisto del codice Incoterm filters on the platform, writable
IncotermCodeSales varchar2 Codici Incoterms per le vendite filters on the platform, writable
IncotermVersionPurchase int16 Acquisto della versione Incoterm filters on the platform, writable
IncotermVersionSales int16 Vendite con versione Incoterm filters on the platform, writable
IntraStatArea varchar2 Area Intrastat filters on the platform, writable
IntraStatDeliveryTerm varchar2 Termine di consegna Intrastat filters on the platform, writable
IntraStatSystem varchar2(5) Sistema Intrastat filters on the platform, writable
IntraStatTransactionA varchar2(1) Transazione Intrastat A filters on the platform, writable
IntraStatTransactionB varchar2(1) Operazione Intrastat B filters on the platform, writable
IntraStatTransportMethod varchar2(1) Metodo di trasporto Intrastat filters on the platform, writable
InvoiceAccount guid Account di fatturazione filters on the platform, writable
InvoiceAccountCode varchar2(18) Codice del conto della fattura filters on the platform, writable
InvoiceAccountName varchar2(50) Nome dell'account di fatturazione filters on the platform, writable Name of account.
InvoiceAttachmentType int32 Tipo di allegato alla fattura filters on the platform, writable
InvoicingMethod int32 Modalità di fatturazione filters on the platform, writable
IsAccountant int16 È un contabile filters on the platform, writable
IsAgency int16 È un'agenzia filters on the platform, writable
IsAnonymised int16 È anonimizzato filters on the platform, writable Indicates whether the account is anonymised.
IsBank char È una banca filters on the platform, writable
IsCompetitor int16 È un concorrente filters on the platform, writable
IsExtraDuty char È un servizio straordinario filters on the platform, writable
IsMailing int16 È una spedizione postale filters on the platform, writable
IsMember char È membro filters on the platform, writable
IsPilot char È Pilot filters on the platform, writable
IsPurchase char È un acquisto filters on the platform, writable
IsReseller char È un rivenditore filters on the platform, writable
IsSales char È il reparto vendite filters on the platform, writable
IsSupplier char È un fornitore filters on the platform, writable
Language varchar2(30) Language filters on the platform, writable Codice lingua.
LanguageDescription varchar2(60) Descrizione della lingua filters on the platform, writable Language description.
Latitude double Latitude filters on the platform, writable
LeadPurpose guid Obiettivo principale filters on the platform, writable Reference to Lead Purpose of an account.
LeadSource guid Database di origine del cliente potenziale filters on the platform, writable
Logo blob Logo filters on the platform, writable
LogoFileName varchar2 Nome del file del logo filters on the platform, writable
LogoThumbnailUrl varchar2 Miniatura del logo (URL) writable
LogoUrl varchar2 Logo (URL) filters on the platform, writable
Longitude double Longitude filters on the platform, writable
MainContact guid Contatto principale filters on the platform, writable
Modified datetime Modified filters on the platform, writable Last modified date.
ModifiedUtc datetime Modificato (UTC) writable Last modified date in UTC.
Modifier guid Modifier filters on the platform, writable User ID of modifier.
ModifierFullName varchar2(240) Nome completo modificato filters on the platform, writable Name of modifier.
Name varchar2(50) Name filters on the platform, writable Name of account.
OINNumber varchar2(20) Numero OIN filters on the platform, writable Dutch government identification number.
Parent guid Parent filters on the platform, writable
PayAsYouEarn varchar2 Pay-as-you-Earn filters on the platform, writable
PaymentConditionPurchase varchar2(2) Condizioni di pagamento Acquisto filters on the platform, writable
PaymentConditionPurchaseDescription varchar2(60) Condizioni di pagamento Descrizione dell'acquisto filters on the platform, writable
PaymentConditionSales varchar2(2) Condizioni di pagamento Vendite filters on the platform, writable
PaymentConditionSalesDescription varchar2(60) Condizioni di pagamento Descrizione delle vendite filters on the platform, writable
PeppolIdentifier varchar2 Identificatore Peppol filtri sulla piattaforma
PeppolIdentifierType int32 Tipo di identificatore Peppol filtri sulla piattaforma
Phone varchar2(25) Phone filters on the platform, writable Numero di telefono.
PhoneExtension varchar2(15) Estensione del telefono filters on the platform, writable Phone number extension.
Postcode varchar2(20) Codice postale filters on the platform, writable Postcode.
PriceList guid Listino prezzi filters on the platform, writable
PurchaseCurrency varchar2(30) Valuta di acquisto filters on the platform, writable Currency of purchase.
PurchaseCurrencyDescription varchar2(60) Valuta di acquisto Descrizione filters on the platform, writable Description of purchase currency.
PurchaseLeadDays int32 Giorni di acquisizione dei clienti potenziali filters on the platform, writable
PurchaseVATCode varchar2(3) Codice IVA per l'acquisto filters on the platform, writable Purchase VAT code.
PurchaseVATCodeDescription varchar2(60) 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.
RecepientOfCommissions 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
ResellerCode varchar2(18) Codice rivenditore filters on the platform, writable Code of Reseller.
ResellerName varchar2(50) Nome del rivenditore filters on the platform, writable Name of reseller.
SalesCurrency varchar2(30) Valuta di vendita filters on the platform, writable Currency of sales price.
SalesCurrencyDescription varchar2(60) Valuta di vendita Descrizione filters on the platform, writable Description of sales currency.
SalesTaxSchedule guid Tabella delle imposte sulle vendite filters on the platform, writable
SalesTaxScheduleCode varchar2 Codice tariffario dell'imposta sulle vendite filters on the platform, writable
SalesTaxScheduleDescription varchar2 Descrizione della tabella delle imposte sulle vendite filters on the platform, writable
SalesVATCode varchar2(3) Codice IVA di vendita filters on the platform, writable Sales VAT code.
SalesVATCodeDescription varchar2(60) Codice IVA vendite Descrizione filters on the platform, writable Description of Sales VAT code.
SearchCode varchar2(15) Codice di ricerca filters on the platform, writable Search code.
SecurityLevel int32 Livello di sicurezza filters on the platform, writable
SeparateInvPerProject int16 Fattura separata per progetto filters on the platform, writable
SeparateInvPerSubscription int16 Fattura separata per ogni abbonamento filters on the platform, writable
ShippingLeadDays int32 Tempi di consegna stimati filters on the platform, writable
ShippingMethod guid Metodo di spedizione filters on the platform, writable
ShowRemarkForSales char Mostra commento per le vendite filters on the platform, writable
Source int16 Source filtri sulla piattaforma
StartDate datetime Data di inizio filters on the platform, writable
State varchar2(30) State filters on the platform, writable State/Province code.
StateName varchar2(60) Stato filters on the platform, writable Name of state/province.
Status varchar2(1) 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.
StatusSince datetime Stato dal filters on the platform, writable
TradeName varchar2(50) Tradename filters on the platform, writable
Type varchar2(1) Type filters on the platform, writable Account type: Values: A = Relation, D = Division.
UniqueTaxpayerReference varchar2 Riferimento unico del contribuente filters on the platform, writable
VATLiability varchar2 Responsabilità IVA filters on the platform, writable
VATNumber varchar2(35) Numero di partita IVA filters on the platform, writable VAT number.
Website varchar2(128) 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: