Method Community

 

Wait...there is an Entity table?

Last post 02-12-2016 12:04 PM by Sixtel. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 02-12-2016 10:54 AM

    • Sixtel
    • Top 200 Contributor
    • Joined on 12-18-2015
    • charleston
    • Posts 27

    Wait...there is an Entity table?

    Hi all!

    So, I have just found out that there is an Entity table that seems to hold everything that is in the Customer table and the Contact table?

    Im having trouble understandthing the function of this table, specifically I am having throuble understanding which table i need to be working in when. I have added a bunch of stuff to my Customer table, but should I really have added all that to the entity table? Should i build my grid views on the entity table, or the customer table?

    thanks!

  • 02-12-2016 11:59 AM In reply to

    Re: Wait...there is an Entity table?

    Answer

    Hello Sixtel,

    The entity table is a special table :) It encompasses the Customer, Vender, Employee and Other name tables into one. So you can think of it as the Customer being a ‘subset’ of the Entity table for instance. The reason this is done is so that you can for example be able to write a check to an employee, to a vendor or even to your customer in the case of a refund.  If the entity table didn't exist then you wouldn't be able to do that and my many other cross-table functionality that is possible. It is done this way behind the scene in QuickBooks as well. The entity table cannot be modified, instead modification can be done to the 'subset' tables.

    Contact is not a subset of Entity.  The Contacts table is a Method only table.  It has linked fields from the Entity table, but they are separate fields.  The Contacts table hold all of your contacts and does not sync to QuickBooks.

    Think of using the Entity table for data retrieval. So if you have a dropdown and for instance you wanted to filter vendor and employee then you can use the Entity table and show all your vendors and Employees, otherwise you wouldn't be able to see both types in one dropdown. For data entry it is best if you use the specific or 'subset' tables.

     It is not recommended that you create a screen based off entity table. It would be best if you did that via the subset tables.

    -Inder

  • 02-12-2016 12:04 PM In reply to

    • Sixtel
    • Top 200 Contributor
    • Joined on 12-18-2015
    • charleston
    • Posts 27

    Re: Wait...there is an Entity table?

    Excellent! thank you!

Page 1 of 1 (3 items)