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
)