Please enable JavaScript to view this site.

Exact Online API Data Model

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

GLAccountsIncremental

Contents Previous Home Next More

Catalog: ExactOnlineREST

Schema: Incremental

Primary Keys: ID

The data in this table is partitioned per value of the Division column.

This is a read-only view. 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.

Field Selection Method: NotRequired

View Columns

The columns of the view GLAccountsIncremental are shown below. Each column has an SQL data type.

Name

Data Type

Label

Required

Documentation

AssimilatedVATBox

int16

Assimilated VAT Box

 

BalanceSide

string

Balance Side

 

BalanceType

string

Balance Type

 

BelcotaxType

int32

BELCO Tax Type

 

Code

string

Code

 

Compress

boolean

Compress

 

Costcenter

string

Cost Center

 

Costunit

string

Cost Unit

 

Created

datetime

Created

 

Creator

guid

Creator

 

Description

string

Description

 

Division

int32

Division

 

ExcludeVATListing

int16

Exclude VAT Listing

 

ExpenseNonDeductiblePercentage

double

Expense Non-deductible Percentage

 

ID

guid

ID

 

IsBlocked

boolean

Is Blocked

 

Matching

boolean

Matching

 

Modified

datetime

Modified

 

Modifier

guid

Modifier

 

PrivateGLAccount

guid

 

 

PrivatePercentage

double

Private Percentage

 

ReportingCode

string

 

 

RevalueCurrency

boolean

 

 

SearchCode

string

Search Code

 

Timestamp

int64

 

 

Type

int32

Type

 

UseCostcenter

int16

Use Cost Center

 

UseCostunit

int16

Use Cost Unit

 

VATCode

string

VAT Code

 

VATGLAccountType

string

 

 

VATNonDeductibleGLAccount

guid

 

 

VATNonDeductiblePercentage

double

 

 

VATSystem

string

VAT System

 

YearEndCostGLAccount

guid

 

 

YearEndReflectionGLAccount

guid

 

 

 

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