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;