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