[vinayvnair]

Hi,

Can any one explain me the difference between customers, companies and entity views. I see similar data in multiple tables and am confused which to pick up? What is the difference between customers and companies mainly as entity i belive has employees, partners and other relationship also?

Can somebody help on this?

Vinay…
This is a cached copy. Click here to see the original post.

[marcello.antolino]

Hi Vinay;

I don’t have the full knowledge of it, but we’ve been using the CUSTOMERS view for pulling customer information, regradless of status (lead, won, etc – use CATEGORY_0 field for that).

Companies view have also vendor information, not only your customers. It might have other stuff too, but since what we needed was the customer info, I stopped right there. Perform this query, it might help you:

select * from companies where company_id not in (select customer_id from customers)

Let me know if that helps…

Regards,

[Author]

Posts