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;