# GLAccounts: Exact Online General Ledger Accounts - 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. ## 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 | Documentation | |---|:---:|---|:---:|---| | `AllowCostsInSales` | `int16` | | ☐ | | | `AssimilatedVATBox` | `int16` | Assimilated VAT Box | ☐ | AssimilatedVATBox (France). | | `BalanceSide` | `varchar2`(1) | Balance Side | ☐ | The following values are supported: D (Debit) C (Credit). | | `BalanceType` | `varchar2`(1) | Balance Type | ☐ | The following values are supported: B (Balance Sheet) W (Profit & Loss). | | `BelcotaxType` | `int32` | BELCO Tax Type | ☐ | Indentify the kind of rewarding for the G/L account. This is used in the official document for the fiscal fiches Belcotax. | | `Code` | `varchar2`(30) | 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`(8) | Cost Centre | ☐ | Cost Center linked to the G/L account. | | `CostcenterDescription` | `varchar2`(60) | Cost Centre Description | ☐ | Description of Costcenter. | | `Costunit` | `varchar2`(8) | Cost Unit | ☐ | Cost Unit linked to the G/L account. | | `CostunitDescription` | `varchar2`(60) | Cost Unit Description | ☐ | Description of Costunit. | | `Created` | `datetime` | Created | ☐ | Creation date. | | `CreatedUtc` | `datetime` | Created (UTC) | ☐ | Creation date in UTC. | | `Creator` | `guid` | Creator | ☐ | User ID of creator. | | `CreatorFullName` | `varchar2`(240) | Creator Full Name | ☐ | Name of creator. | | `CustomField` | `varchar2` | Custom Field | ☐ | | | `Description` | `varchar2`(60) | Description | ☐ | Name of the G/L account. | | `DescriptionTermID` | `int32` | Description Term ID | ☐ | Term ID for description. | | `Division` | `int32` | Division | ☑ | Division code. | | `DivisionCompanyCoCNumber` | `varchar2`(60) | Division Chamber of Commerce Number | ☐ | Chamber of commerce number of the Exact Online division. | | `DivisionCompanyIBANNumber` | `varchar2`(50) | Division IBAN Number | ☐ | IBAN number of the Exact Online division. | | `DivisionCompanyName` | `varchar2`(50) | Division Company Name | ☑ | Company name of the Exact Online division. | | `DivisionCompanyRSINNumber` | `varchar2`(9) | Division RSIN Number | ☐ | RSIN number of the Exact Online division. | | `DivisionCompanyVATNumber` | `varchar2`(35) | Division VAT Number | ☐ | VAT number of the Exact Online division. | | `DivisionCompanyWageTaxNumber` | `varchar2`(60) | Division Wage Tax Number | ☐ | Wage tax number of the Exact Online division. | | `DivisionLabel` | `varchar2`(128) | Division Label | ☑ | Label of the Exact Online division. | | `DivisionName` | `varchar2`(50) | Administration Name | ☑ | Name of the Exact Online division. | | `DivisionOwnerCompanyName` | `varchar2`(50) | Subscription Holder Name | ☑ | Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | | `DivisionOwnerCompanyNumber` | `varchar2`(18) | Subscription Holder Number | ☑ | Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | | `DivisionShortName` | `int64` | Division Short Name | ☑ | Short name of the Exact Online division. | | `ExcludeVATListing` | `int16` | Exclude VAT Listing | ☑ | General ledger transactions on this G/L account should not appear on the VAT listing. | | `ExpenseNonDeductiblePercentage` | `double` | Expense Non-deductible Percentage | ☐ | Expenses on this G/L account can not be used to reduce the incomes. | | `ID` | `guid` | ID | ☑ | Primary Key. | | `IsBlocked` | `char` | Is Blocked | ☐ | 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 | ☐ | Last modified date. | | `ModifiedUtc` | `datetime` | Modified (UTC) | ☐ | Last modified date in UTC. | | `Modifier` | `guid` | Modifier | ☐ | User ID of modifier. | | `ModifierFullName` | `varchar2`(240) | Modified Full Name | ☐ | Name of modifier. | | `PrivateGLAccount` | `guid` | Private GL Account | ☐ | 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. | | `PrivatePercentage` | `double` | Private Percentage | ☐ | Specify the percentage of the cost that should be re-invoiced to the GlobalState of the company as private use of the costs. | | `ReportingCode` | `varchar2`(132) | Reporting Code | ☐ | Used in the export of yearly report. | | `RevalueCurrency` | `char` | Revalue Currency | ☐ | Indicates if the amounts booked on this general ledger account will be recalculated when currency revaluation is done. | | `SearchCode` | `varchar2`(15) | Search Code | ☐ | Search Code. | | `Type` | `int32` | Type | ☐ | The type of the G/L account. Possible values: see GLAccountTypes. | | `TypeDescription` | `varchar2`(240) | Type Description | ☐ | Description of Type. | | `UseCostcenter` | `int16` | Use Cost Centre | ☐ | Indicates if cost centers can be used when using this general ledger account. The following values are supported: 0 (Optional) 1 (Mandatory) 2 (No). | | `UseCostunit` | `int16` | Use Cost Unit | ☐ | Indicates if cost units can be used when using this general ledger account. The following values are supported: 0 (Optional) 1 (Mandatory) 2 (No). | | `VATCode` | `varchar2`(3) | VAT Code | ☐ | VAT Code linked to the G/L account. | | `VATDescription` | `varchar2`(60) | VAT Description | ☐ | Description of the VAT code. | | `VATGLAccountType` | `varchar2` | VAT GL Account Type | ☐ | 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. | | `VATNonDeductibleGLAccount` | `guid` | | ☐ | 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. | | `VATNonDeductiblePercentage` | `double` | | ☐ | 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. | | `VATSystem` | `varchar2`(1) | VAT System | ☐ | The following values are supported: I (Invoice) C (Cash) (France). | | `YearEndCostGLAccount` | `guid` | | ☐ | Indicates the costing account for year end calculations. | | `YearEndReflectionGLAccount` | `guid` | | ☐ | Indicates the reflection account that is used by year end application. |