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
)