AccountsBulk: Exact Online Relaties

Accountant

guid

Accountant

☐

Reference to the accountant of the customer. Conditions: The referred accountant must have value > 0 in the field IsAccountant.

AccountManager

guid

Verkoper

☐

ID of the account manager.

AccountManagerFullName

string

Accountmanager Volledige Naam

☐

Name of the account manager.

AccountManagerHID

int32

Verkoper HID

☐

Number of the account manager.

ActivitySector

guid

Sector

☐

Reference to Activity sector of the account.

ActivitySubSector

guid

Activiteit Subsector

☐

Reference to Activity sub-sector of the account.

AddressLine1

string(80)

Adresregel 1

☐

Visit address first line.

AddressLine2

string(80)

Adresregel 2

☐

Visit address second line.

AddressLine3

string(80)

Adresregel 3

☐

Visit address third line.

AddressSource

int16

{res:itgen_eol_addresssource}

☐

AutomaticProcessProposedEntry

int16

{res:itgen_eol_automaticprocessproposedentry}

☑

Blocked

boolean

Geblokkeerd

☐

Indicates if the account is blocked.

BRIN

guid

BRIN

☐

Obsolete.

BSN

string

Burgerservicenummer

☐

Citizen Service Number for the Netherlands.

BusinessType

guid

Bedrijfstype

☐

Reference to the business type of the account.

CanDropShip

boolean

Kan Drop Shipment

☐

Indicates the default for the possibility to drop ship when an item is linked to a supplier.

ChamberOfCommerce

string(60)

Kamer van Koophandel

☐

Chamber of commerce number.

City

string

Plaats

☐

Visit address City.

Classification

string

Classificatie

☐

Obsolete.

Classification1

guid

Classificatie 1

☐

Account classification 1.

Classification1Code

string

Classificatie 1 Code

☐

Code of classification 1. See view Classifications.

Classification1Description

string

Classificatie 1 Beschrijving

☐

Description of classification 1. See view Classifications.

Classification2

guid

Classificatie 2

☐

Account classification 2.

Classification2Code

string

Classificatie 2-code

☐

Code of classification 2. See view Classifications.

Classification2Description

string

Classificatie 2 Beschrijving:

☐

Description of classification 2. See view Classifications.

Classification3

guid

Classificatie 3

☐

Account classification 3.

Classification3Code

string

Classificatie 3 Code

☐

Code of classification 3. See view Classifications.

Classification3Description

string

Classificatie 3 Omschrijving

☐

Description of classification 3. See view Classifications.

Classification4

guid

Classificatie 4

☐

Account classification 4.

Classification4Code

string

Classificatie 4-code

☐

Code of classification 4. See view Classifications.

Classification4Description

string

Classificatie 4 Omschrijving

☐

Description of classification 4. See view Classifications.

Classification5

guid

Classificatie 5

☐

Account classification 5.

Classification5Code

string

Classificatie 5 Code

☐

Code of classification 5. See view Classifications.

Classification5Description

string

Classificatie 5 Omschrijving

☐

Description of classification 5. See view Classifications.

Classification6

guid

Classificatie 6

☐

Account classification 6.

Classification6Code

string

Classificatie 6 Code

☐

Code of classification 6. See view Classifications.

Classification6Description

string

Classificatie 6 Beschrijving

☐

Description of classification 6. See view Classifications.

Classification7

guid

Classificatie 7

☐

Account classification 7.

Classification7Code

string

Classificatie 7 Code

☐

Code of classification 7. See view Classifications.

Classification7Description

string

Classificatie 7 Beschrijving

☐

Description of classification 7. See view Classifications.

Classification8

guid

Classificatie 8

☐

Account classification 8.

Classification8Code

string

Classificatie 8 Code

☐

Code of classification 8. See view Classifications.

Classification8Description

string

Classificatie 8 Beschrijving

☐

Description of classification 8. See view Classifications.

ClassificationDescription

string

Classificatie Omschrijving

☐

Obsolete.

Code

string

Code

☐

Unique key, fixed length numeric string with leading spaces, length 18. IMPORTANT: When you use OData $filter on this field you have to make sure the filter parameter contains the leading spaces.

CodeAtSupplier

string

Code bij Leverancier

☐

Code under which your own company is known at the account.

CompanySize

guid

Bedrijfsomvang

☐

Reference to Company size of the account.

ConsolidationScenario

int16

Consolidatie Scenario

☐

Consolidation scenario (Time & Billing). Values: 0 = No consolidation, 1 = Item, 2 = Item + Project, 3 = Item + Employee, 4 = Item + Employee + Project, 5 = Project + WBS + Item, 6 = Project + WBS + Item + Employee. Item means in this case including Unit and Price, these also have to be the same to consolidate.

ControlledDate

