Browse By Tags
Home
»
All Tags
»
Company
»
Views
address
Address_Link
ASP
COM
com api
CRMEmailPhoneData
Email
eWareQuery Object
insert
joins
Meta Data
newproduct
OrderItems
orders
Person
phone
QuoteItems
quotes
Reports
SQL
triggers
uom
uomfamily
Web Services
webservices
Blog Post:
Working with Default Company Addresses
Jeff Richards
If you need to list company default/main addresses you can link from the Company to the Address table. You don't need to link to the address_link table. The address link table is used to keep details about the alternative addresses that might be stored against a company, e.g. billing and delivery...
on
25 Jun 2012
Blog Post:
Using Joins in Web Services
Jeff Richards
Imagine you need to retrieve information from CRM via the webservices interface; this query should combine data from multiple tables. In the COM API (ASP pages, self service, table level scripts etc) you could use the QueryObject to build the exact SQL you need. var mySQL = "SELECT Person.*,...
on
9 Jun 2009
Blog Post:
Understanding the CRMEmailPhoneData table
Jeff Richards
If you have spent time looking at the way in which views are constructed in Sage CRM then you may have found the CRMEmailPhoneData table referenced and wondered what is the table's purpose. I asked a colleague in our development team for some help in explaining the table and the following information...
on
19 Jun 2015
Blog Post:
Why do Phone numbers appear in the Company and Person screens when they are stored in the Phone table?
Jeff Richards
This is a follow up to the article I wrote previously called " Understanding the CRMEmailPhoneData table ". That article explained that the CRMEmailPhoneData is a utility table and that it's job is to speed up reports. It holds a row for each company or person with that company or persons...
on
24 Jun 2015
Blog Post:
Hold the Phone! A round up of articles that discuss Phone Numbers and Email addresses in Sage CRM
Jeff Richards
In Sage CRM development around phone numbers and email addresses needs careful thought. This is because Sage CRM "entities" can be complex. For example the information for a Company consists of a company record, a default person record and a default address. Both the company and the default...
on
24 Jun 2015