Table: dbo.Report_Definition
Columns
NameTypeConstraintsDescription
report_definition_KEYint (4)NOT NULLDatabase assigned primary key for this table.
update_datedatetime (8, 3)NOT NULLThe date and time this row was last modified.
descriptionnvarchar (300)NOT NULLUser defined description.
report_type_KEYint (4)NOT NULLKey of the Report Type that this row is assigned
report_definition_guiduniqueidentifier (16)NOT NULLA database generated unique key for this table.
system_default__report_option_xmlnvarchar (-1)Valid only for a new style report. An xml blob created by the custom report designer that defines the default report options for the report. This is the default set of options to use if the report has never been run before or if the existing options should be cleared (these default options are defined by us, not the user).
layout_yearint (4)Layout year for layout definitions that need one.
report_definition_source_KEYint (4)NOT NULLLayout source
report_definition_xml_compressedvarbinary (-1)The compressed version of the report XML string.
checksumdecimal (9)NOT NULLCRC checksum based on the uncompressed XML string.
report_folder_KEYint (4)Foreign key to Report_Folder. If null then it means that the record is a layout (not a report).
Primary key
NameColumnsDescription
PK_Report_Definitionreport_definition_KEY
Unique constraints
NameColumnsDescription
UK_Report_Definition$report_definition_guidreport_definition_guid
UK_Report_Definition$report_type_KEY$description$layout_year$report_folder_KEYreport_type_KEY, description, layout_year, report_folder_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Report_Definition__Report_Definition_Source__report_definition_source_KEYreport_definition_source_KEYReport_Definition_Source (report_definition_source_KEY)
FK_Report_Definition__Report_Folder__report_folder_KEYreport_folder_KEYReport_Folder (report_folder_KEY)
FK_Report_Definition__Report_Type__report_type_KEYreport_type_KEYReport_Type (report_type_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Global_Report_Profile_Element__Report_Definition__report_definition_KEYreport_definition_KEYGlobal_Report_Profile_Element
FK_Invoice_Printing_Default_Option__Report_Definition__invoice_layout__report_definition_KEYinvoice_layout__report_definition_KEYInvoice_Printing_Default_Option
FK_Report_Definition_Application_License_Requirement__Report_Definition__report_definition_KEYreport_definition_KEYReport_Definition_Application_License_Requirement
FK_W2_Rendered_Template__Report_Definition__report_definition_KEYreport_definition_KEYW2_Rendered_Template
FK_Client_W2_Rendered_Document__Report_Definition__report_definition_KEYreport_definition_KEYClient_W2_Rendered_Document
FK_Report_Definition_Security_Group__Report_Definition__report_definition_KEYreport_definition_KEYReport_Definition_Security_Group
FK_Receivable_Transaction_Print_Option__Report_Definition__invoice_layout__report_definition_KEYinvoice_layout__report_definition_KEYReceivable_Transaction_Print_Option
FK_Receivable_Transaction_Print_Override__Report_Definition__invoice_layout__report_definition_KEYinvoice_layout__report_definition_KEYReceivable_Transaction_Print_Override
FK_Print_Report_Selection__Report_Definition__report_definition_KEYreport_definition_KEYPrint_Report_Selection
FK_Staff_Default_Report_Option__Report_Definition__report_definition_KEYreport_definition_KEYStaff_Default_Report_Option
FK_Report_Profile_Element__Report_Definition__report_definition_KEYreport_definition_KEYReport_Profile_Element
FK_Undo_Manager_Entry__Report_Definition__report_definition_guidreport_definition_guidUndo_Manager_EntryForeign key for the report definition guid.
FK_Checkbook__Report_Definition__ap_layout__report_definition_KEYap_layout__report_definition_KEYCheckbook
FK_Checkbook__Report_Definition__payroll_layout__report_definition_KEYpayroll_layout__report_definition_KEYCheckbook
FK_Checkbook__Report_Definition__vendor_layout__report_definition_KEYvendor_layout__report_definition_KEYCheckbook
FK_Checkbook__Report_Definition__deposit_layout__report_definition_KEYdeposit_layout__report_definition_KEYCheckbook
FK_Client_AR_Setup__Report_Definition__invoice_layout__report_definition_KEYinvoice_layout__report_definition_KEYClient_AR_Setup
FK_Client_AR_Setup__Report_Definition__statement_layout__report_definition_KEYstatement_layout__report_definition_KEYClient_AR_Setup
FK_Reprintable_Bank_Transaction__Report_Definition__report_definition_KEYreport_definition_KEYReprintable_Bank_Transaction
FK_Employee_W2_Rendered_Document__Report_Definition__report_definition_KEYreport_definition_KEYEmployee_W2_Rendered_Document

Schema diagram