datetime

Datum Gecontroleerd

☐

Date of the latest control of account data with external web service.

Costcenter

string

Kostenplaats

☐

Obsolete.

CostcenterDescription

string

Kostenplaats Omschrijving

☐

Obsolete.

CostPaid

int16

Kosten Betaald

☐

Obsolete.

Country

string

Land

☐

Country code.

CountryName

string

Landsnaam

☐

Country name.

Created

datetime

Gemaakt

☐

Creation date.

CreatedUtc

datetime

Aangemaakt (UTC)

☐

Creation date in UTC.

Creator

guid

Aanmaker

☐

User ID of creator.

CreatorFullName

string

Aanmaker Volledige Naam

☐

Name of creator.

CreditLinePurchase

double

Kredietlijn voor Inkoop

☐

Maximum amount of credit for Purchase. If no value has been defined, there is no credit limit.

CreditLineSales

double

Kredietlijn voor Verkoop

☐

Maximum amount of credit for sales. If no value has been defined, there is no credit limit.

Currency

string

Valuta

☐

Obsolete.

CustomerSince

datetime

Klant Sinds

☐

Obsolete.

CustomField

string

{res:itgen_eol_customfield}

☐

DatevCreditorCode

string

DATEV Crediteurcode

☐

DATEV creditor code for Germany legislation.

DatevDebtorCode

string

DATEV Debiteurencode

☐

DATEV debtor code for Germany legislation.

DeliveryAdvice

int16

{res:itgen_eol_deliveryadvice}

☐

DiscountPurchase

double

Korting voor Aankoop

☐

Default discount percentage for purchase. This is stored as a fraction. ie 5.5% is stored as .055.

DiscountSales

double

Korting voor Verkoop

☐

Default discount percentage for sales. This is stored as a fraction. ie 5.5% is stored as .055.

Division

int32

Divisie ID

☑

Unique number of the Exact Online division.

DivisionCompanyCoCNumber

string(60)

Divisie Kamer van Koophandel Nummer

☐

Chamber of commerce number of the Exact Online division.

DivisionCompanyIBANNumber

string(50)

Divisie IBAN Nummer

☐

IBAN number of the Exact Online division.

DivisionCompanyName

string(50)

Divisie Bedrijfsnaam

☑

Company name of the Exact Online division.

DivisionCompanyRSINNumber

string(9)

Divisie RSIN Nummer

☐

RSIN number of the Exact Online division.

DivisionCompanyVATNumber

string(35)

Divisie BTW Nummer

☐

VAT number of the Exact Online division.

DivisionCompanyWageTaxNumber

string(60)

Divisie Loonbelastingnummer

☐

Wage tax number of the Exact Online division.

DivisionLabel

string(128)

Divisie Label

☑

Label of the Exact Online division.

DivisionName

string(50)

Administratie Naam

☑

Name of the Exact Online division.

DivisionOwnerCompanyName

string(50)

Naam Abonnementhouder

☑

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

DivisionOwnerCompanyNumber

string(18)

Abonnementhoudernummer

☑

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

DivisionShortName

int64

Divisie Korte Naam

☑

Short name of the Exact Online division.

Document

guid

Document

☐

Obsolete.

DunsNumber

string

DUNS Nummer

☐

Obsolete.

Email

string

E-mail

☐

E-Mail address of the account.

EnableSalesPaymentLink

boolean

{res:itgen_eol_enablesalespaymentlink}

☐

EndDate

datetime

Einddatum

☐

Determines in combination with the start date if the account is active. If the current date is > end date the account is inactive.

EORINumber

string

EORI-nummer

☐

EORI number (United Kingdom).

EstablishedDate

datetime

Datum Opgericht

☐

RegistrationDate.

Fax

string

Fax

☐

Fax number.

GLAccountPurchase

guid

Grootboekrekening voor Inkoop

☐

Default (corporate) GL offset account for purchase (cost).

GLAccountSales

guid

Grootboekrekeing voor Verkoop

☐

Default (corporate) GL offset account for sales (revenue).

GLAP

guid

Crediteuren Grootboek

☐

Default GL account for Accounts Payable.

GLAR

guid

Debiteuren Grootboek

☐

Default GL account for Accounts Receivable.

GlnNumber

string

GLN Nummer

☐

Global Location Number can be used by companies to identify their locations, giving them complete flexibility to identify any type or level of location required.

HasWithholdingTaxSales

boolean

Heeft Bronbelasting Verkoop

☐

Indicates whether a customer has withholding tax on sales.

ID

guid

ID

☑

Primary key.

IgnoreDatevWarningMessage

boolean

Negeer DATEV Waarschuwingsbericht

☑

Suppressed warning message when there is duplication on the DATEV code.

IncotermAddressPurchase

string

