lcarness 11/19/2018 5:59:58 PM

Add SQL DB name to a GP Query

Does anyone have code that will help me add the 5 char DB name to all of the results of a Query of GP tables. 

If I query the CMPANYID from  SY00100 I get 1, then I go to Dyanmics  SY01500 and I look up 1 and I can get the long Company Name. But then I have no common fields to join the name to any other selected items.  Even if it worked, all I really want is the 5 Digit Database Name. 

Any help would be appreciated. 

 

Thank you

 

 

Version: GP 2013
Section: Dynamics GP, SQL for Beginners, SQL Scripts


Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3