View: dbo.Consolidation_Master_Client_Budget_View
View definition
-- drop view dbo.Consolidation_Master_Client_Budget_View
create view dbo.Consolidation_Master_Client_Budget_View
as
select
master__client_KEY = cco.client_KEY
, master__gl_account_budget_KEY = glab.gl_account_budget_KEY
, master__gl_account_KEY = glab.gl_account_KEY -- key (1 of 3)
, master__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)
, gla.gl_account_number
, 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_Consolidation_Option as cco
on cco.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
;