Does anybody know which table are the descriptions of the codes for selection lists kept in? I am writing an SQL query to get some information for a report that is going to be outside of Sage CRM
For example I have this lookup table setup in the communication table:
In the communication record, the system only keeps the code.
How do I get to the description mapping of "Blog" for this code?
Please and thank you!
You join the tables on the code in the field to the capt_code. But you also join on the capt_family and you select the language so capt_uk or capt_us