DocumentsBulk: Exact Online Documents
read only per partition webhook REST
- Catalogue :
ExactOnlineREST - Schéma :
Documents - Clés primaires :
ID - Label: Documents
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.
Les modifications sont transmises via le sujet de webhook Documents.
Source de l'API
- Point de terminaison :
/api/v1/{division}/bulk/Documents/Documents - Métadonnées :
/api/v1/{division}/bulk/Documents/$metadata
Caractéristiques de performance
| Characteristic | Value |
|---|---|
| Latence moyenne d'accès (ms) | 5 |
| Nombre de lignes par minute en mode de balayage complet | 20,000 |
| 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.
Colonnes de table
Les colonnes de la table DocumentsBulk 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 |
Account | filters on the platform, writable | ID of the related account of this document. | |
Account |
varchar2 |
Code du compte | writable | Code of Account. | |
Account |
varchar2 |
Nom du compte | writable | Name of account. | |
Amount |
double |
Montant en devise étrangère | writable | Amount in the currency of the transaction. | |
Body |
varchar2 |
Body | writable | Body of this document. | |
Category |
guid |
Category | filters on the platform, writable | ID of the category of this document. | |
Category |
varchar2 |
Description de catégorie | writable | Description of Category. | |
Contact |
guid |
Contact | filters on the platform, writable | ID of the related contact of this document. | |
Contact |
varchar2 |
Nom complet de la personne à contacter | writable | Contact full name. | |
Contract |
guid |
itgen_eol_contractid | writable | Contract ID. | |
Contract |
varchar2 |
itgen_eol_contractnumber | writable | Contract number. | |
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 | writable | Name of creator. | |
Currency |
varchar2 |
Currency | writable | Currency code. | |
Division |
int32 |
Division | filtres disponibles sur la plateforme | Division code. | |
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 |
datetime |
Date de document | filters on the platform, writable | Entry date of the incoming document. | |
Document |
guid |
Dossier de documents | filters on the platform, writable | The Id of document folder. | |
Document |
varchar2 |
itgen_eol_documentfoldercode | writable | The Code of document folder. | |
Document |
varchar2 |
itgen_eol_documentfolderdescription | writable | The Decsription of document folder. | |
Document |
varchar2 |
URL de consultation du document | writable | Url to view the document. | |
Expiry |
datetime |
Vervaldatum | Expiry date of this document. | ||
Financial |
guid |
itgen_eol_financialtransactionentryid | filters on the platform, writable | Reference to the transaction lines that make up the financial entry. | |
HID |
int32 |
HID | filters on the platform, writable | Human-readable ID, formatted as xx.xxx.xxx.Unique.May not be equal to zero. | |
Has |
char |
Contenu vide | writable | Indicates that the document body is empty. | |
ID |
guid |
ID | filters on the platform, writable | Primary key. | |
Inherit |
char |
Hériter Partager | |||
Item |
guid |
Item | filters on the platform, writable | ||
Item |
varchar2 |
Code de l'article | filtres disponibles sur la plateforme | ||
Item |
varchar2 |
Description de l’article | filtres disponibles sur la plateforme | ||
Language |
varchar2 |
Language | writable | The language code of the document. | |
Modified |
datetime |
Modified | filters on the platform, writable | Last modified date. | |
Modified |
datetime |
Modifié (UTC) | writable | Last modified date in UTC. | |
Modifier |
guid |
Modifier | writable | User ID of modifier. | |
Modifier |
varchar2 |
Nom complet modifié | writable | Name of modifier. | |
Opportunity |
guid |
Opportunity | filters on the platform, writable | The opportunity linked to the document. | |
Project |
guid |
Project | writable | The project linked to the document. | |
Project |
varchar2 |
Code de projet | writable | Code of project. | |
Project |
varchar2 |
Description du projet | writable | Description of project. | |
Proposed |
int16 |
Statut d'entrée proposé | |||
Sales |
int32 |
Numéro de facture de vente | filters on the platform, writable | 'Our reference' of the transaction that belongs to this document. | |
Sales |
int32 |
Numéro de commande client | writable | Number of the sales order. | |
Scan |
int16 |
itgen_eol_scanservicestatus | filtres disponibles sur la plateforme | ||
Send |
int32 |
Méthode d'envoi | writable | Send method. | |
Shop |
int32 |
Numéro de commande | writable | Number of the shop order. | |
Subject |
varchar2 |
Subject | filters on the platform, writable | Subject of this document. | |
Teams |
varchar2 |
itgen_eol_teamsmeetingid | |||
Type |
int32 |
Type | filters on the platform, writable | ID of the type of this document. | |
Type |
varchar2 |
Description du type | writable | Description of Type. |
Clés
| Key | Column | Se réfère à | Kind | Description |
|---|---|---|---|---|
Documents |
Account |
Accounts.ID |
Key | |
Documents |
Contact |
Contacts.ID |
Key | |
Documents |
Contract |
EmploymentContracts.ID |
Key | |
Documents |
Creator |
Users. |
Key | |
Documents |
Currency |
Currencies.Code |
Key | |
Documents |
Document |
DocumentFolders.ID |
Key | |
Documents |
Modifier |
Users. |
Key | |
Documents |
Opportunity |
Opportunities.ID |
Key | |
Documents |
Project |
Projects.ID |
Key |
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 :