Table: dbo.Report_Definition_Application_License_Requirement
Lists application/license combinations that make CS defined reports available.
Columns
Name | Type | Constraints | Description
report_definition_application_license_requirement_KEY | int (4) | NOT NULL | Primary key for this table.
report_definition_KEY | int (4) | NOT NULL | Report that's having its application / license requirement defined.
accounting_application_KEY | int (4) | NOT NULL | Accounting application report will be available for.
has_accounting | bit (1) | NOT NULL | Report is available if the firm has the accounting license. Used only for the ACS application.
has_compliance | bit (1) | NOT NULL | Report is available if the firm has the compliance license. Used only for the ACS application.
has_payroll | bit (1) | NOT NULL | Report is available if the firm has the payroll license. Used only for the ACS application.
has_workpapers | bit (1) | NOT NULL | Report is available if this is Workpapers.
has_client_access_pr_only | bit (1) | NOT NULL | Report is available if this is Client Access Payroll Only system.

Primary key
Name | Columns | Description
PK_Report_Definition_Application_License_Requirement | report_definition_application_license_requirement_KEY |
Unique constraints
Name | Columns | Description
UK_Report_Definition_Application_License_Requirement$report_definition_KEY$accounting_application_KEY | report_definition_KEY, accounting_application_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Report_Definition_Application_License_Requirement__Accounting_Application__accounting_application_KEY | accounting_application_KEY | Accounting_Application (accounting_application_KEY) |
FK_Report_Definition_Application_License_Requirement__Report_Definition__report_definition_KEY | report_definition_KEY | Report_Definition (report_definition_KEY) |