SQL Scripts for Microsoft Dynamics GP: List Bank Accounts with Linked GL Accounts

This script is part of the SQL Scripts for Microsoft Dynamics GP where I will be posting the scripts I wrote against Microsoft Dynamics GP over the 19 years before I stopped working with Dynamics GP.

This script was created for a client who had quite a few bank accounts and want to quickly check which G/L Accounts were linked to each bank account.

/*
Created by Ian Grieve of azurecurve | Ramblings of an IT Professional (http://www.azurecurve.co.uk)
This code is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International (CC BY-NC-SA 4.0 Int).
*/
SELECT

	CM.CHEKBKID

	,CM.DSCRIPTN

	,GL105.ACTNUMST

	,GL100.ACTDESCR

FROM

	CM00100 AS CM WITH (NOLOCK) --CM Checkbook Master (CM00100)
INNER JOIN

	GL00100 AS GL100 WITH (NOLOCK) --Breakdown Account Master (GL00100)
		ON GL100.ACTINDX = CM.ACTINDX

INNER JOIN

	GL00105 AS GL105 WITH (NOLOCK) --Account Index Master (GL00105)
		ON GL105.ACTINDX = CM.ACTINDX

Read original post SQL Scripts for Microsoft Dynamics GP: List Bank Accounts with Linked GL Accounts at azurecurve|Ramblings of an IT Professional