{res:itgen_eol_incotermaddresspurchase}

☐

IncotermAddressSales

string

{res:itgen_eol_incotermaddresssales}

☐

IncotermCodePurchase

string

{res:itgen_eol_incotermcodepurchase}

☐

IncotermCodeSales

string

Incoterm Verkoopcode

☐

IncotermVersionPurchase

int16

{res:itgen_eol_incotermversionpurchase}

☐

IncotermVersionSales

int16

{res:itgen_eol_incotermversionsales}

☐

IntraStatArea

string

Intrastat Gebied

☐

Intrastat Area.

IntraStatDeliveryTerm

string

Intrastat Afleverconditie

☐

Intrastat delivery method.

IntraStatSystem

string

Intrastat Systeem

☐

System for Intrastat.

IntraStatTransactionA

string

Intrastat Transactie A

☐

Transaction type A for Intrastat.

IntraStatTransactionB

string

Intrastat Transactie B

☐

Transaction type B for Intrastat.

IntraStatTransportMethod

string

Intrastat Transportmethode

☐

Transport method for Intrastat.

InvoiceAccount

guid

Factuurrekening

☐

ID of account to be invoiced instead of this account.

InvoiceAccountCode

string

Factuur Account Code

☐

Code of InvoiceAccount.

InvoiceAccountName

string

Factuur Accountnaam

☐

Name of InvoiceAccount.

InvoiceAttachmentType

int32

Factuur Bijlagesoort

☐

Indicates which attachment types should be sent when a sales invoice is printed. Only values in related table with Invoice=1 are allowed.

InvoicingMethod

int32

Facturatiemethode

☐

Method of sending for sales invoices. Values: 1: Paper, 2: EMail, 4: Mailbox (electronic exchange).

IsAccountant

int16

Is Accountant

☑

Indicates whether the account is an accountant. Values: 0 = No accountant, 1 = True, but accountant doesn't want his name to be published in the list of accountants, 2 = True, and accountant is published in the list of accountants.

IsAgency

int16

Is Instantie

☑

Indicates whether the accounti is an agency.

IsAnonymised

int16

Is Geanonimiseerd

☑

Indicates whtether the account is anonymised.

IsBank

boolean

Is Bank

☐

Obsolete.

IsCompetitor

int16

Is Concurrent

☑

Indicates whether the account is a competitor.

IsExtraDuty

boolean

Is Extra Belasting

☐

Indicates whether a customer is eligible for extra duty.

IsMailing

int16

Is Mailing

☑

Indicates if the account is excluded from mailing marketing information.

IsMember

boolean

Is Lid

☐

Obsolete.

IsPilot

boolean

Is Pilot

☐

Indicates whether the account is a pilot account.

IsPurchase

boolean

Is Aankoop

☐

Obsolete.

IsReseller

boolean

Is Wederverkoper

☐

Indicates whether the account is a reseller.

IsSales

boolean

Is Verkoop

☐

Indicates whether the account is allowed for sales.

IsSupplier

boolean

Is Leverancier

☐

Indicates whether the account is a supplier.

Language

string

Taal

☐

Language code.

LanguageDescription

string

Taal Omschrijving

☐

Language description.

Latitude

double

Breedtegraad

☐

Latitude (used by Google maps).

LeadPurpose

guid

Lead Doel

☐

Reference to Lead purpose of an account.

LeadSource

guid

Lead Bron

☐

Reference to Lead source of an account.

Logo

byte[]

Logo

☐

Bytes of the logo image.

LogoFileName

string

Logo Bestandsnaam

☐

The file name (without path, but with extension) of the image.

LogoThumbnailUrl

string

Logo Thumbnail (URL)

☐

Thumbnail url of the logo.

LogoUrl

string

Logo (URL)

☐

Url to retrieve the logo.

Longitude

double

Lengtegraad

☐

Longitude (used by Google maps).

MainContact

guid

Hoofdcontact

☐

Reference to main contact person.

Modified

datetime

Gewijzigd

☐

Last modified date.

ModifiedUtc

datetime

Gewijzigd (UTC)

☐

Last modified date in UTC.

Modifier

guid

Wijziger

☐

User ID of modifier.

ModifierFullName

string

Gewijzigd Volledige Naam

☐

Name of modifier.

Name

string

Naam

☐

Account name.

OINNumber

string

OIN Nummer

☐

Dutch government identification number.

Parent

guid

Moeder

☐

ID of the parent account.

PayAsYouEarn

string

Pay-as-you-Earn

☐

Indicates the loan repayment plan for UK legislation.

PaymentConditionPurchase

string

Betalingsvoorwaarde Inkoop

☐

Code of default payment condition for purchase.

PaymentConditionPurchaseDescription

string

Betalingsvoorwaarde Inkoop Omschrijving

