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