Mahmoud AlSaadi gives us a nice Analytical Accounting GL Accounts and Dimensions Assignment Details –SQL View.
Dynamics GP Essentials: Analytical Accounting GL Accounts and Dimensions Assignment Details –SQL View
General Ledger & FinancialsSQL & Data
Archived post from 2014. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.