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. | ||
search |
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 |
|---|---|---|---|---|---|
Account |
guid |
Responsable de comptes | filters on the platform, writable | ||
Account |
varchar2 |
Nom complet du chargé de compte | filters on the platform, writable | ||
Account |
int32 |
Responsable de compte HID | filters on the platform, writable | ||
Accountant |
guid |
Accountant | filters on the platform, writable | ||
Activity |
guid |
Secteur d'activité | filters on the platform, writable | ||
Activity |
guid |
Sous-secteur d'activité | filters on the platform, writable | ||
Address |
varchar2 |
Adresse ligne 1 | filters on the platform, writable | Visit address first line. | |
Address |
varchar2 |
Adresse ligne 2 | filters on the platform, writable | Second address line. | |
Address |
varchar2 |
Adresse ligne 3 | filters on the platform, writable | Third address line. | |
Address |
int16 |
Source de l'adresse | filters on the platform, writable | ||
Automatic |
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 | ||
Business |
guid |
Type d'entreprise | filters on the platform, writable | ||
Can |
char |
Livraison directe possible | filters on the platform, writable | ||
Chamber |
varchar2 |
Chambre de commerce | 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 |
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 | ||
Classification |
varchar2 |
Description de la classification | filters on the platform, writable | ||
Code |
varchar2 |
Code | filters on the platform, writable | ||
Code |
varchar2 |
Code chez le fournisseur | filters on the platform, writable | Code under which your own company is known at the account. | |
Company |
guid |
Taille de l'entreprise | filters on the platform, writable | ||
Consolidation |
int16 |
Scénario de consolidation | filters on the platform, writable | ||
Controlled |
datetime |
Date de vérification | filters on the platform, writable | ||
Cost |
int16 |
Coût payé | filters on the platform, writable | ||
Costcenter |
varchar2 |
Centre de coûts | filters on the platform, writable | ||
Costcenter |
varchar2 |
Description du centre de coûts | filters on the platform, writable | ||
Country |
varchar2 |
Country | filters on the platform, writable | Country code. | |
Country |
varchar2 |
Nom du Pays | filters on the platform, writable | Country name. | |
Created |
datetime |
Created | filters on the platform, writable | Creation date. | |
Created |
datetime |
Créé | writable | Creation date in UTC. | |
Creator |
guid |
Creator | filters on the platform, writable | User ID of creator. | |
Creator |
varchar2 |
Nom complet de l'auteur | filters on the platform, writable | Name of creator. | |
Credit |
double |
Ligne de crédit pour les achats | filters on the platform, writable | ||
Credit |
double |
Ligne de crédit pour les ventes | filters on the platform, writable | ||
Currency |
varchar2 |
Currency | filters on the platform, writable | Code of Currency. | |
Custom |
varchar2 |
Champ personnalisé | filters on the platform, writable | ||
Customer |
datetime |
Client depuis | filters on the platform, writable | ||
Datev |
varchar2 |
Code créancier DATEV | filters on the platform, writable | ||
Datev |
varchar2 |
Code débiteur DATEV | filters on the platform, writable | ||
Delivery |
int16 |
Informations sur la livraison | filtres disponibles sur la plateforme | ||
Discount |
double |
Remise à l'achat | filters on the platform, writable | ||
Discount |
double |
Remise sur les ventes | filters on the platform, writable | ||
Division |
int32 |
Division | writable | ||
Division |
varchar2 |
Numéro d'enregistrement à la Chambre de commerce de la division | writable | Chamber of commerce number of the Exact Online division. | |
Division |
varchar2 |
Numéro IBAN de la division | writable | IBAN number of the Exact Online division. | |
Division |
varchar2 |
Division - Nom de l'entreprise | writable | Company name of the Exact Online division. | |
Division |
varchar2 |
Numéro de division RSIN | writable | RSIN number of the Exact Online division. | |
Division |
varchar2 |
Numéro de TVA de la division | writable | VAT number of the Exact Online division. | |
Division |
varchar2 |
Numéro d'identification fiscale de la division | writable | Wage tax number of the Exact Online division. | |
Division |
varchar2 |
Étiquette de division | writable | Label of the Exact Online division. | |
Division |
varchar2 |
Nom de l'administration | writable | Name of the Exact Online division. | |
Division |
varchar2 |
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. | |
Division |
varchar2 |
Numéro d'abonné | writable | Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
int64 |
Nom abrégé de la division | writable | Short name of the Exact Online division. | |
Document |
guid |
Document | filters on the platform, writable | ||
Duns |
varchar2 |
Numéro DUNS | filters on the platform, writable | ||
EORI |
varchar2 |
Numéro EORI | writable | EORI number (United Kingdom). | |
Email |
varchar2 |
filters on the platform, writable | |||
Enable |
char |
Activer le lien de paiement des ventes | filtres disponibles sur la plateforme | ||
End |
datetime |
Date de fin | filters on the platform, writable | ||
Established |
datetime |
Date de création | filters on the platform, writable | ||
Fax |
varchar2 |
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 | ||
GL |
guid |
Compte GL pour les achats | filters on the platform, writable | ||
GL |
guid |
Compte GL des ventes | filters on the platform, writable | ||
Gln |
varchar2 |
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. | |
Has |
char |
Ventes soumises à la retenue à la source | filters on the platform, writable | ||
ID |
guid |
ID | filters on the platform, writable | ||
Ignore |
char |
Ignorer le message d'avertissement DATEV | filters on the platform, writable | ||
Incoterm |
varchar2 |
Incoterm : Adresse d'achat | filters on the platform, writable | ||
Incoterm |
varchar2 |
Incoterm : Adresse de vente | filters on the platform, writable | ||
Incoterm |
varchar2 |
Achat de codes Incoterm | filters on the platform, writable | ||
Incoterm |
varchar2 |
Code Incoterm « Ventes » | filters on the platform, writable | ||
Incoterm |
int16 |
Achat de la version Incoterm | filters on the platform, writable | ||
Incoterm |
int16 |
Ventes selon les Incoterms | filters on the platform, writable | ||
Intra |
varchar2 |
Zone Intrastat | filters on the platform, writable | ||
Intra |
varchar2 |
Délai de transmission des données Intrastat | filters on the platform, writable | ||
Intra |
varchar2 |
Système Intrastat | filters on the platform, writable | ||
Intra |
varchar2 |
Transaction Intrastat A | filters on the platform, writable | ||
Intra |
varchar2 |
Transaction Intrastat B | filters on the platform, writable | ||
Intra |
varchar2 |
Mode de transport Intrastat | filters on the platform, writable | ||
Invoice |
guid |
Compte de facturation | filters on the platform, writable | ||
Invoice |
varchar2 |
Code de compte de facturation | filters on the platform, writable | ||
Invoice |
varchar2 |
Nom du compte de facturation | filters on the platform, writable | Name of account. | |
Invoice |
int32 |
Type de pièce jointe à la facture | filters on the platform, writable | ||
Invoicing |
int32 |
Mode de facturation | filters on the platform, writable | ||
Is |
int16 |
est comptable | filters on the platform, writable | ||
Is |
int16 |
Qu'est-ce que l'Agence ? | filters on the platform, writable | ||
Is |
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 | ||
Is |
int16 |
Est-ce un concurrent ? | filters on the platform, writable | ||
Is |
char |
S'agit-il d'heures supplémentaires ? | filters on the platform, writable | ||
Is |
int16 |
Est-ce que l'envoi postal | filters on the platform, writable | ||
Is |
char |
Est membre | filters on the platform, writable | ||
Is |
char |
Est-ce que c'est Pilot ? | filters on the platform, writable | ||
Is |
char |
Est-ce un achat ? | filters on the platform, writable | ||
Is |
char |
Est-il revendeur ? | filters on the platform, writable | ||
Is |
char |
Est-ce la vente ? | filters on the platform, writable | ||
Is |
char |
Est-il fournisseur ? | filters on the platform, writable | ||
Language |
varchar2 |
Language | filters on the platform, writable | Code de langue. | |
Language |
varchar2 |
Description de la langue | filters on the platform, writable | Language description. | |
Latitude |
double |
Latitude | filters on the platform, writable | ||
Lead |
guid |
Objectif principal | filters on the platform, writable | Reference to Lead Purpose of an account. | |
Lead |
guid |
Source Principale | filters on the platform, writable | ||
Logo |
blob |
Logo | filters on the platform, writable | ||
Logo |
varchar2 |
Nom du fichier du logo | filters on the platform, writable | ||
Logo |
varchar2 |
Vignette du logo (URL) | writable | ||
Logo |
varchar2 |
Logo (URL) | filters on the platform, writable | ||
Longitude |
double |
Longitude | filters on the platform, writable | ||
Main |
guid |
Contact principal | filters on the platform, writable | ||
Modified |
datetime |
Modified | filters on the platform, writable | Last modified date. | |
Modified |
datetime |
Modifié (UTC) | writable | Last modified date in UTC. | |
Modifier |
guid |
Modifier | filters on the platform, writable | User ID of modifier. | |
Modifier |
varchar2 |
Nom complet modifié | filters on the platform, writable | Name of modifier. | |
Name |
varchar2 |
Name | filters on the platform, writable | Name of account. | |
OIN |
varchar2 |
Numéro 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 |
Conditions de paiement - Achat | filters on the platform, writable | ||
Payment |
varchar2 |
Conditions de paiement Description de l'achat | filters on the platform, writable | ||
Payment |
varchar2 |
Conditions de paiement - Ventes | filters on the platform, writable | ||
Payment |
varchar2 |
Conditions de paiement - Description des ventes | filters on the platform, writable | ||
Peppol |
varchar2 |
Identifiant Peppol | filtres disponibles sur la plateforme | ||
Peppol |
int32 |
Type d'identifiant Peppol | filtres disponibles sur la plateforme | ||
Phone |
varchar2 |
Phone | filters on the platform, writable | Numéro de téléphone. | |
Phone |
varchar2 |
Poste téléphonique | filters on the platform, writable | Phone number extension. | |
Postcode |
varchar2 |
Code Postale | filters on the platform, writable | Postcode. | |
Price |
guid |
Tarif | filters on the platform, writable | ||
Purchase |
varchar2 |
Devise d'achat | filters on the platform, writable | Currency of purchase. | |
Purchase |
varchar2 |
Devise d'achat - Description | filters on the platform, writable | Description of purchase currency. | |
Purchase |
int32 |
Jours de prospection commerciale | filters on the platform, writable | ||
Purchase |
varchar2 |
Code TVA d'achat | filters on the platform, writable | Purchase VAT code. | |
Purchase |
varchar2 |
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. | |
Recepient |
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 | ||
Reseller |
varchar2 |
Code revendeur | filters on the platform, writable | Code of Reseller. | |
Reseller |
varchar2 |
Nom du revendeur | filters on the platform, writable | Name of reseller. | |
Sales |
varchar2 |
Devise de vente | filters on the platform, writable | Currency of sales price. | |
Sales |
varchar2 |
Devise de vente - Description | filters on the platform, writable | Description of sales currency. | |
Sales |
guid |
Barème de la taxe sur les ventes | filters on the platform, writable | ||
Sales |
varchar2 |
Code du barème de la taxe sur les ventes | filters on the platform, writable | ||
Sales |
varchar2 |
Description du barème de la taxe sur les ventes | filters on the platform, writable | ||
Sales |
varchar2 |
Code TVA sur les ventes | filters on the platform, writable | Sales VAT code. | |
Sales |
varchar2 |
Code TVA des ventes Description | filters on the platform, writable | Description of Sales VAT code. | |
Search |
varchar2 |
Code de recherche | filters on the platform, writable | Search code. | |
Security |
int32 |
Niveau de sécurité | filters on the platform, writable | ||
Separate |
int16 |
Une facture distincte par projet | filters on the platform, writable | ||
Separate |
int16 |
Facture distincte par abonnement | filters on the platform, writable | ||
Shipping |
int32 |
Délais d'expédition | filters on the platform, writable | ||
Shipping |
guid |
Mode d'expédition | filters on the platform, writable | ||
Show |
char |
Afficher la remarque relative aux ventes | filters on the platform, writable | ||
Source |
int16 |
Source | filtres disponibles sur la plateforme | ||
Start |
datetime |
Date de début | filters on the platform, writable | ||
State |
varchar2 |
State | filters on the platform, writable | State/Province code. | |
State |
varchar2 |
État | 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 |
Statut depuis | 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 |
Référence fiscale unique | filters on the platform, writable | ||
VAT |
varchar2 |
Assujettissement à la TVA | filters on the platform, writable | ||
VAT |
varchar2 |
Numéro de TVA | filters on the platform, writable | VAT number. | |
Website |
varchar2 |
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 :