View: dbo.GL_Account_Class_View | |||
View definition | |||
-- Creates a view of account grouping codes that are standard classification codes. CREATE VIEW dbo.GL_Account_Class_View as ( -- build the list of GL_Account_Grouping_Code descriptions SELECT GLAGC.gl_account_grouping_code_KEY as gl_account_class_KEY, GLAGC.description FROM dbo.GL_Account_Grouping GLAG JOIN dbo.GL_Account_Grouping_Code GLAGC On GLAG.gl_account_grouping_KEY = GLAGC.gl_account_grouping_KEY WHERE client_KEY is null AND GLAG.is_standard_classification_code = 1 ) | |||