Please enable JavaScript to view this site.

Exact Online API Data Model

Navigation: Catalog: ExactOnlineREST > Schemas > Schema: Financial > Tables

GLAccountsBulk: Exact Online General Ledger Accounts

Contents Previous Home Next More

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 SQL 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.

Webhook Topic: GLAccounts

Select Exact Online API URL: /api/v1/{division}/bulk/financial/GLAccounts

Insert Exact Online API URL: /api/v1/{division}/bulk/financial/GLAccounts

Update Exact Online API URL: /api/v1/{division}/bulk/financial/GLAccounts

Delete Exact Online API URL: /api/v1/{division}/bulk/financial/GLAccounts

Exact Online API Metadata URL: /api/v1/{division}/bulk/financial/$metadata

Field Selection Method: RequiredExpanded

Table Columns

The columns of the table GLAccountsBulk are shown below. Each column has an SQL data type.

Name

Data Type

Label

Required

Documentation

AssimilatedVATBox

int16

Assimilated VAT Box

AssimilatedVATBox (France).

BalanceSide

string

Balance Side

The following values are supported: D (Debit) C (Credit).

BalanceType

string

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

string

Code

Unique Code of the G/L account.

Compress

boolean

Compress

Indicate if this G/L account should be shown as compressed without the details in the CRW report of G/L history.

Costcenter

string

Cost Center

Cost Center linked to the G/L account.

CostcenterDescription

string

Cost Center Description

Description of Costcenter.

Costunit

string

Cost Unit

Cost Unit linked to the G/L account.

CostunitDescription

string

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

string

Creator Full Name

Name of creator.

Description

string

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

string(20)

Division Chamber of Commerce Number

Chamber of commerce number of the Exact Online division.

DivisionCompanyIBANNumber

string(50)

Division IBAN Number

IBAN number of the Exact Online division.

DivisionCompanyName

string(50)

Division Company Name

Company name of the Exact Online division.

DivisionCompanyRSINNumber

string(9)

Division RSIN Number

RSIN number of the Exact Online division.

DivisionCompanyVATNumber

string(35)

Division VAT Number

VAT number of the Exact Online division.

DivisionCompanyWageTaxNumber

string(60)

Division Wage Tax Number

Wage tax number of the Exact Online division.

DivisionLabel

string(128)

Division Label

Label of the Exact Online division.

DivisionName

string(50)

Administration Name

Name of the Exact Online division.

DivisionOwnerCompanyName

string(50)

Subscription Holder Name

Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs.

DivisionOwnerCompanyNumber

string(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

boolean

Is Blocked

When blocked you can't use this general ledger account anymore for new entries.

Matching

boolean

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

string

Modified Full Name

Name of modifier.

PrivateGLAccount

guid

 

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

string

 

Used in the export of yearly report.

RevalueCurrency

boolean

 

Indicates if the amounts booked on this general ledger account will be recalculated when currency revaluation is done.

SearchCode

string

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

string

Type Description

Description of Type.

UseCostcenter

int16

Use Cost Center

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

string

VAT Code

VAT Code linked to the G/L account.

VATDescription

string

VAT Description

Description of VAT.

VATGLAccountType

string

 

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

string

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.

 

14-04-2021 14:43 Version 20.1.394-BETA+3155