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 | |||