GL Account and its Currencies

I found a question in MicrosoftDynamicsForums, the user was searching the GL tables for account currencies, while the account currencies does not sorted under the GL series, instead it stored in MC0020, below view to return the needed result:

SELECT     dbo.GL00105.ACTNUMST, dbo.GL00100.ACTDESCR, dbo.MC00200.CURNCYID
FROM         dbo.GL00100 INNER JOIN
                      dbo.GL00105 ON dbo.GL00100.ACTINDX = dbo.GL00105.ACTINDX INNER JOIN
                      dbo.MC00200 ON dbo.GL00100.ACTINDX = dbo.MC00200.ACTINDX
ORDER BY dbo.GL00105.ACTNUMST

Regards,
--
Mohammad R. Daoud - CTO
MVP, MCP, MCT, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85 
mohdaoud@gmail.com
mohdaoud.blogspot.com