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.

Parents
  • 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 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.

Reply Children
No Data