Please enable JavaScript to view this site.

Exact Online API Data Model

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

AccountsIncremental

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 AccountsIncremental are shown below. Each column has an SQL data type.

Name

Data Type

Label

Required

Documentation

Accountant

guid

Accountant

 

AccountManager

guid

Account Manager

 

AccountManagerHID

int32

Account Manager HID

 

ActivitySector

guid

Activity Sector

 

ActivitySubSector

guid

Activity Subsector

 

AddressLine1

string

Address Line 1

 

AddressLine2

string

Address Line 2

 

AddressLine3

string

Address Line 3

 

Blocked

boolean

Blocked

 

BRIN

guid

BRIN

 

BSN

string

 

 

BusinessType

guid

Business Type

 

CanDropShip

boolean

Can Drop Ship

 

ChamberOfCommerce

string

Chamber of Commerce

 

City

string

City

 

Classification

string

Classification

 

Classification1

guid

Classification 1

 

Classification2

guid

Classification 2

 

Classification3

guid

Classification 3

 

Classification4

guid

Classification 4

 

Classification5

guid

Classification 5

 

Classification6

guid

Classification 6

 

Classification7

guid

Classification 7

 

Classification8

guid

Classification 8

 

Code

string

Code

 

CodeAtSupplier

string

Code at Supplier

 

CompanySize

guid

Company Size

 

ConsolidationScenario

int16

Consolidation Scenario

 

ControlledDate

datetime

Date Checked

 

Costcenter

string

Cost Center

 

CostPaid

int16

Cost Paid

 

Country

string

Country

 

Created

datetime

Created

 

Creator

guid

Creator

 

CreditLinePurchase

double

Credit Line for Purchase

 

CreditLineSales

double

Credit Line for Sales

 

Currency

string

Currency

 

CustomerSince

datetime

Customer Since

 

DatevCreditorCode

string

DATEV Creditor Code

 

DatevDebtorCode

string

DATEV Debtor Code

 

DiscountPurchase

double

Discount for Purchase

 

DiscountSales

double

Discount for Sales

 

Division

int32

Division

 

Document

guid

Document

 

DunsNumber

string

DUNS Number

 

Email

string

Email

 

EndDate

datetime

End Date

 

EstablishedDate

datetime

Established Date

 

Fax

string

Fax

 

GLAccountPurchase

guid

GL Account for Purchase

 

GLAccountSales

guid

GL Account for Sales

 

GLAP

guid

Accounts Payables General Ledger

 

GLAR

guid

Accounts Receivables General Ledger

 

GlnNumber

string

GLN Number

 

HasWithholdingTaxSales

boolean

Has Withholding Tax Sales

 

ID

guid

ID

 

IgnoreDatevWarningMessage

boolean

Ignore DATEV Warning Message

 

IntraStatArea

string

Intrastat Area

 

IntraStatDeliveryTerm

string

Intrastat Delivery Term

 

IntraStatSystem

string

Intrastat System

 

IntraStatTransactionA

string

Intrastat Transaction A

 

IntraStatTransactionB

string

Intrastat Transaction B

 

IntraStatTransportMethod

string

Intrastat Transport Method

 

InvoiceAccount

guid

Invoice Account

 

InvoiceAttachmentType

int32

Invoice Attachment Type

 

InvoicingMethod

int32

Invoicing Method

 

IsAccountant

int16

Is Accountant

 

IsAgency

int16

Is Agency

 

IsAnonymised

int16

Is Anonymised

 

IsBank

boolean

Is Bank

 

IsCompetitor

int16

Is Competitor

 

IsExtraDuty

boolean

Is Extra Duty

 

IsMailing

int16

Is Mailing

 

IsMember

boolean

Is Member

 

IsPilot

boolean

Is Pilot

 

IsPurchase

boolean

Is Purchase

 

IsReseller

boolean

Is Reseller

 

IsSales

boolean

Is Sales

 

IsSupplier

boolean

Is Supplier

 

Language

string

Language

 

Latitude

double

Latitude

 

LeadPurpose

guid

Lead Purpose

 

LeadSource

guid

Lead Source

 

Logo

byte[]

Logo

 

LogoFileName

string

Logo File Name

 

LogoThumbnailUrl

string

Logo Thumbnail (URL)

 

LogoUrl

string

Logo (URL)

 

Longitude

double

Longitude

 

MainContact

guid

Main Contact

 

Modified

datetime

Modified

 

Modifier

guid

Modifier

 

Name

string

Name

 

OINNumber

string

OIN Number

 

Parent

guid

Parent

 

PayAsYouEarn

string

Pay-as-you-Earn

 

PaymentConditionPurchase

string

Payment Condition Purchase

 

PaymentConditionSales

string

Payment Condition Sales

 

Phone

string

Phone

 

PhoneExtension

string

Phone Extension

 

Postcode

string

Postal Code

 

PriceList

guid

Price List

 

PurchaseCurrency

string

Purchase Currency

 

PurchaseLeadDays

int32

Purchase Lead Days

 

PurchaseVATCode

string

Purchase VAT Code

 

RecepientOfCommissions

boolean

Recipient of Commissions

 

Remarks

string

Remarks

 

Reseller

guid

Reseller

 

RSIN

string

RSIN Number

 

SalesCurrency

string

Sales Currency

 

SalesTaxSchedule

guid

Sales Tax Schedule

 

SalesVATCode

string

Sales VAT Code

 

SearchCode

string

Search Code

 

SecurityLevel

int32

Security Level

 

SeparateInvPerProject

int16

Separate Invoice per Project

 

SeparateInvPerSubscription

int16

Separate Invoice per Subscription

 

ShippingLeadDays

int32

Shipping Lead Days

 

ShippingMethod

guid

Shipping Method

 

StartDate

datetime

Start Date

 

State

string

State

 

Status

string

Status

 

StatusSince

datetime

Status Since

 

Timestamp

int64

 

 

TradeName

string

Tradename

 

Type

string

Type

 

UniqueTaxpayerReference

string

Unique Taxpayer Reference

 

VATLiability

string

VAT Liability

 

VATNumber

string

VAT Number

 

Website

string

Website

 

 

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