| Table: dbo.Report_User_Preference | |||
| Columns | |||
| Name | Type | Constraints | Description |
| user_preference_KEY | int (4) | NOT NULL | Primary key and foreign key to user preference table |
| save_report_options | bit (1) | NOT NULL | When set to true, any changes made to the options of a report are automatically saved to the database when the user exists the options dialog. |
| print_client_id | bit (1) | NOT NULL | When set to true, the Client ID will be printed in the header on all reports. |
| print_detailed_report_options | bit (1) | NOT NULL | A true value will print the selected report options in the header on all reports. |
| print_staff_id | bit (1) | NOT NULL | When set to true, the Staff ID will be printed in the footer in all reports |
| print_system_date_time | bit (1) | NOT NULL | The current date and time will be printed in the footer on all reports when set to true. |
| print_page_number | bit (1) | NOT NULL | The page number will be printed in the footer on all reports when set to true. |
| center_page_number | bit (1) | NOT NULL | When set to true, page numbers will be printed in the center position instead of right justified in the footer. |
| collate_checks_by_client | bit (1) | NOT NULL | User setting to collate checks by client; defaults to true |
| collate_reports_by_client | bit (1) | NOT NULL | User setting to collate reports by client; defaults to true |
| date_format | nvarchar (40) | NOT NULL | User-specified date fomat. |
| time_format | nvarchar (40) | NOT NULL | User-specified time fomat. |
| customize_client_id | nvarchar (500) | NOT NULL | User-customized client id to control the actual text and format of the output. |
| customize_staff_id | nvarchar (500) | NOT NULL | User-customized staff id to control the actual text and format of the output. |
| customize_system_date_time | nvarchar (500) | NOT NULL | User-customized system date and time to control the actual text and format of the output. |
| customize_page_number | nvarchar (500) | NOT NULL | User-customized page number to control the actual text and format of the output. |
| customize_detailed_options | nvarchar (500) | NOT NULL | User-customized detailed options to control the actual text and format printed in the header of all reports. |
| print_checks_use_due_date_as_payment_date | bit (1) | NOT NULL | User setting to use due date as payment date in Print Checks when creating and printing payments for liabilities; defaults to false |
| output_report_profiles_as_individual_documents | bit (1) | NOT NULL | User setting to output report profiles to file, email, and FileCabinet CS as individual documents; defaults to false. |
| separate_processed_electronic_forms_reports_by_client | bit (1) | NOT NULL | Indicates if processed electronic forms reports should separated by client when print previewing |
| separate_managed_electronic_forms_reports_by_client | bit (1) | NOT NULL | Indicates if managed electronic forms reports should separated by client when print previewing |
| print_invoices_use_fee_date_as_invoice_date | bit (1) | NOT NULL | User setting to use a fee date as the invoice date for fee and billing invoices. |
| print_invoices_separate_invoices_per_originating_client | bit (1) | NOT NULL | User setting to separate invoices per originating client for fee and billing invoices. |
| separate_processed_internet_magnetic_media_reports_by_client | bit (1) | NOT NULL | Indicates if processed internet magnetic media file reports should separated by client when print previewing |
| separate_managed_internet_magnetic_media_reports_by_client | bit (1) | NOT NULL | Indicates if managed internet magnetic media file reports should separated by client when print previewing |
| suppress_form_8879_preview_signature_date | bit (1) | NOT NULL | True if the user has selected to suppress signature date when previewing form 8879-EMP from the Process Electronic Forms screen or the Manage Electronic Files dialog. |
| print_duplex_with_blank_sheet | bit (1) | NOT NULL | User setting to output blank sheets to the last page of odd-page-numbered reports when printing duplex, defaults to false. |
| output_to_excel_with_cell_merging | bit (1) | NOT NULL | 1 means the report will be output to excel with cell merging turned on; 0 the report will be output to excel without cell merging turned on. |
| output_with_text_wrapping | bit (1) | NOT NULL | Determines whether report text that is too large to fit in its column will be wrapped or clipped. |
| Primary key | |||
| Name | Columns | Description | |
| PK_Report_User_Preference$user_preference_KEY | user_preference_KEY | ||
| Foreign keys | |||
| Name | Columns | Referenced table | Description |
| FK_Report_User_Preference__User_Preference__user_preference_KEY | user_preference_KEY | User_Preference (user_preference_KEY) | |