invantive documentation
Forums d'Invantive SupportConnectez-vous/inscrivez-vous

AccountsFullTextSearch: Exact Online Accounts Full-Text Search

read only per partition REST

  • Catalogue : ExactOnlineREST
  • Schéma : CRM
  • Clés primaires : ID
  • Label: Accounts Full-Text Search

Search for legal counter parties using a text query.

Les données de cette table sont partitionnées en fonction de la valeur de la colonne Division.

Permet uniquement de récupérer des données.

Source de l'API

  • Point de terminaison : /api/v1/{division}/read/crm/AccountsFullTextSearch
  • Métadonnées : /api/v1/{division}/read/crm/$metadata

Caractéristiques de performance

Characteristic Value
Latence moyenne d'accès (ms) 5
Nombre de lignes par minute en mode de balayage complet 7,200
Nombre de lignes de requêtes ponctuelles par minute 300
Nombre d'enregistrements écrits par minute 300

Le résultat peut être mis en cache côté client.

Paramètres

Name Type de données Required Default Documentation
division int32 ID of the division to retrieve data for.
searchText varchar2

Colonnes de table

Les colonnes de la table AccountsFullTextSearch sont présentées ci-dessous. Chaque colonne possède un type de données SQL. Une nouvelle valeur non nulle doit être fournie pour chaque colonne requise à tout moment lors de l'insertion et de la mise à jour.

