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) |