View: dbo.GL_Account_Client_Segment_Code_View
View definition
CREATE VIEW dbo.GL_Account_Client_Segment_Code_View
AS
SELECT
GASC.gl_account_segment_code_KEY
, GAS.description
, gl_account_client_segment_code_id = GASC.code
, GAS.client_KEY
, dbo.sf_Generate_Sortable_GL_Account_Number(GASC.code) AS gl_account_client_segment_code_id_sortable
FROM
dbo.GL_Account_Segment_Code GASC
INNER JOIN dbo.GL_Account_Segment GAS
ON GASC.gl_account_segment_KEY = GAS.gl_account_segment_KEY