View: dbo.GL_Account_View | |||
View definition | |||
--Gl Account Entity View CREATE VIEW dbo.GL_Account_View AS ( SELECT GL.* , gl_account__active_status_KEY = CASE WHEN GL.is_active = 0 THEN 2 ELSE 1 END -- Column added to match with the Active_Status View for Status Filter FROM dbo.GL_Account GL ) | |||