View: dbo.Consolidation_Subsidiary_Client_Account_Number_With_Leading_Zeroes_View | |||
View definition | |||
-- drop view Consolidation_Subsidiary_Client_Account_Number_With_Leading_Zeroes_View create view dbo.Consolidation_Subsidiary_Client_Account_Number_With_Leading_Zeroes_View as select client_KEY = n.consolidating__client_KEY , n.subsidiary__client_KEY , n.sequence_number , gla.description , segment1 = cast(n.sequence_number as nvarchar(3)) collate Latin1_General_CI_AS , segment2 = -- Build the account number by concatenating each of its segment codes in the order defined by the client's -- Chart of Accounts mask. (select cast(segment AS varchar(60)) from dbo.Consolidation_Subsidiary_Client_Account_Number_Detail_With_Leading_Zeroes_View where gl_account_KEY = gla.gl_account_KEY order by mask_order for xml path (N'')) , gla.is_active , subsidiary__gl_account_KEY = gla.gl_account_KEY from dbo.Client_N_Subsidiary_Client as n inner join dbo.GL_Account as gla on n.subsidiary__client_KEY = gla.client_KEY where n.subsidiary_client_collection_type_KEY = 1 -- Selected to Consolidate | |||