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