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