Table: dbo.Report_Definition
Columns
Name | Type | Constraints | Description
report_definition_KEY | int (4) | NOT NULL | Database assigned primary key for this table.
update_date | datetime (8, 3) | NOT NULL | The date and time this row was last modified.
description | nvarchar (300) | NOT NULL | User defined description.
report_type_KEY | int (4) | NOT NULL | Key of the Report Type that this row is assigned
report_definition_guid | uniqueidentifier (16) | NOT NULL | A database generated unique key for this table.
system_default__report_option_xml | nvarchar (-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_year | int (4) |  | Layout year for layout definitions that need one.
report_definition_source_KEY | int (4) | NOT NULL | Layout source
report_definition_xml_compressed | varbinary (-1) |  | The compressed version of the report XML string.
checksum | decimal (9) | NOT NULL | CRC checksum based on the uncompressed XML string.
report_folder_KEY | int (4) |  | Foreign key to Report_Folder. If null then it means that the record is a layout (not a report).

Primary key
Name | Columns | Description
PK_Report_Definition | report_definition_KEY |
Unique constraints
Name | Columns | Description
UK_Report_Definition$report_definition_guid | report_definition_guid |
UK_Report_Definition$report_type_KEY$description$layout_year$report_folder_KEY | report_type_KEY, description, layout_year, report_folder_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Report_Definition__Report_Definition_Source__report_definition_source_KEY | report_definition_source_KEY | Report_Definition_Source (report_definition_source_KEY) |
FK_Report_Definition__Report_Folder__report_folder_KEY | report_folder_KEY | Report_Folder (report_folder_KEY) |
FK_Report_Definition__Report_Type__report_type_KEY | report_type_KEY | Report_Type (report_type_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Global_Report_Profile_Element__Report_Definition__report_definition_KEY | report_definition_KEY | Global_Report_Profile_Element |
FK_Invoice_Printing_Default_Option__Report_Definition__invoice_layout__report_definition_KEY | invoice_layout__report_definition_KEY | Invoice_Printing_Default_Option |
FK_Report_Definition_Application_License_Requirement__Report_Definition__report_definition_KEY | report_definition_KEY | Report_Definition_Application_License_Requirement |
FK_W2_Rendered_Template__Report_Definition__report_definition_KEY | report_definition_KEY | W2_Rendered_Template |
FK_Client_W2_Rendered_Document__Report_Definition__report_definition_KEY | report_definition_KEY | Client_W2_Rendered_Document |
FK_Report_Definition_Security_Group__Report_Definition__report_definition_KEY | report_definition_KEY | Report_Definition_Security_Group |
FK_Receivable_Transaction_Print_Option__Report_Definition__invoice_layout__report_definition_KEY | invoice_layout__report_definition_KEY | Receivable_Transaction_Print_Option |
FK_Receivable_Transaction_Print_Override__Report_Definition__invoice_layout__report_definition_KEY | invoice_layout__report_definition_KEY | Receivable_Transaction_Print_Override |
FK_Print_Report_Selection__Report_Definition__report_definition_KEY | report_definition_KEY | Print_Report_Selection |
FK_Staff_Default_Report_Option__Report_Definition__report_definition_KEY | report_definition_KEY | Staff_Default_Report_Option |
FK_Report_Profile_Element__Report_Definition__report_definition_KEY | report_definition_KEY | Report_Profile_Element |
FK_Undo_Manager_Entry__Report_Definition__report_definition_guid | report_definition_guid | Undo_Manager_Entry | Foreign key for the report definition guid.
FK_Checkbook__Report_Definition__ap_layout__report_definition_KEY | ap_layout__report_definition_KEY | Checkbook |
FK_Checkbook__Report_Definition__payroll_layout__report_definition_KEY | payroll_layout__report_definition_KEY | Checkbook |
FK_Checkbook__Report_Definition__vendor_layout__report_definition_KEY | vendor_layout__report_definition_KEY | Checkbook |
FK_Checkbook__Report_Definition__deposit_layout__report_definition_KEY | deposit_layout__report_definition_KEY | Checkbook |
FK_Client_AR_Setup__Report_Definition__invoice_layout__report_definition_KEY | invoice_layout__report_definition_KEY | Client_AR_Setup |
FK_Client_AR_Setup__Report_Definition__statement_layout__report_definition_KEY | statement_layout__report_definition_KEY | Client_AR_Setup |
FK_Reprintable_Bank_Transaction__Report_Definition__report_definition_KEY | report_definition_KEY | Reprintable_Bank_Transaction |
FK_Employee_W2_Rendered_Document__Report_Definition__report_definition_KEY | report_definition_KEY | Employee_W2_Rendered_Document |