View: dbo.Consolidation_Subsidiary_Client_Transaction_Within_Period_Range_View
View definition
-- drop view dbo.Consolidation_Subsidiary_Client_Transaction_Within_Period_Range_View
create view dbo.Consolidation_Subsidiary_Client_Transaction_Within_Period_Range_View
as
select
cco.client_KEY, txn.gl_transaction_KEY, txn.journal_entry_KEY, txn.journal_entry_distribution_KEY
from
dbo.Client_Consolidation_Option as cco
inner join dbo.GL_Period as begin_glp
on begin_glp.gl_period_KEY = cco.consolidation_period_start__gl_period_KEY
inner join dbo.GL_Fiscal_Year as begin_glfy
on begin_glfy.gl_fiscal_year_KEY = begin_glp.gl_fiscal_year_KEY
inner join dbo.GL_Period as end_glp
on end_glp.gl_period_KEY = cco.consolidation_period_end__gl_period_KEY
inner join dbo.GL_Fiscal_Year as end_glfy
on end_glfy.gl_fiscal_year_KEY = end_glp.gl_fiscal_year_KEY
inner join dbo.Consolidation_Subsidiary_Client_Transaction_View as txn
on cco.client_KEY = txn.client_KEY
where
txn.is_subsidiary_client_summary = 1
and (txn.gl_fiscal_year_end_date > begin_glfy.end_date
or (txn.gl_fiscal_year_end_date = begin_glfy.end_date and txn.gl_period_number >= begin_glp.gl_period_number))
and (txn.gl_fiscal_year_end_date < end_glfy.end_date
or (txn.gl_fiscal_year_end_date = end_glfy.end_date and txn.gl_period_number <= end_glp.gl_period_number))