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