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