View: dbo.GL_Transaction_Type_View
View definition
--
-- For backwards compatibility, this view must NOT be removed. The GL transaction types used to be generated solely by
-- this view by UNION'ing all the individual transaction type tables (bank transaction type, journal entry type, etc).
-- To fix a filtering issue that was generating sql that didn't compile, the GL_Transaction_Type table was created
-- instead to redundantly hold these values along with a unit test to make sure the individual type tables match the
-- accumulated list of values. The app now uses the new table instead of this view when the transaction types are
-- needed. Unfortunately, this view can't be removed because report options store the sql generated from the filter
-- system directly in xml so there could be databases out there with scripts using the GL_Transaction_Type_View.
--
CREATE view dbo.GL_Transaction_Type_View
AS
SELECT
gl_transaction_type_KEY
, description
FROM
dbo.GL_Transaction_Type;