View: dbo.Firm_GL_Account_Grouping_View | |||
View definition | |||
-- Creates a view of firm account grouping codes. CREATE VIEW dbo.Firm_GL_Account_Grouping_View AS -- build the list of GL_Account_Grouping descriptions SELECT --client_KEY must not be added to the select list. In the future, is_standard_classification_code --and/or gl_account_grouping_guid could be added. gac.gl_account_grouping_KEY , gac.description FROM dbo.GL_Account_Grouping AS gac WHERE gac.client_KEY IS NULL; | |||