View: dbo.Reports_With_Accounting_Without_Workpapers_View | |||
View definition | |||
CREATE VIEW dbo.Reports_With_Accounting_Without_Workpapers_View AS SELECT report_definition_application_license_requirement_KEY ,report_definition_KEY ,accounting_application_KEY ,has_accounting ,has_compliance ,has_payroll ,has_workpapers FROM dbo.Report_Definition_Application_License_Requirement WHERE has_workpapers = 0 AND accounting_application_KEY = 1 | |||