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 | |||