View: dbo.Full_Tax_Code_M3_View | |||
View definition | |||
CREATE VIEW dbo.Full_Tax_Code_M3_View AS SELECT tax_code.client_KEY , CASE WHEN (tax_code.tax_subcode = N'') THEN tax_code.tax_code ELSE (tax_code.tax_code + N'-' + tax_code.tax_subcode) END as description , dbo.sf_Generate_Sortable_Id(CASE WHEN (tax_code.tax_subcode = N'') THEN tax_code.tax_code ELSE (tax_code.tax_code + N'-' + tax_code.tax_subcode) END) AS description_sortable , tax_code.tax_code_KEY FROM dbo.Tax_Code AS tax_code INNER JOIN dbo.Tax_Code_N_Ultra_Tax_Tax_Code AS n_table ON tax_code.tax_code_KEY = n_table.tax_code_KEY INNER JOIN dbo.Ultra_Tax_Tax_Code AS ultra_tax_tax_code ON n_table.ultra_tax_tax_code_KEY = ultra_tax_tax_code.ultra_tax_tax_code_KEY WHERE ultra_tax_tax_code.ultra_tax_category_type_KEY IN (2 /* M3A */, 5 /* All */) GROUP BY tax_code.tax_code_KEY,tax_code.client_KEY,tax_code.tax_subcode,tax_code.tax_code | |||