View: dbo.GL_Account_Client_Grouping_Code_View | |||
View definition | |||
CREATE VIEW dbo.GL_Account_Client_Grouping_Code_View AS SELECT GAGC.gl_account_grouping_code_KEY ,gl_account_client_grouping_code_id = GAGC.code ,GAG.description ,GAG.client_KEY ,dbo.sf_Generate_Sortable_Reference_Number(GAGC.code) AS gl_account_client_grouping_code_id_sortable FROM dbo.GL_Account_Grouping_Code GAGC INNER JOIN dbo.GL_Account_Grouping GAG ON GAGC.gl_account_grouping_KEY = GAG.gl_account_grouping_KEY WHERE GAG.client_KEY IS NOT NULL | |||