View: dbo.GL_Balancing_Entry_Account_List_View | |||
View definition | |||
create view dbo.GL_Balancing_Entry_Account_List_View as -- Source: check summary memos select glbenbt.gl_balancing_entry_KEY , gl_account_number_list = isnull(gla.gl_account_number, cugla_gla.gl_account_number) from ( select gl_balancing_entry_KEY, min(bank_transaction_KEY) as bank_transaction_KEY from dbo.GL_Balancing_Entry_N_Bank_Transaction group by gl_balancing_entry_KEY ) as glbenbt inner join dbo.Bank_Transaction as bt on bt.bank_transaction_KEY = glbenbt.bank_transaction_KEY inner join dbo.Checkbook as cbk on bt.checkbook_KEY = cbk.checkbook_KEY inner join dbo.Client_Undistributed_GL_Account as cugla on cugla.client_KEY = cbk.client_KEY inner join dbo.GL_Account as cugla_gla on cugla_gla.gl_account_KEY = cugla.gl_account_KEY left join dbo.GL_Account as gla on gla.gl_account_KEY = cbk.gl_account_KEY | |||