Overview
Some things to be aware of:- A company in the SuperOffice UI has its information stored in the
contacttable, with its relations. - A contact in the SuperOffice UI has its information stored in the
persontable, with its relations.
Company
The database reference for company interests are found here:
Contact
The database reference for contact interests are found here:
Detailed
This section delves deeper into company interests, omitting details of contact interests, as their functionality mirrors that of company interests. The link table (contactinterest) allows a single contact to have zero or more interests checked off. The ContInt table is an MDO table, so interests can be grouped and organized under headings. The position under a heading doesn’t affect the linkage to a contact.For headings to show, there must be a minimum number of interests defined in Settings and maintenance. To set or check this number, go to the Preferences screen > Grouped lists > Company Interest. If no value is specified for this setting, the system defaults to 7.The same preference can be found for contact interests at Preferences screen > Grouped lists > Contact Interest.
You can extend the list of interests for a company by creating and adding a new interest to that list.
Contact cached value
Thecontact table has a counter field that stores the number of active interests. This field is used to cache the count. It is updated whenever the user edits the company. The field is used to check whether the Interests tab needs to indicate the presence of interests or not.