GLAccounts: Exact Online General Ledger Accounts
insert update delete per partition webhook REST
- Catalog:
ExactOnlineREST - Schema:
Financial - Primary Keys:
ID - Label: General Ledger Accounts
The data in this table is partitioned per value of the Division column.
Can retrieve data and change data using insert, update and delete.
Changes arrive through the webhook topic GLAccounts.
API Source
- Endpoint:
/api/v1/{division}/financial/GLAccounts - Metadata:
/api/v1/{division}/financial/$metadata
Performance Characteristics
| Characteristic | Value |
|---|---|
| Average access latency (ms) | 5 |
| Full scan rows per minute | 7,200 |
| Point query rows per minute | 300 |
| Write rows per minute | 300 |
The result can be cached on the client.
Table Columns
The columns of the table GLAccounts are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
Allow |
int16 |
itgen_eol_allowcostsinsales | filters on the platform, writable | ||
Assimilated |
int16 |
Assimilated VAT Box | filters on the platform, writable | AssimilatedVATBox (France). | |
Balance |
varchar2 |
Balance Side | filters on the platform, writable | The following values are supported: D (Debit) C (Credit). | |
Balance |
varchar2 |
Balance Type | filters on the platform, writable | The following values are supported: B (Balance Sheet) W (Profit & Loss). | |
Belcotax |
int32 |
BELCO Tax Type | filters on the platform, writable | 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 | filters on the platform, writable | Unique Code of the G/L account. | |
Compress |
char |
Compress | filters on the platform, writable | Indicate if this G/L account should be shown as compressed without the details in the CRW report of G/L history. | |
Costcenter |
varchar2 |
Cost Centre | filters on the platform, writable | Cost Center linked to the G/L account. | |
Costcenter |
varchar2 |
Cost Centre Description | filters on the platform, writable | Description of Costcenter. | |
Costunit |
varchar2 |
Cost Unit | filters on the platform, writable | Cost Unit linked to the G/L account. | |
Costunit |
varchar2 |
Cost Unit Description | filters on the platform, writable | Description of Costunit. | |
Created |
datetime |
Created | filters on the platform, writable | Creation date. | |
Created |
datetime |
Created (UTC) | writable | Creation date in UTC. | |
Creator |
guid |
Creator | filters on the platform, writable | User ID of creator. | |
Creator |
varchar2 |
Creator Full Name | filters on the platform, writable | Name of creator. | |
Custom |
varchar2 |
Custom Field | writable | ||
Description |
varchar2 |
Description | filters on the platform, writable | Name of the G/L account. | |
Description |
int32 |
Description Term ID | filters on the platform, writable | Term ID for description. | |
Division |
int32 |
Division | Division code. | ||
Division |
varchar2 |
Division Chamber of Commerce Number | writable | Chamber of commerce number of the Exact Online division. | |
Division |
varchar2 |
Division IBAN Number | writable | IBAN number of the Exact Online division. | |
Division |
varchar2 |
Division Company Name | writable | Company name of the Exact Online division. | |
Division |
varchar2 |
Division RSIN Number | writable | RSIN number of the Exact Online division. | |
Division |
varchar2 |
Division VAT Number | writable | VAT number of the Exact Online division. | |
Division |
varchar2 |
Division Wage Tax Number | writable | Wage tax number of the Exact Online division. | |
Division |
varchar2 |
Division Label | writable | Label of the Exact Online division. | |
Division |
varchar2 |
Administration Name | writable | Name of the Exact Online division. | |
Division |
varchar2 |
Subscription Holder Name | writable | Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
varchar2 |
Subscription Holder Number | writable | Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
int64 |
Division Short Name | writable | Short name of the Exact Online division. | |
Exclude |
int16 |
Exclude VAT Listing | filters on the platform, writable | General ledger transactions on this G/L account should not appear on the VAT listing. | |
Expense |
double |
Expense Non-deductible Percentage | filters on the platform, writable | Expenses on this G/L account can not be used to reduce the incomes. | |
ID |
guid |
ID | filters on the platform, writable | Primary Key. | |
Is |
char |
Is Blocked | filters on the platform, writable | When blocked you can't use this general ledger account anymore for new entries. | |
Matching |
char |
Matching | filters on the platform, writable | Allow entries on this general ledger account to be matched via the G/L account card. | |
Modified |
datetime |
Modified | filters on the platform, writable | Last modified date. | |
Modified |
datetime |
Modified (UTC) | writable | Last modified date in UTC. | |
Modifier |
guid |
Modifier | filters on the platform, writable | User ID of modifier. | |
Modifier |
varchar2 |
Modified Full Name | filters on the platform, writable | Name of modifier. | |
Private |
guid |
Private GL Account | filters on the platform, writable | 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 GlobalState of the company. | |
Private |
double |
Private Percentage | filters on the platform, writable | Specify the percentage of the cost that should be re-invoiced to the GlobalState of the company as private use of the costs. | |
Reporting |
varchar2 |
Reporting Code | filters on the platform, writable | Used in the export of yearly report. | |
Revalue |
char |
Revalue Currency | filters on the platform, writable | Indicates if the amounts booked on this general ledger account will be recalculated when currency revaluation is done. | |
Search |
varchar2 |
Search Code | filters on the platform, writable | Search Code. | |
Type |
int32 |
Type | filters on the platform, writable | The type of the G/L account. Possible values: see GLAccountTypes. | |
Type |
varchar2 |
Type Description | filters on the platform, writable | Description of Type. | |
Use |
int16 |
Use Cost Centre | filters on the platform, writable | 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 |
Use Cost Unit | filters on the platform, writable | 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 |
VAT Code | filters on the platform, writable | VAT Code linked to the G/L account. | |
VAT |
varchar2 |
VAT Description | filters on the platform, writable | Description of the VAT code. | |
VATGL |
varchar2 |
VAT GL Account Type | filters on the platform, writable | 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 | filters on the platform, writable | 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 | filters on the platform, writable | 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 |
VAT System | filters on the platform, writable | The following values are supported: I (Invoice) C (Cash) (France). | |
Year |
guid |
itgen_eol_yearendcostglaccount | filters on the platform, writable | Indicates the costing account for year end calculations. | |
Year |
guid |
itgen_eol_yearendreflectionglaccount | filters on the platform, writable | Indicates the reflection account that is used by year end application. |
Keys
| Key | Column | Refers to | 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 |
Referenced By
- AssetGroups
GLAccountAssets(Key) - AssetGroups
GLAccountDepreciationBS(Key) - AssetGroups
GLAccountDepreciationPL(Key) - AssetGroups
GLAccountRevaluationBS(Key) - Budgets
GLAccount(Key) - Accounts
GLAP(Key) - Accounts
GLAR(Key) - Accounts
GLAccountPurchase(Key) - Accounts
GLAccountSales(Key) - AccountsBulk
GLAP(Key) - AccountsBulk
GLAR(Key) - AccountsBulk
GLAccountPurchase(Key) - AccountsBulk
GLAccountSales(Key) - AllocationRule
GLAccount(Key) - Payments
GLAccount(Key) - PaymentsBulk
GLAccount(Key) - Receivables
GLAccount(Key) - ReceivablesBulk
GLAccount(Key) - IndicatorGLAccounts
GLAccount(Key) - IndicatorSignals
GLAccount(Key) - DeductibilityPercentages
GLAccount(Key) - GLAccountClassificationMappings
GLAccount(Key) - GLAccounts
PrivateGLAccount(Key) - GLAccounts
VATNonDeductibleGLAccount(Key) - GLAccounts
YearEndCostGLAccount(Key) - GLAccounts
YearEndReflectionGLAccount(Key) - GLAccountsBulk
PrivateGLAccount(Key) - GLAccountsBulk
VATNonDeductibleGLAccount(Key) - GLAccountsBulk
YearEndCostGLAccount(Key) - GLAccountsBulk
YearEndReflectionGLAccount(Key) - Journals
GLAccount(Key) - Journals
PaymentInTransitAccount(Key) - ReportingBalance
GLAccount(Key) - BankEntryLines
GLAccount(Key) - CashEntryLines
GLAccount(Key) - TransactionLines
GLAccount(Key) - TransactionLinesBulk
GLAccount(Key) - GeneralJournalEntryLines
GLAccount(Key) - StockCounts
OffsetGLInventory(Key) - ItemGroups
GLCosts(Key) - ItemGroups
GLPurchaseAccount(Key) - ItemGroups
GLPurchasePriceDifference(Key) - ItemGroups
GLRevenue(Key) - ItemGroups
GLStockVariance(Key) - ItemGroups
GLStock(Key) - Items
GLCosts(Key) - Items
GLRevenue(Key) - Items
GLStock(Key) - ItemsBulk
GLCosts(Key) - ItemsBulk
GLRevenue(Key) - ItemsBulk
GLStock(Key) - CurrentYearAfterEntry
GLAccount(Key) - CurrentYearProcessed
GLAccount(Key) - PreviousYearAfterEntry
GLAccount(Key) - PreviousYearProcessed
GLAccount(Key) - PurchaseEntryLines
GLAccount(Key) - SalesEntryLines
GLAccount(Key) - SalesInvoiceLines
GLAccount(Key) - SalesInvoiceLinesBulk
GLAccount(Key) - VATCodes
GLDiscountPurchase(Key) - VATCodes
GLDiscountSales(Key) - VATCodes
GLToClaim(Key) - VATCodes
GLToPay(Key)
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: