View: dbo.Firm_Account_Tax_Codes_View | |||
View definition | |||
-- adds a view that is required by the filter system due to a requirement of Column IS NULL being impossible to state via the filtering system CREATE VIEW dbo.Firm_Account_Tax_Codes_View AS SELECT tcnuttc.tax_code_n_ultra_tax_tax_code_KEY ,uttc.ultra_tax_entity_type_KEY FROM dbo.Ultra_Tax_Tax_Code AS uttc INNER JOIN dbo.Tax_Code_N_Ultra_Tax_Tax_Code AS tcnuttc ON uttc.ultra_tax_tax_code_KEY=tcnuttc.ultra_tax_tax_code_KEY INNER JOIN dbo.Tax_Code AS tc ON tcnuttc.tax_code_KEY=tc.tax_code_KEY WHERE tc.client_KEY IS NULL; | |||