1 of 1 people found this helpful
Additional contacts are stored in the CONTSUPP table with a rectype value of C. Here is a simple query for listing them:
select * from contsupp where rectype = 'C'
The field in CONTSUPP that stores what shows in the GM Interface as "Mobile" is actually the FAX field. It goes back to the older days, when they had that field labeled fax. They changed the label some years back, but did NOT change the DB field name to coincide with the label.
Hope this feedback helps.
Perfect! Thanks John.
I read that they changed the ui label from Fax to Mobile. It didn't dawn on me that they would leave the db field name as Fax.
they do try to keep database fields on the back-end backwards compatible as much as possible. While this can cause some surprises, it does help to keep integration, 3rd party tools, etc. as compatible as possible -- even with newer versions of GoldMine.