Table: dbo.Report_Definition_Application_License_Requirement
Lists application/license combinations that make CS defined reports available.
Columns
NameTypeConstraintsDescription
report_definition_application_license_requirement_KEYint (4)NOT NULLPrimary key for this table.
report_definition_KEYint (4)NOT NULLReport that's having its application / license requirement defined.
accounting_application_KEYint (4)NOT NULLAccounting application report will be available for.
has_accountingbit (1)NOT NULLReport is available if the firm has the accounting license. Used only for the ACS application.
has_compliancebit (1)NOT NULLReport is available if the firm has the compliance license. Used only for the ACS application.
has_payrollbit (1)NOT NULLReport is available if the firm has the payroll license. Used only for the ACS application.
has_workpapersbit (1)NOT NULLReport is available if this is Workpapers.
has_client_access_pr_onlybit (1)NOT NULLReport is available if this is Client Access Payroll Only system.
Primary key
NameColumnsDescription
PK_Report_Definition_Application_License_Requirementreport_definition_application_license_requirement_KEY
Unique constraints
NameColumnsDescription
UK_Report_Definition_Application_License_Requirement$report_definition_KEY$accounting_application_KEYreport_definition_KEY, accounting_application_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Report_Definition_Application_License_Requirement__Accounting_Application__accounting_application_KEYaccounting_application_KEYAccounting_Application (accounting_application_KEY)
FK_Report_Definition_Application_License_Requirement__Report_Definition__report_definition_KEYreport_definition_KEYReport_Definition (report_definition_KEY)

Schema diagram