Sage CRM

Does anyone know where the Cell Phone field is stored in the Person entity in SageCRM? I am trying to add it to a report in CRM and for the life of me can't find the table and field.

In CRM 7.1 it was un-denormalized and the phone and email were pulled off the company and person. You need to link in the phone table and link on phon_type = ""Mobile"" (or whatever you are using in your system) and phon_persondid = <current person>. You will have to create a view to handle this.

Thanks Peter. That is what I was figuring as far as having to create a view. I appreciate it. Fun with SQL...yeaah.

Hmmm...can't seem to find the column for phon_type in the Phone table. I am digging through the Phonelink table and see a Plink_type...is that possibly it? I may have to link both of those tables.

Yes - that's it. I forgot that step!

Thanks...I figured that much. It wasn't very hard to find...now just have to get the correct columns to link them together to create the view. After I create the view in SQL I have to also add it into CRM for it to recognize it for adding it to a report correct?

Yes