Accounts: Exact Online Relaties |
Legal counter parties such as customers, suppliers and prospects.
Catalogus: ExactOnlineREST
Schema: CRM
Primaire Sleutels: ID
Label: Relaties
Documentatie:
Each counter party is registered at most once as an account. Their type can be determined using a number of methods:
- Customer: the column 'Status' has the value 'C' when the account is a customer. The meaning of the status codes is described in the table 'AccountCustomerStatuses'.
- Prospect: the column 'Status' has the value 'P' when the account is a prospect.
- Suspect: the column 'Status' has the value 'S' when the account is a suspect.
- Reseller: the column 'IsReseller' has the boolean value 'true'.
- Supplier: the column 'IsSupplier' has the boolean value 'true'.
- Accountant: the column 'IsAccountant' has the boolean value 'true'.
- Competitor: the column 'IsCompetitor' has the boolean value 'true'.
De gegevens in deze tabel zijn gepartitioneerd per waarde van de kolom Division.
Kan gegevens ophalen en wijzigen met behulp van toevoegen, bijwerken en verwijderen.
Tabelkolommen
De kolommen van de tabel Accounts worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.
Naam |
Datatype |
Label |
Verplicht |
Documentatie |
---|---|---|---|---|
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(240) |
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(30) |
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(18) |
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(20) |
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(8) |
Kostenplaats |
☐ |
Obsolete. |
CostcenterDescription |
string(60) |
Kostenplaats Omschrijving |
☐ |
Obsolete. |
CostPaid |
int16 |
Kosten Betaald |
☐ |
Obsolete. |
Country |
string(30) |
Land |
☐ |
Country code. |
CountryName |
string(60) |
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(240) |
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(30) |
Valuta |
☐ |
Obsolete. |
CustomerSince |
datetime |
Klant Sinds |
☐ |
Obsolete. |
CustomField |
string |
{res:itgen_eol_customfield} |
☐ |
|
DatevCreditorCode |
string(30) |
DATEV Crediteurcode |
☐ |
DATEV creditor code for Germany legislation. |
DatevDebtorCode |
string(30) |
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 |
☐ |
Division code. |
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(9) |
DUNS Nummer |
☐ |
Obsolete. |
string(128) |
☐ |
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(25) |
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(13) |
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(5) |
Intrastat Systeem |
☐ |
System for Intrastat. |
IntraStatTransactionA |
string(1) |
Intrastat Transactie A |
☐ |
Transaction type A for Intrastat. |
IntraStatTransactionB |
string(1) |
Intrastat Transactie B |
☐ |
Transaction type B for Intrastat. |
IntraStatTransportMethod |
string(1) |
Intrastat Transportmethode |
☐ |
Transport method for Intrastat. |
InvoiceAccount |
guid |
Factuurrekening |
☐ |
ID of account to be invoiced instead of this account. |
InvoiceAccountCode |
string(18) |
Factuur Account Code |
☐ |
Code of InvoiceAccount. |
InvoiceAccountName |
string(50) |
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 whether 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(30) |
Taal |
☐ |
Language code. |
LanguageDescription |
string(60) |
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(240) |
Gewijzigd Volledige Naam |
☐ |
Name of modifier. |
Name |
string(50) |
Naam |
☐ |
Account name. |
OINNumber |
string(20) |
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(2) |
Betalingsvoorwaarde Inkoop |
☐ |
Code of default payment condition for purchase. |
PaymentConditionPurchaseDescription |
string(60) |
Betalingsvoorwaarde Inkoop Omschrijving |
☐ |
Description of PaymentConditionPurchase. |
PaymentConditionSales |
string(2) |
Betalingsvoorwaarde Verkoop |
☐ |
Code of default payment condition for sales. |
PaymentConditionSalesDescription |
string(60) |
Betalingsvoorwaarde Verkoop Omschrijving |
☐ |
Description of PaymentConditionSales. |
PeppolIdentifier |
string |
{res:itgen_eol_peppolidentifier} |
☐ |
|
PeppolIdentifierType |
int32 |
{res:itgen_eol_peppolidentifiertype} |
☐ |
|
Phone |
string(25) |
Telefoon |
☐ |
Phone number. |
PhoneExtension |
string(15) |
Telefoontoestel |
☐ |
Phone number extention. |
Postcode |
string(20) |
Postcode |
☐ |
Visit address postcode. |
PriceList |
guid |
Prijslijst |
☐ |
Default sales price list for account. |
PurchaseCurrency |
string(30) |
Inkoop Munteenheid |
☐ |
Currency of purchase. |
PurchaseCurrencyDescription |
string(60) |
Inkoop Valuta Omschrijving |
☐ |
Description of purchase currency. |
PurchaseLeadDays |
int32 |
Inkoop Aanloopdagen |
☐ |
Indicates number of days required to receive a purchase. Acts as a default. |
PurchaseVATCode |
string(3) |
Aankoop BTW Code |
☐ |
Default VAT code used for purchase entries. |
PurchaseVATCodeDescription |
string(60) |
Inkoop BTW Code Omschrijving |
☐ |
Description of Purchase VAT code. |
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(18) |
Wederverkoper Code |
☐ |
Code of Reseller. |
ResellerName |
string(50) |
Wederverkoper Naam |
☐ |
Name of Reseller. |
RSIN |
string(30) |
RSIN Nummer |
☐ |
Fiscal number for NL legislation. |
SalesCurrency |
string(30) |
Verkoop Munteenheid |
☐ |
Currency of Sales used for Time & Billing. |
SalesCurrencyDescription |
string(60) |
Verkoopvaluta Omschrijving |
☐ |
Description of SalesCurrency. |
SalesTaxSchedule |
guid |
Verkoopbelastingschema |
☐ |
Obsolete. |
SalesTaxScheduleCode |
string |
Verkoop BTW Schema Code |
☐ |
Obsolete. |
SalesTaxScheduleDescription |
string |
Verkoopbelastingschema Omschrijving |
☐ |
Obsolete. |
SalesVATCode |
string(3) |
Verkoop BTW Code |
☐ |
Default VAT code for a sales entry. |
SalesVATCodeDescription |
string(60) |
Verkoop BTW Code Omschrijving |
☐ |
Description of Sales VAT code. |
SearchCode |
string(15) |
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(30) |
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(60) |
Provincie |
☐ |
Name of state/province. |
Status |
string(1) |
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(50) |
Handelsnaam |
☐ |
Trade name can be registered and shown with the client (for all legislations). |
Type |
string(1) |
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(35) |
BTW-nummer |
☐ |
The number under which the account is known at the Value Added Tax collection agency. |
Website |
string(128) |
Website |
☐ |
Website of the account. |
24-06-2025 18:54 Versie 24.1.116-BETA+5455