View: dbo.GL_Account_Client_Grouping_Subcode_View | |||
View definition | |||
CREATE VIEW dbo.GL_Account_Client_Grouping_Subcode_View AS SELECT GAGS.gl_account_grouping_subcode_KEY ,GAG.description ,GAG.client_KEY ,gl_account_client_grouping_subcode_id = GAGS.subcode ,dbo.sf_Generate_Sortable_Reference_Number(GAGS.subcode) AS gl_account_client_grouping_subcode_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 INNER JOIN dbo.GL_Account_Grouping_Subcode GAGS ON GAGC.gl_account_grouping_code_KEY = GAGS.gl_account_grouping_code_KEY WHERE GAG.client_KEY IS NOT NULL | |||