Please enable JavaScript to view this site.

Exact Online API Data Model

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

GLAccounts: 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.

Can retrieve data and change data using insert, update and delete.

Webhook Topic: GLAccounts

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

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

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

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

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

Field Selection Method: Required

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 or update.

Name

Data Type

Label

Required

Documentation

AssimilatedVATBox

int16

Assimilated VAT Box

AssimilatedVATBox (France).

BalanceSide

string(1)

Balance Side

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

BalanceType

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

string(30)

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(8)

Cost Center

Cost Center linked to the G/L account.

CostcenterDescription

string(60)

Cost Center Description

Description of Costcenter.

Costunit

string(8)

Cost Unit

Cost Unit linked to the G/L account.

CostunitDescription

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

string(240)

Creator Full Name

Name of creator.

Description

string(60)

Description

Name of the G/L account.

DescriptionTermID

int32

Description Term ID

Term ID for description.

Division

int32

Division

Division code.

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(240)

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

string(132)

 

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(15)

Search Code

Search Code.

Type

int32

Type

The type of the G/L account. Possible values: see GLAccountTypes.

TypeDescription

string(240)

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(3)

VAT Code

VAT Code linked to the G/L account.

VATDescription

string(60)

VAT Description

Description of the VAT code.

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

 

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