Dewayne

Have you seen lead_personfullname used in the interface anywhere? I think this field is an 'artifact' - it has a partial definition but it is not useable.

I am using Sage CRM 7.2d

I can see it declared as a field in the Admin Customisation area for Leads. This tells me that there is an entry in the custom_edits meta data table.

You can check for a field definition in SQL using

select * from custom_edits where colp_colname like '%Lead_personfullname%'

But there are no references to the field in any list or screen.

select * from custom_screens where seap_colname like '%Lead_personfullname%'

select * from custom_lists where grip_colname like '%Lead_personfullname%'

Both queries return null.

The key proof that this is an useable field is that the physical column Lead_personfullname does not exist in the Lead table and it is not defined as a derived column in a view. There is not reference to it in any view defined in Sage CRM.

select * from custom_views where cuvi_viewscript like '%Lead_personfullname%'

Hey Jeff,

Thanks for the response. it is very helpful for me to learn how and where to look for things like this as I learn this software. I am pretty familiar at this point with 100 ERP but the CRM side is still pretty new. All that being said, I still have the other part of my question I am trying to figure out. I would like to combine the first and last names into a field for display on the leads list screen. What would be the suggested way to go about doing this?

Also to start down a different path I did not realize there were updates to CRM (we are still on 7.2b). Is there a place where I can see what updates/enhancements have been made to the software? Is there differences in those updates since we are integrated with ERP?