Category Archives: Tables

How to Exclude Auto-Opportunities created in Sage CRM?

Sage CRM’s Opportunities is the heart of every potential sale done with the Customer. These opportunities further helps to track/maintain the Quotations and Orders raised against the Sale. However, CRM’s feature of allowing the Users to create direct Quotes or Orders in CRM is also not left unnoticed, which can help the Users to maintain… Read More »

Get Size of all Tables in CRM Database

For any database driven application, it is very important that the database must be optimized to the best so as to deliver higher performance. As the data volume in database increases, load on the system also increases which affects the performance on the system which in turn affects the client’s business. For business application like… Read More »

Table Level Scripts Logging and Performance

In SageCRM, Table level script can be used for replicating SQL trigger like functionality.  Table level scripts help us handle the data update events properly and do corresponding actions within SageCRM. The beauty of it is we can use SageCRM API and write server side JavaScript like functionality to function similar to that of triggers.… Read More »

Sage CRM Database Maintenance

Database is the most important part of any application. Being business software, Sage CRM handles very delicate data and it is necessary to maintain this data properly in order to insure integrity and improved system performance. New Stuff: Confirm if your Sage CRM system has actually expired There are many ways to enhance the performance… Read More »

Retrieve Primary Keys in TLS

Table Level Scripts (TLS) are an alternative method of creating SQL triggers that can be performed in Sage CRM system. Table Level Script (TLS) are used to perform various operations after inserting records, updating or deleting records in Sage CRM. To perform operations, it is necessary to fetch the primary ID of the current entity in… Read More »

Quick look on Sage CRM tables

In this blog we will have a quick look at some of the important and essential tables of Sage CRM. GUMU : Integrate your Sage 500 ERP system with latest Sage CRM – Realtime In Sage CRM, entity data is stored into the tables with identical name. For example, 1. Company entity data is stored into the… Read More »