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