Even geduld a.u.b...

Endpoint

Accounts

Good to know

This entity supports webhooks.

This API allows to filter only on specific fields. Below you can see per field if it can be filtered on or not.
When you filter on a key field, there are two syntaxes possible which are both supported. In the example usage section you can see the two syntaxes which are supported.

Scope

Crm accounts

URI

/api/v1/{division}/crm/Accounts

Example usage

/api/v1/{division}/crm/Accounts

/api/v1/{division}/crm/Accounts

/api/v1/{division}/crm/Accounts

/api/v1/{division}/crm/Accounts

/api/v1/{division}/crm/Accounts

Properties

	Name ↑↓	Mandatory ↑↓	Value	Value	Type ↑↓	Webhook ↑↓	Filter ↑↓	Description ↑↓
	ID	False			Edm.Guid			Primary key
	Accountant	False			Edm.Guid			Reference to the accountant of the customer. Conditions: The referred accountant must have value > 0 in the field IsAccountant
	AccountManager	False			Edm.Guid			ID of the account manager
	AccountManagerFullName	False			Edm.String			Name of the account manager
	AccountManagerHID	False			Edm.Int32			Number of the account manager
	ActivitySector	False			Edm.Guid			Reference to Activity sector of the account
	ActivitySubSector	False			Edm.Guid			Reference to Activity sub-sector of the account
	AddressLine1	False			Edm.String			Visit address first line
	AddressLine2	False			Edm.String			Visit address second line
	AddressLine3	False			Edm.String			Visit address third line
	AddressSource	False			Edm.Byte			CRM creation source
	AutomaticProcessProposedEntry	False			Edm.Byte			Automatically create entries for complete entry proposals
	BankAccounts	False			BankAccounts			Collection of Bank accounts
	Blocked	False			Edm.Boolean			Indicates if the account is blocked
	BRIN	False			Edm.Guid			Obsolete
	BSN	False			Edm.String			Citizen Service Number for the Netherlands
	BusinessType	False			Edm.Guid			Reference to the business type of the account
	CanDropShip	False			Edm.Boolean			Indicates the default for the possibility to drop ship when an item is linked to a supplier
	ChamberOfCommerce	False			Edm.String			Chamber of commerce number
	City	False			Edm.String			Visit address City
	Classification	False			Edm.String			Obsolete
	Classification1	False			Edm.Guid			Account classification 1
	Classification2	False			Edm.Guid			Account classification 2
	Classification3	False			Edm.Guid			Account classification 3
	Classification4	False			Edm.Guid			Account classification 4
	Classification5	False			Edm.Guid			Account classification 5
	Classification6	False			Edm.Guid			Account classification 6
	Classification7	False			Edm.Guid			Account classification 7
	Classification8	False			Edm.Guid			Account classification 8
	ClassificationDescription	False			Edm.String			Obsolete
	Code	False			Edm.String			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	False			Edm.String			Code under which your own company is known at the account
	CompanySize	False			Edm.Guid			Reference to Company size of the account
	ConsolidationScenario	False			Edm.Byte			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	False			Edm.DateTime			Date of the latest control of account data with external web service
	Costcenter	False			Edm.String			Obsolete
	CostcenterDescription	False			Edm.String			Obsolete
	CostPaid	False			Edm.Byte			Obsolete
	Country	False			Edm.String			Country code
	CountryName	False			Edm.String			Country name
	Created	False			Edm.DateTime			Creation date
	Creator	False			Edm.Guid			User ID of creator
	CreatorFullName	False			Edm.String			Name of creator
	CreditLinePurchase	False			Edm.Double			Maximum amount of credit for Purchase. If no value has been defined, there is no credit limit
	CreditLineSales	False			Edm.Double			Maximum amount of credit for sales. If no value has been defined, there is no credit limit
	Currency	False			Edm.String			Obsolete
	CustomerSince	False			Edm.DateTime			Obsolete
	CustomField	False			Edm.String			Custom field endpoint. Provided only for the Exact Online Premium users.
	DatevCreditorCode	False			Edm.String			DATEV creditor code for Germany legislation
	DatevDebtorCode	False			Edm.String			DATEV debtor code for Germany legislation
	DeliveryAdvice	False			Edm.Byte			Indicates how deliveries are handled. Values: 0 = Partial, orders can be delivered partial, 1 = Complete the order needs to be complete to deliver, 2 = Partial without backorder when deliver partially the remainder of the order is completed without delivery
	DiscountPurchase	False			Edm.Double			Default discount percentage for purchase. This is stored as a fraction. ie 5.5% is stored as .055
	DiscountSales	False			Edm.Double			Default discount percentage for sales. This is stored as a fraction. ie 5.5% is stored as .055
	Division	False			Edm.Int32			Division code
	Document	False			Edm.Guid			Obsolete
	DunsNumber	False			Edm.String			Obsolete
	Email	False			Edm.String			E-Mail address of the account
	EnableSalesPaymentLink	False			Edm.Boolean			Indicates whether payment link is activated for sales
	EndDate	False			Edm.DateTime			Determines in combination with the start date if the account is active. If the current date is > end date the account is inactive
	EORINumber	False			Edm.String			EORI number
	EstablishedDate	False			Edm.DateTime			RegistrationDate
	Fax	False			Edm.String			Fax number
	GLAccountPurchase	False			Edm.Guid			Default (corporate) GL offset account for purchase (cost)
	GLAccountSales	False			Edm.Guid			Default (corporate) GL offset account for sales (revenue)
	GLAP	False			Edm.Guid			Default GL account for Accounts Payable
	GLAR	False			Edm.Guid			Default GL account for Accounts Receivable
	GlnNumber	False			Edm.String			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	False			Edm.Boolean			Indicates whether a customer has withholding tax on sales
	IgnoreDatevWarningMessage	False			Edm.Boolean			Suppressed warning message when there is duplication on the DATEV code
	IncotermAddressPurchase	False			Edm.String			Address of Incoterm for Purchase
	IncotermAddressSales	False			Edm.String			Address of Incoterm for Sales
	IncotermCodePurchase	False			Edm.String			Code of Incoterm for Purchase
	IncotermCodeSales	False			Edm.String			Code of Incoterm for Sales
	IncotermVersionPurchase	False			Edm.Int16			Version of Incoterm for Purchase Supported version for Incoterms : 2010, 2020
	IncotermVersionSales	False			Edm.Int16			Version of Incoterm for Sales Supported version for Incoterms : 2010, 2020
	IntraStatArea	False			Edm.String			Intrastat Area
	IntraStatDeliveryTerm	False			Edm.String			Intrastat delivery method
	IntraStatSystem	False			Edm.String			System for Intrastat
	IntraStatTransactionA	False			Edm.String			Transaction type A for Intrastat
	IntraStatTransactionB	False			Edm.String			Transaction type B for Intrastat
	IntraStatTransportMethod	False			Edm.String			Transport method for Intrastat
	InvoiceAccount	False			Edm.Guid			ID of account to be invoiced instead of this account
	InvoiceAccountCode	False			Edm.String			Code of InvoiceAccount
	InvoiceAccountName	False			Edm.String			Name of InvoiceAccount
	InvoiceAttachmentType	False			Edm.Int32			Indicates which attachment types should be sent when a sales invoice is printed. Only values in related table with Invoice=1 are allowed
	InvoicingMethod	False			Edm.Int32			Method of sending for sales invoices. Values: 1: Paper, 2: EMail, 4: Mailbox (electronic exchange), 8: Send and track, 32: Send via Peppol Take notes: To use the '4 - Mailbox (electronic exchange)' option, the 'Mailbox' feature set is required in the licence. To use the '32 - Send via Peppol' option, e-invoicing via Peppol must be activated
	IsAccountant	False			Edm.Byte			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	False			Edm.Byte			Indicates whether the accounti is an agency
	IsAnonymised	False			Edm.Byte			Indicates whtether the account is anonymised.
	IsBank	False			Edm.Boolean			Obsolete
	IsCompetitor	False			Edm.Byte			Indicates whether the account is a competitor
	IsExtraDuty	False			Edm.Boolean			Indicates whether a customer is eligible for extra duty
	IsMailing	False			Edm.Byte			Indicates if the account is excluded from mailing marketing information
	IsMember	False			Edm.Boolean			Obsolete
	IsPilot	False			Edm.Boolean			Indicates whether the account is a pilot account
	IsPurchase	False			Edm.Boolean			Obsolete
	IsReseller	False			Edm.Boolean			Indicates whether the account is a reseller
	IsSales	False			Edm.Boolean			Indicates whether the account is allowed for sales
	IsSupplier	False			Edm.Boolean			Indicates whether the account is a supplier
	Language	False			Edm.String			Language code
	LanguageDescription	False			Edm.String			Language description
	Latitude	False			Edm.Double			Latitude (used by Google maps)
	LeadPurpose	False			Edm.Guid			Reference to Lead purpose of an account
	LeadSource	False			Edm.Guid			Reference to Lead source of an account
	Logo	False			Edm.Binary			Bytes of the logo image
	LogoFileName	False			Edm.String			The file name (without path, but with extension) of the image
	LogoThumbnailUrl	False			Edm.String			Thumbnail url of the logo
	LogoUrl	False			Edm.String			Url to retrieve the logo
	Longitude	False			Edm.Double			Longitude (used by Google maps)
	MainContact	False			Edm.Guid			Reference to main contact person
	Modified	False			Edm.DateTime			Last modified date
	Modifier	False			Edm.Guid			User ID of modifier
	ModifierFullName	False			Edm.String			Name of modifier
	Name	True			Edm.String			Account name
	OINNumber	False			Edm.String			Dutch government identification number
	Parent	False			Edm.Guid			ID of the parent account
	PayAsYouEarn	False			Edm.String			Indicates the loan repayment plan for UK legislation
	PaymentConditionPurchase	False			Edm.String			Code of default payment condition for purchase
	PaymentConditionPurchaseDescription	False			Edm.String			Description of PaymentConditionPurchase
	PaymentConditionSales	False			Edm.String			Code of default payment condition for sales
	PaymentConditionSalesDescription	False			Edm.String			Description of PaymentConditionSales
	PeppolIdentifier	False			Edm.String			Peppol identifier user entered manually, corresponds to picked peppol adress
	PeppolIdentifierType	False			Edm.Int32			Peppol identifier type that user picked manually - GLN, COC, etc
	Phone	False			Edm.String			Phone number
	PhoneExtension	False			Edm.String			Phone number extention
	Postcode	False			Edm.String			Visit address postcode
	PriceList	False			Edm.Guid			Default sales price list for account
	PurchaseCurrency	False			Edm.String			Currency of purchase Take notes: If the currency code input is not in the active currencies, the value will be set to empty.
	PurchaseCurrencyDescription	False			Edm.String			Description of PurchaseCurrency
	PurchaseLeadDays	False			Edm.Int32			Indicates number of days required to receive a purchase. Acts as a default
	PurchaseVATCode	False			Edm.String			Default VAT code used for purchase entries
	PurchaseVATCodeDescription	False			Edm.String			Description of PurchaseVATCode
	RecepientOfCommissions	False			Edm.Boolean			Define the relation that should be taken in the official document of the rewarding fiscal fiches Belcotax
	Remarks	False			Edm.String			Remarks
	Reseller	False			Edm.Guid			ID of the reseller account. Conditions: the target account must have the property IsReseller turned on
	ResellerCode	False			Edm.String			Code of Reseller
	ResellerName	False			Edm.String			Name of Reseller
	RSIN	False			Edm.String			Fiscal number for NL legislation
	SalesCurrency	False			Edm.String			Currency of Sales used for Time & Billing Take notes: If the currency code input is not in the active currencies, the value will be set to empty.
	SalesCurrencyDescription	False			Edm.String			Description of SalesCurrency
	SalesTaxSchedule	False			Edm.Guid			Obsolete
	SalesTaxScheduleCode	False			Edm.String			Obsolete
	SalesTaxScheduleDescription	False			Edm.String			Obsolete
	SalesVATCode	False			Edm.String			Default VAT code for a sales entry
	SalesVATCodeDescription	False			Edm.String			Description of SalesVATCode
	SearchCode	False			Edm.String			Search code
	SecurityLevel	False			Edm.Int32			Security level (0 - 100)
	SeparateInvPerProject	False			Edm.Byte			Separate invoice per project (Time & Billing)
	SeparateInvPerSubscription	False			Edm.Byte			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	False			Edm.Int32			Indicates the number of days it takes to send goods to the customer. Acts as a default
	ShippingMethod	False			Edm.Guid			Default shipping method
	ShowRemarkForSales	False			Edm.Boolean			Indicates whether to display Ordered by account's remarks when creating a new sales order
	Source	False			Edm.Byte			CRM creation source
	StartDate	False			Edm.DateTime			Indicates in combination with the end date if the account is active
	State	False			Edm.String			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	False			Edm.String			Name of State
	Status	False			Edm.String			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	False			Edm.DateTime			Obsolete
	TradeName	False			Edm.String			Trade name can be registered and shown with the client (for all legislations)
	Type	False			Edm.String			Account type: Values: A = Relation, D = Division
	UniqueTaxpayerReference	False			Edm.String			Unique taxpayer reference for UK legislation
	VATLiability	False			Edm.String			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	False			Edm.String			The number under which the account is known at the Value Added Tax collection agency
	Website	False			Edm.String			Website of the account

Returns