Is there a downloadable Sage CRM Data Dictionary?

Looking for a downloadable data dictionary for all Sage products but specifically Sage CRM that shows fields with data type, definition, values, table, schema, etc.

  • 0

    Hi Lacy

    We do not produce one.  You can use the MS SQL Server Management Studio to interrogate the Sage CRM database directly to report on the structures.  The metadata that describes the fields in the interface can also be reported on.

  • 0

    Hi LaceyB

    As Sage CRM says there isn't anything out of the box that will do it, but the follow query will quickly give you some information that you're looking for. 

    SELECT colp_entity AS [Entity], CC2.capt_uk AS [Column Name],colp_colname AS [Database Name], CC1.capt_uk AS [Data Type],
    ColP_EntrySize AS [Entry Width], ColP_LookupFamily AS [Lookup Family], ColP_DataSize AS [Max Data], ColP_DefaultValue AS [Default Value]
    FROM Custom_Edits
    JOIN Custom_Captions CC1 ON CC1.capt_code = ColP_EntryType AND CC1.capt_family = 'EntryType'
    JOIN Custom_Captions CC2 ON CC2.capt_code = ColP_colname AND CC2.capt_family = 'ColNames'
    ORDER BY ColP_Entity, CC2.capt_UK

  • 0 in reply to Sage CRM

    In the 2023 R2 release documentation, I was able to locate an Excel file "Database Changes in Sage CRM 2023 R2.xlsx" that listed what I am looking for. Looking for a comprehensive list of current fields. If this isn't available now, 1) can it be requested for future purposes; 2) Is it possible to access something similar within CRM?

  • 0 in reply to Matthew Shaw

    Thank you! This is an amazing start! In the 2023 R2 release documentation, I was able to locate an Excel file "Database Changes in Sage CRM 2023 R2.xlsx" that listed additional details such as description. Inquired about a comprehensive version of this in my reply to Sage CRM above.