GLAccountsBulk: Exact Online General Ledger Accounts
read only per partition webhook REST
- Catalogue :
ExactOnlineREST - Schéma :
Financial - Clés primaires :
ID - Label: General Ledger Accounts
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 GLAccounts.
Source de l'API
- Point de terminaison :
/api/v1/{division}/bulk/financial/GLAccounts - Métadonnées :
/api/v1/{division}/bulk/financial/$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 GLAccountsBulk 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 |
|---|---|---|---|---|---|
Allow |
int16 |
itgen_eol_allowcostsinsales | filtres disponibles sur la plateforme | ||
Assimilated |
int16 |
Case « TVA intégrée » | filtres disponibles sur la plateforme | AssimilatedVATBox (France). | |
Balance |
varchar2 |
Côté bilan | The following values are supported: D (Debit) C (Credit). | ||
Balance |
varchar2 |
Type de solde | The following values are supported: B (Balance Sheet) W (Profit & Loss). | ||
Belcotax |
int32 |
Type d'impôt BELCO | filtres disponibles sur la plateforme | Indentify the kind of rewarding for the G/L account.This is used in the official document for the fiscal fiches Belcotax. | |
Code |
varchar2 |
Code | Unique Code of the G/L account. | ||
Compress |
char |
Compress | Indicate if this G/L account should be shown as compressed without the details in the CRW report of G/L history. | ||
Costcenter |
varchar2 |
Centre de coûts | filtres disponibles sur la plateforme | Cost Center linked to the G/L account. | |
Costcenter |
varchar2 |
Description du centre de coûts | Description of Costcenter. | ||
Costunit |
varchar2 |
Unité de coût | filtres disponibles sur la plateforme | Cost Unit linked to the G/L account. | |
Costunit |
varchar2 |
Description des unités de coût | Description of Costunit. | ||
Created |
datetime |
Created | filtres disponibles sur la plateforme | Creation date. | |
Created |
datetime |
Créé | writable | Creation date in UTC. | |
Creator |
guid |
Creator | filtres disponibles sur la plateforme | User ID of creator. | |
Creator |
varchar2 |
Nom complet de l'auteur | Name of creator. | ||
Custom |
varchar2 |
Champ personnalisé | writable | ||
Description |
varchar2 |
Description | Name of the G/L account. | ||
Description |
int32 |
Description - Identifiant du terme | writable | Term ID for description. | |
Division |
int32 |
ID de l'entreprise | Unique number of the Exact Online division. | ||
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. | |
Exclude |
int16 |
Liste hors TVA | General ledger transactions on this G/L account should not appear on the VAT listing. | ||
Expense |
double |
Pourcentage des dépenses non déductibles | Expenses on this G/L account can not be used to reduce the incomes. | ||
ID |
guid |
ID | filtres disponibles sur la plateforme | Primary Key. | |
Is |
char |
Est bloqué | When blocked you can't use this general ledger account anymore for new entries. | ||
Matching |
char |
Matching | Allow entries on this general ledger account to be matched via the G/L account card. | ||
Modified |
datetime |
Modified | filtres disponibles sur la plateforme | Last modified date. | |
Modified |
datetime |
Modifié (UTC) | writable | Last modified date in UTC. | |
Modifier |
guid |
Modifier | filtres disponibles sur la plateforme | User ID of modifier. | |
Modifier |
varchar2 |
Nom complet modifié | Name of modifier. | ||
Private |
guid |
Compte GL privé | filtres disponibles sur la plateforme | If a private use percentage is defined, you need to specify the G/L account used for the re-invoice of the private use to the owner of the company. | |
Private |
double |
Pourcentage privé | Specify the percentage of the cost that should be re-invoiced to the owner of the company as private use of the costs. | ||
Reporting |
varchar2 |
Code de déclaration | Used in the export of yearly report. | ||
Revalue |
char |
Réévaluer la devise | Indicates if the amounts booked on this general ledger account will be recalculated when currency revaluation is done. | ||
Search |
varchar2 |
Code de recherche | filtres disponibles sur la plateforme | Search Code. | |
Type |
int32 |
Type | filtres disponibles sur la plateforme | The type of the G/L account.Supported values are: 10 = Cash 12 = Bank 14 = Credit card 16 = Payment services 20 = Accounts receivable 21 = Prepayment accounts receivable 22 = Accounts payable 24 = VAT 25 = Employees payable 26 = Prepaid expenses 27 = Accrued expenses 29 = Income taxes payable 30 = Fixed assets 32 = Other assets 35 = Accumulated depreciation 40 = Inventory 50 = Capital stock 52 = Retained earnings 55 = Long term debt 60 = Current portion of debt 90 = General 100 = Tax payable 110 = Revenue 111 = Cost of goods 120 = Other costs 121 = Sales, general administrative expenses 122 = Depreciation costs 123 = Research and development 125 = Employee costs 126 = Employment costs 130 = Exceptional costs 140 = Exceptional income 150 = Income taxes 160 = Interest income 300 = Year end reflection 301 = Indirect year end costing 302 = Direct year end costing. | |
Type |
varchar2 |
Description du type | Description of Type. | ||
Use |
int16 |
Utiliser le Centre de coûts | Indicates if cost centers can be used when using this general ledger account.The following values are supported: 0 (Optional) 1 (Mandatory) 2 (No). | ||
Use |
int16 |
Unité de coût d'utilisation | Indicates if cost units can be used when using this general ledger account.The following values are supported: 0 (Optional) 1 (Mandatory) 2 (No). | ||
VAT |
varchar2 |
Code TVA | VAT Code linked to the G/L account. | ||
VAT |
varchar2 |
Description de la TVA | Description of VAT. | ||
VATGL |
varchar2 |
Type de compte général de TVA | Specify the kind of purchase this G/L account is used for.This is important for the Belgian VAT return to indicate in which VAT box the base amount of purchase should go. | ||
VAT |
guid |
itgen_eol_vatnondeductibleglaccount | filtres disponibles sur la plateforme | If you use a percentage of non deductible VAT, you can specify another G/L account that will be used for the non deductible part of the VAT amount.This is used directly in the entry application of purchase invoices. | |
VAT |
double |
itgen_eol_vatnondeductiblepercentage | If not the full amount of the VAT is deductible, you can indicate a percentage for the non decuctible part.This is used during the entry of purchase invoices. | ||
VAT |
varchar2 |
Système de TVA | The following values are supported: I (Invoice) C (Cash) (France). | ||
Year |
guid |
itgen_eol_yearendcostglaccount | filtres disponibles sur la plateforme | Indicates the costing account for year end calculations. | |
Year |
guid |
itgen_eol_yearendreflectionglaccount | filtres disponibles sur la plateforme | Indicates the reflection account that is used by year end application. |
Clés
| Key | Column | Se réfère à | Kind | Description |
|---|---|---|---|---|
GL |
Costcenter |
Costcenters.Code |
Key | |
GL |
Costunit |
Costunits.Code |
Key | |
GL |
Creator |
Users. |
Key | |
GL |
Modifier |
Users. |
Key | |
GL |
Private |
GLAccounts.ID |
Key | |
GL |
VAT |
VATCodes.Code |
Key | |
GL |
VAT |
GLAccounts.ID |
Key | |
GL |
Year |
GLAccounts.ID |
Key | |
GL |
Year |
GLAccounts.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 :