# GLAccountsBulk: 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. This is a read-only table. The Exact Online API may not support changing the data or the Invantive UniversalSQL driver for Exact Online does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Exact Online API. ## Table Columns The columns of the table `GLAccountsBulk` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `AllowCostsInSales` | `int16` | | ☐ | | | `AssimilatedVATBox` | `int16` | Assimilated VAT Box | ☐ | AssimilatedVATBox (France). | | `BalanceSide` | `varchar2` | Balance Side | ☐ | The following values are supported: D (Debit) C (Credit). | | `BalanceType` | `varchar2` | 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` | 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` | Cost Centre | ☐ | Cost Center linked to the G/L account. | | `CostcenterDescription` | `varchar2` | Cost Centre Description | ☐ | Description of Costcenter. | | `Costunit` | `varchar2` | Cost Unit | ☐ | Cost Unit linked to the G/L account. | | `CostunitDescription` | `varchar2` | 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` | Creator Full Name | ☐ | Name of creator. | | `CustomField` | `varchar2` | Custom Field | ☐ | | | `Description` | `varchar2` | Description | ☐ | Name of the G/L account. | | `DescriptionTermID` | `int32` | Description Term ID | ☐ | Term ID for description. | | `Division` | `int32` | Division ID | ☑ | Unique number of the Exact Online division. | | `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` | 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 owner of the company. | | `PrivatePercentage` | `double` | Private Percentage | ☐ | Specify the percentage of the cost that should be re-invoiced to the owner of the company as private use of the costs. | | `ReportingCode` | `varchar2` | 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` | Search Code | ☐ | Search Code. | | `Type` | `int32` | Type | ☐ | 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. | | `TypeDescription` | `varchar2` | 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` | VAT Code | ☐ | VAT Code linked to the G/L account. | | `VATDescription` | `varchar2` | VAT Description | ☐ | Description of VAT. | | `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` | 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. |