Name Type de données Label Required Marks Documentation
AccountManager guid Responsable de comptes filters on the platform, writable
AccountManagerFullName varchar2(240) Nom complet du chargé de compte filters on the platform, writable
AccountManagerHID int32 Responsable de compte HID filters on the platform, writable
Accountant guid Accountant filters on the platform, writable
ActivitySector guid Secteur d'activité filters on the platform, writable
ActivitySubSector guid Sous-secteur d'activité filters on the platform, writable
AddressLine1 varchar2(80) Adresse ligne 1 filters on the platform, writable Visit address first line.
AddressLine2 varchar2(80) Adresse ligne 2 filters on the platform, writable Second address line.
AddressLine3 varchar2(80) Adresse ligne 3 filters on the platform, writable Third address line.
AddressSource int16 Source de l'adresse filters on the platform, writable
AutomaticProcessProposedEntry int16 Saisie automatique proposée par le processus filtres disponibles sur la plateforme
BRIN guid BRIN filters on the platform, writable
BSN varchar2 Numéro de sécurité sociale filters on the platform, writable Citizen Service Number for the Netherlands.
Blocked char Blocked filters on the platform, writable
BusinessType guid Type d'entreprise filters on the platform, writable
CanDropShip char Livraison directe possible filters on the platform, writable
ChamberOfCommerce varchar2(60) Chambre de commerce 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 Classification 1 filters on the platform, writable
Classification2 guid Classification 2 filters on the platform, writable
Classification3 guid Classification 3 filters on the platform, writable
Classification4 guid Classification 4 filters on the platform, writable
Classification5 guid Classification 5 filters on the platform, writable
Classification6 guid Classification 6 filters on the platform, writable
Classification7 guid Classification 7 filters on the platform, writable
Classification8 guid Classification 8 filters on the platform, writable
ClassificationDescription varchar2 Description de la classification filters on the platform, writable
Code varchar2 Code filters on the platform, writable
CodeAtSupplier varchar2(20) Code chez le fournisseur filters on the platform, writable Code under which your own company is known at the account.
CompanySize guid Taille de l'entreprise filters on the platform, writable
ConsolidationScenario int16 Scénario de consolidation filters on the platform, writable
ControlledDate datetime Date de vérification filters on the platform, writable
CostPaid int16 Coût payé filters on the platform, writable
Costcenter varchar2(8) Centre de coûts filters on the platform, writable
CostcenterDescription varchar2(60) Description du centre de coûts filters on the platform, writable
Country varchar2(30) Country filters on the platform, writable Country code.
CountryName varchar2 Nom du Pays filters on the platform, writable Country name.
Created datetime Created filters on the platform, writable Creation date.
CreatedUtc datetime Créé writable Creation date in UTC.
Creator guid Creator filters on the platform, writable User ID of creator.
CreatorFullName varchar2(240) Nom complet de l'auteur filters on the platform, writable Name of creator.
CreditLinePurchase double Ligne de crédit pour les achats filters on the platform, writable
CreditLineSales double Ligne de crédit pour les ventes filters on the platform, writable
Currency varchar2(30) Currency filters on the platform, writable Code of Currency.
CustomField varchar2 Champ personnalisé filters on the platform, writable
CustomerSince datetime Client depuis filters on the platform, writable
DatevCreditorCode varchar2(30) Code créancier DATEV filters on the platform, writable
DatevDebtorCode varchar2(30) Code débiteur DATEV filters on the platform, writable
DeliveryAdvice int16 Informations sur la livraison filtres disponibles sur la plateforme
DiscountPurchase double Remise à l'achat filters on the platform, writable
DiscountSales double Remise sur les ventes filters on the platform, writable
Division int32 Division writable
DivisionCompanyCoCNumber varchar2(60) Numéro d'enregistrement à la Chambre de commerce de la division writable Chamber of commerce number of the Exact Online division.
DivisionCompanyIBANNumber varchar2(50) Numéro IBAN de la division writable IBAN number of the Exact Online division.
DivisionCompanyName varchar2(50) Division - Nom de l'entreprise writable Company name of the Exact Online division.
DivisionCompanyRSINNumber varchar2(9) Numéro de division RSIN writable RSIN number of the Exact Online division.
DivisionCompanyVATNumber varchar2(35) Numéro de TVA de la division writable VAT number of the Exact Online division.
DivisionCompanyWageTaxNumber varchar2(60) Numéro d'identification fiscale de la division writable Wage tax number of the Exact Online division.
DivisionLabel varchar2(128) Étiquette de division writable Label of the Exact Online division.
DivisionName varchar2(50) Nom de l'administration writable Name of the Exact Online division.
DivisionOwnerCompanyName varchar2(50) Nom du titulaire de l'abonnement writable Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs.
DivisionOwnerCompanyNumber varchar2(18) Numéro d'abonné writable Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs.
DivisionShortName int64 Nom abrégé de la division writable Short name of the Exact Online division.
Document guid Document filters on the platform, writable
DunsNumber varchar2(9) Numéro DUNS filters on the platform, writable
EORINumber varchar2 Numéro EORI writable EORI number (United Kingdom).
Email varchar2(128) Email filters on the platform, writable
EnableSalesPaymentLink char Activer le lien de paiement des ventes filtres disponibles sur la plateforme
EndDate datetime Date de fin filters on the platform, writable
EstablishedDate datetime Date de création filters on the platform, writable
Fax varchar2(25) Fax filters on the platform, writable Fax number.
GLAP guid Comptabilité fournisseurs - Grand livre général filters on the platform, writable
GLAR guid Comptabilité clients - Grand livre général filters on the platform, writable
GLAccountPurchase guid Compte GL pour les achats filters on the platform, writable
GLAccountSales guid Compte GL des ventes filters on the platform, writable
GlnNumber varchar2(13) Numéro 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 Ventes soumises à la retenue à la source filters on the platform, writable
ID guid ID filters on the platform, writable
IgnoreDatevWarningMessage char Ignorer le message d'avertissement DATEV filters on the platform, writable
IncotermAddressPurchase varchar2 Incoterm : Adresse d'achat filters on the platform, writable
IncotermAddressSales varchar2 Incoterm : Adresse de vente filters on the platform, writable
IncotermCodePurchase varchar2 Achat de codes Incoterm filters on the platform, writable
IncotermCodeSales varchar2 Code Incoterm « Ventes » filters on the platform, writable
IncotermVersionPurchase int16 Achat de la version Incoterm filters on the platform, writable
IncotermVersionSales int16 Ventes selon les Incoterms filters on the platform, writable
IntraStatArea varchar2 Zone Intrastat filters on the platform, writable
IntraStatDeliveryTerm varchar2 Délai de transmission des données Intrastat filters on the platform, writable
IntraStatSystem varchar2(5) Système Intrastat filters on the platform, writable
IntraStatTransactionA varchar2(1) Transaction Intrastat A filters on the platform, writable
IntraStatTransactionB varchar2(1) Transaction Intrastat B filters on the platform, writable
IntraStatTransportMethod varchar2(1) Mode de transport Intrastat filters on the platform, writable
InvoiceAccount guid Compte de facturation filters on the platform, writable
InvoiceAccountCode varchar2(18) Code de compte de facturation filters on the platform, writable
InvoiceAccountName varchar2(50) Nom du compte de facturation filters on the platform, writable Name of account.
InvoiceAttachmentType int32 Type de pièce jointe à la facture filters on the platform, writable
InvoicingMethod int32 Mode de facturation filters on the platform, writable
IsAccountant int16 est comptable filters on the platform, writable
IsAgency int16 Qu'est-ce que l'Agence ? filters on the platform, writable
IsAnonymised int16 Est anonymisé filters on the platform, writable Indicates whether the account is anonymised.
IsBank char Est-ce que la banque filters on the platform, writable
IsCompetitor int16 Est-ce un concurrent ? filters on the platform, writable
IsExtraDuty char S'agit-il d'heures supplémentaires ? filters on the platform, writable
IsMailing int16 Est-ce que l'envoi postal filters on the platform, writable
IsMember char Est membre filters on the platform, writable
IsPilot char Est-ce que c'est Pilot ? filters on the platform, writable
IsPurchase char Est-ce un achat ? filters on the platform, writable
IsReseller char Est-il revendeur ? filters on the platform, writable
IsSales char Est-ce la vente ? filters on the platform, writable
IsSupplier char Est-il fournisseur ? filters on the platform, writable
Language varchar2(30) Language filters on the platform, writable Code de langue.
LanguageDescription varchar2(60) Description de la langue filters on the platform, writable Language description.
Latitude double Latitude filters on the platform, writable
LeadPurpose guid Objectif principal filters on the platform, writable Reference to Lead Purpose of an account.
LeadSource guid Source Principale filters on the platform, writable
Logo blob Logo filters on the platform, writable
LogoFileName varchar2 Nom du fichier du logo filters on the platform, writable
LogoThumbnailUrl varchar2 Vignette du logo (URL) writable
LogoUrl varchar2 Logo (URL) filters on the platform, writable
Longitude double Longitude filters on the platform, writable
MainContact guid Contact principal filters on the platform, writable
Modified datetime Modified filters on the platform, writable Last modified date.
ModifiedUtc datetime Modifié (UTC) writable Last modified date in UTC.
Modifier guid Modifier filters on the platform, writable User ID of modifier.
ModifierFullName varchar2(240) Nom complet modifié filters on the platform, writable Name of modifier.
Name varchar2(50) Name filters on the platform, writable Name of account.
OINNumber varchar2(20) Numéro 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) Conditions de paiement - Achat filters on the platform, writable
PaymentConditionPurchaseDescription varchar2(60) Conditions de paiement Description de l'achat filters on the platform, writable
PaymentConditionSales varchar2(2) Conditions de paiement - Ventes filters on the platform, writable
PaymentConditionSalesDescription varchar2(60) Conditions de paiement - Description des ventes filters on the platform, writable
PeppolIdentifier varchar2 Identifiant Peppol filtres disponibles sur la plateforme
PeppolIdentifierType int32 Type d'identifiant Peppol filtres disponibles sur la plateforme
Phone varchar2(25) Phone filters on the platform, writable Numéro de téléphone.
PhoneExtension varchar2(15) Poste téléphonique filters on the platform, writable Phone number extension.
Postcode varchar2(20) Code Postale filters on the platform, writable Postcode.
PriceList guid Tarif filters on the platform, writable
PurchaseCurrency varchar2(30) Devise d'achat filters on the platform, writable Currency of purchase.
PurchaseCurrencyDescription varchar2(60) Devise d'achat - Description filters on the platform, writable Description of purchase currency.
PurchaseLeadDays int32 Jours de prospection commerciale filters on the platform, writable
PurchaseVATCode varchar2(3) Code TVA d'achat filters on the platform, writable Purchase VAT code.
PurchaseVATCodeDescription varchar2(60) Code TVA d'achat - Description filters on the platform, writable Description of Purchase VAT code.
RSIN varchar2 Numéro RSIN filters on the platform, writable Fiscal number for NL legislation.
RecepientOfCommissions char Bénéficiaire de commandes filters on the platform, writable
Remarks varchar2 Remarks filters on the platform, writable
Reseller guid Reseller filters on the platform, writable
ResellerCode varchar2(18) Code revendeur filters on the platform, writable Code of Reseller.
ResellerName varchar2(50) Nom du revendeur filters on the platform, writable Name of reseller.
SalesCurrency varchar2(30) Devise de vente filters on the platform, writable Currency of sales price.
SalesCurrencyDescription varchar2(60) Devise de vente - Description filters on the platform, writable Description of sales currency.
SalesTaxSchedule guid Barème de la taxe sur les ventes filters on the platform, writable
SalesTaxScheduleCode varchar2 Code du barème de la taxe sur les ventes filters on the platform, writable
SalesTaxScheduleDescription varchar2 Description du barème de la taxe sur les ventes filters on the platform, writable
SalesVATCode varchar2(3) Code TVA sur les ventes filters on the platform, writable Sales VAT code.
SalesVATCodeDescription varchar2(60) Code TVA des ventes Description filters on the platform, writable Description of Sales VAT code.
SearchCode varchar2(15) Code de recherche filters on the platform, writable Search code.
SecurityLevel int32 Niveau de sécurité filters on the platform, writable
SeparateInvPerProject int16 Une facture distincte par projet filters on the platform, writable
SeparateInvPerSubscription int16 Facture distincte par abonnement filters on the platform, writable
ShippingLeadDays int32 Délais d'expédition filters on the platform, writable
ShippingMethod guid Mode d'expédition filters on the platform, writable
ShowRemarkForSales char Afficher la remarque relative aux ventes filters on the platform, writable
Source int16 Source filtres disponibles sur la plateforme
StartDate datetime Date de début filters on the platform, writable
State varchar2(30) State filters on the platform, writable State/Province code.
StateName varchar2(60) État 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 Statut depuis 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 Référence fiscale unique filters on the platform, writable
VATLiability varchar2 Assujettissement à la TVA filters on the platform, writable
VATNumber varchar2(35) Numéro de TVA filters on the platform, writable VAT number.
Website varchar2(128) Website filters on the platform, writable Website of the account.

Notes de Version

Quels ont été les changements apportés à chaque version au niveau des tables, des colonnes, des attributs et des fonctionnalités du chauffeur :