View: dbo.Consolidation_Subsidiary_Client_Budget_View
View definition
-- drop view dbo.Consolidation_Subsidiary_Client_Budget_View
create view dbo.Consolidation_Subsidiary_Client_Budget_View
as
select
master__client_KEY = cnsc.consolidating__client_KEY
, cnsc.subsidiary__client_KEY
, subsidiary__sequence_number = cnsc.sequence_number
, subsidiary__gl_account_KEY = glab.gl_account_KEY -- key (1 of 3)
, subsidiary__gl_period_KEY = glab.gl_period_KEY -- key (2 of 3)
, gl_fiscal_year_end_date = glfy.end_date -- alternate key (2.1 of 3)
, glp.gl_period_number -- alternate key (2.2 of 3)
, glab.gl_account_budget_category_KEY -- key (3 of 3)
, glab.amount
from
dbo.GL_Account_Budget as glab
inner join dbo.GL_Account as gla
on gla.gl_account_KEY = glab.gl_account_KEY
inner join dbo.Client_N_Subsidiary_Client as cnsc
on cnsc.subsidiary__client_KEY = gla.client_KEY
inner join dbo.GL_Period as glp
on glp.gl_period_KEY = glab.gl_period_KEY
inner join dbo.GL_Fiscal_Year as glfy
on glfy.gl_fiscal_year_KEY = glp.gl_fiscal_year_KEY
where
cnsc.subsidiary_client_collection_type_KEY = 1
;