☐

Description of PaymentConditionPurchase.

PaymentConditionSales

string

Betalingsvoorwaarde Verkoop

☐

Code of default payment condition for sales.

PaymentConditionSalesDescription

string

Betalingsvoorwaarde Verkoop Omschrijving

☐

Description of PaymentConditionSales.

PeppolIdentifier

string

{res:itgen_eol_peppolidentifier}

☐

PeppolIdentifierType

int32

{res:itgen_eol_peppolidentifiertype}

☐

Phone

string

Telefoon

☐

Phone number.

PhoneExtension

string

Telefoontoestel

☐

Phone number extention.

Postcode

string

Postcode

☐

Visit address postcode.

PriceList

guid

Prijslijst

☐

Default sales price list for account.

PurchaseCurrency

string

Inkoop Munteenheid

☐

Currency of purchase.

PurchaseCurrencyDescription

string

Inkoop Valuta Omschrijving

☐

Description of PurchaseCurrency.

PurchaseLeadDays

int32

Inkoop Aanloopdagen

☐

Indicates number of days required to receive a purchase. Acts as a default.

PurchaseVATCode

string

Aankoop BTW Code

☐

Default VAT code used for purchase entries.

PurchaseVATCodeDescription

string

Inkoop BTW Code Omschrijving

☐

Description of PurchaseVATCode.

RecepientOfCommissions

boolean

Ontvanger van de Commissies

☐

Define the relation that should be taken in the official document of the rewarding fiscal fiches Belcotax.

Remarks

string

Aantekeningen

☐

Remarks.

Reseller

guid

Wederverkoper

☐

ID of the reseller account. Conditions: the target account must have the property IsReseller turned on.

ResellerCode

string

Wederverkoper Code

☐

Code of Reseller.

ResellerName

string

Wederverkoper Naam

☐

Name of Reseller.

RSIN

string

RSIN Nummer

☐

Fiscal number for NL legislation.

SalesCurrency

string

Verkoop Munteenheid

☐

Currency of Sales used for Time & Billing.

SalesCurrencyDescription

string

Verkoopvaluta Omschrijving

☐

Description of SalesCurrency.

SalesTaxSchedule

guid

Verkoopbelastingschema

☐

Obsolete.

SalesTaxScheduleCode

string

Verkoop BTW Schema Code

☐

Obsolete.

SalesTaxScheduleDescription

string

Verkoopbelastingschema Omschrijving

☐

Obsolete.

SalesVATCode

string

Verkoop BTW Code

☐

Default VAT code for a sales entry.

SalesVATCodeDescription

string

Verkoop BTW Code Omschrijving

☐

Description of SalesVATCode.

SearchCode

string

Zoekcode

☐

Search code.

SecurityLevel

int32

Beveiligingsniveau

☐

Security level (0 - 100).

SeparateInvPerProject

int16

Aparte Factuur per Project

☑

Separate invoice per project (Time & Billing).

SeparateInvPerSubscription

int16

Aparte Factuur per Abonnement

☑

Indicates how invoices are generated from subscriptions. 0 = subscriptions belonging to the same customer are combined in a single invoice. 1 = each subscription results in one invoice. In both cases, each individual subscription line results in one invoice line.

ShippingLeadDays

int32

Verschepen Aanloopdagen

☐

Indicates the number of days it takes to send goods to the customer. Acts as a default.

ShippingMethod

guid

Verzendwijze

☐

Default shipping method.

ShowRemarkForSales

boolean

Toon opmerking voor verkoop

☐

Indicates whether to display Ordered by account's remarks when creating a new sales order.

Source

int16

Bron

☐

StartDate

datetime

Startdatum

☐

Indicates in combination with the end date if the account is active.

State

string

Provincie

☐

State/Province/County code When changing the Country and the State is filled, the State must be assigned with a valid value from the selected country or set to empty.

StateName

string

Provincie

☐

Name of State.

Status

string

Status

☐

If the status field is filled this means the account is a customer. The value indicates the customer status. Possible values: A=None, S=Suspect, P=Prospect, C=Customer.

StatusSince

datetime

Status sinds

☐

Obsolete.

TradeName

string

Handelsnaam

☐

Trade name can be registered and shown with the client (for all legislations).

Type

string

Soort

☐

Account type: Values: A = Relation, D = Division.

UniqueTaxpayerReference

string

Unieke Referentie Belastingplichtige

☐

Unique taxpayer reference for UK legislation.

VATLiability

string

BTW Passiva

☐

Indicates the VAT status of an account to be able to identify the relation that should be selected in the VAT debtor listing in Belgium.

VATNumber

string

BTW-nummer

☐

The number under which the account is known at the Value Added Tax collection agency.

Website

string

Website

☐

Website of the account.