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))`