Adding SQL fields to CRM screens

There are some fields that exist in the MS-SQL tables but are not visible on the CEM customization screens. I am trying to add the filed dbo.Company.Comp_UpdateDate to make it visible and searchable in CRM through the company find and grid screens but it is not available to add. Can it be made available? if so how is that done?

Parents
  • There are a set of fields in the database that are designed to be hidden and maintained only by the system.  These include

    xxxx_CreatedBy
    xxxx_CreatedDate
    xxxx_UpdatedBy
    xxxx_UpdatedDate
    xxxx_TimeStamp
    xxxx_Deleted

    The primary key e.g. comp_companyid is also hidden.  What is the need for accessing this data in the interface?

  • in reply to Sage CRM

    The users wants to know when this records was last updated to allow them to focus on records that have not been updated in a long time.

Reply Children