/********************************************************************************
 *    
 * Program Name:        Chart_Of_Account.sql
 *
 * Program Description:  Shows account combinations
 *
 * Usage: See description
 *
 * Author: Justin Setliffe
 *
 * Date: 07/29/2004
 *****************************************************************************/
-- Table listing:
-- A - GLMASTER		B - GLSYSTEM	C - GLNAMES
-- D - GLCHARTDTL	E - GLSUBACDTL

SELECT 
a.company AS 'Company', 
a.acct_unit AS 'Account Unit', 
a.account AS 'Account', 
a.sub_account AS 'Sub Account',
b.name AS 'Name', 
e.description AS 'Description', 
d.account_desc AS 'Account Description'

FROM glmaster a
	LEFT JOIN glsystem b ON a.company = b.company
	LEFT JOIN glnames c ON c.company = a.company AND c.acct_unit = a.acct_unit
	LEFT JOIN glchartdtl d ON d.account = a.account AND d.sub_account = a.sub_account
	LEFT JOIN glsubacdtl e ON e.sub_account = a.sub_account

ORDER BY 
a.company, 
a.acct_unit, 
a.account, 
a.sub_account