View: dbo.Consolidation_Master_Client_Tax_Code_View
View definition
-- drop view dbo.Consolidation_Master_Client_Tax_Code_View
create view dbo.Consolidation_Master_Client_Tax_Code_View
as
select
master__client_KEY = tc.client_KEY-- key (1 of 4)
, uttc.ultra_tax_entity_type_KEY -- key (2 of 4)
, uttc.code_year -- key (3 of 4)
, tc.tax_code -- alternate key (4.1 of 4)
, uttc.description
, tc.tax_subcode -- alternate key (4.2 of 4)
, n.tax_subcode_description
, n.tax_code_n_ultra_tax_tax_code_KEY
, tc.tax_code_KEY -- key (4 of 4)
, uttc.ultra_tax_tax_code_KEY
, uttc.ultra_tax_category_type_KEY
, uttc.gl_account_type_KEY
from
dbo.Client_Consolidation_Option as cco
inner join dbo.Tax_Code as tc
on tc.client_KEY = cco.client_KEY
inner join dbo.Tax_Code_N_Ultra_Tax_Tax_Code as n
on tc.tax_code_KEY = n.tax_code_KEY
inner join dbo.Ultra_Tax_Tax_Code as uttc
on n.ultra_tax_tax_code_KEY = uttc.ultra_tax_tax_code_KEY
--order by
-- tc.client_KEY
-- , uttc.ultra_tax_entity_type_KEY
-- , uttc.code_year
-- , tc.tax_code
-- , tc.tax_subcode
;