0

I have the following query:

select act.Division 
,      act.DivisionName
,      act.code
,      act.name
,      act.status
,      acs.description
,      act.IsSupplier
,      act.IsSales
from   exactonlinerest..accounts act
left
outer
join   accountcustomerstatuses acs
on     acs.code = act.status
order
by     Division
,      code

Some results give back a status of C (customer) and a true on supplier. IsSales is sometimes true and sometimes false.

I am confused about the meaning of these values. The documentation is not clear on the purpose.

Would that account be both a customer AND a supplier?

What is the meaning of issales?

Goombah
  • 2,835
  • 2
  • 12
  • 22

1 Answers1

1

See answer on documentation:

Each counterparty 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 'AccountStatuses'.
  • 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'.
Guido Leenders
  • 4,232
  • 1
  • 23
  • 43