View: dbo.GL_Account_Grouping_Code_View
View definition
CREATE VIEW dbo.GL_Account_Grouping_Code_View
AS
SELECT
gl_account_grouping_code_KEY = GAGC.gl_account_grouping_code_KEY
,gl_account_grouping_KEY = GAGC.gl_account_grouping_KEY
,code = GAGC.code
,description = GAGC.description
,is_standard_classification_code = GAGC.is_standard_classification_code
,sequence_number = GAGC.sequence_number
,gl_account_type_KEY = GAGCT.gl_account_type_KEY
,gl_account_grouping_code_guid = GAGC.gl_account_grouping_code_guid
,gl_account_grouping_category_KEY = GAGC.gl_account_grouping_category_KEY
FROM
dbo.GL_Account_Grouping_Code GAGC
LEFT JOIN
dbo.GL_Account_Grouping_Code_Type GAGCT
ON
GAGC.gl_account_grouping_code_KEY = GAGCT.gl_account_grouping_code_KEY