Table Accounts (customers)

Questions
,
1

Which table should I use to read the customers from Exact Online? CRM.Accounts, XML.Accounts, or another one?

2

Als het gaat om het ophalen van alle relaties, dan is het advies gebruik te maken van:

AccountsIncremental

De meestgebruikte Exact Online-tabellen zijn te vinden in:

3

En enkel de klanten? Want hier zitten ook leveranciers in.

4

In Exact kan eenzelfde partij meerdere rollen hebben. De verschillende indelingen zijn te vinden in deze situatie in de 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’.
5

This question has been automatically closed after 1 week of inactivity. The last given answer has been marked as the solution.

Please post a new question in a separate topic if the issue occurs again. In the new question, please include a link to this topic by pasting its URL into the text.