Table: dbo.Print_Destination_User_Preference | |||
Store user preferences for print destinations and use them to populate various Print Options views. | |||
Columns | |||
Name | Type | Constraints | Description |
print_destination_user_preference_KEY | int (4) | NOT NULL | Primary key for this table |
user_preference_KEY | int (4) | NOT NULL | Foreign key to table User_Preference |
print_job_type_KEY | int (4) | NOT NULL | Foreign key to table Print_Job_Type |
printer__is_selected | bit (1) | NOT NULL | Is a printer selected for output? |
printer__use_duplex | bit (1) | NOT NULL | For printer output, use duplex? |
file_cabinet__is_selected | bit (1) | NOT NULL | Is File Cabinet selected for output? |
file_cabinet__data_path | nvarchar (520) | NOT NULL | For File Cabinet output, what is the data path? |
file_cabinet__send_to_netclient_document_presentation | bit (1) | NOT NULL | For File Cabinet output, send to NetClient CS Document Presentation? |
engagement__is_selected | bit (1) | NOT NULL | Is Engagement CS selected for output? |
file__is_selected | bit (1) | NOT NULL | Is file selected for output? |
file__file_extension | nvarchar (8) | NOT NULL | For file output, what is the file extension? |
file__open_file_when_complete | bit (1) | NOT NULL | For file output, open the file when complete? |
file__data_path | nvarchar (520) | NOT NULL | For file output, what is the data path? |
printer__is_tax_form_filing_copy_selected | bit (1) | NOT NULL | True if the user wants to print the filing copy of the tax form to printer. |
printer__is_tax_form_client_copy_selected | bit (1) | NOT NULL | True if the user wants to print the client copy of the tax form to printer. |
file_cabinet__is_tax_form_filing_copy_selected | bit (1) | NOT NULL | True if the user wants to print the filing copy of the tax form to file cabinet. |
file_cabinet__is_tax_form_client_copy_selected | bit (1) | NOT NULL | True if the user wants to print the client copy of the tax form to file cabinet. |
file__is_tax_form_filing_copy_selected | bit (1) | NOT NULL | True if the user wants to print the filing copy of the tax form to file. |
file__is_tax_form_client_copy_selected | bit (1) | NOT NULL | True if the user wants to print the client copy of the tax form to file. |
engagement__is_tax_form_filing_copy_selected | bit (1) | NOT NULL | True if the user wants to print the filing copy of the tax form to engagement. |
engagement__is_tax_form_client_copy_selected | bit (1) | NOT NULL | True if the user wants to print the client copy of the tax form to engagement. |
continue_page_numbering_across_reports | bit (1) | NOT NULL | Does the user want the page number restarted for each multi-page report in a report print run? |
starting_page_number | int (4) | NOT NULL | Specified beginning page count number. |
engagement_binder_include_pdf_annotations | bit (1) | NOT NULL | flag that indicates whether to include pdf annotations when printing engagement binder |
engagement_binder_hide_empty_folders | bit (1) | NOT NULL | flag that indicates whether to hide empty folders when printing engagement binder |
engagement_binder_hide_references | bit (1) | NOT NULL | flag that indicates whether to hide references when printing engagement binder |
engagement_binder_output_folder | nvarchar (512) | NOT NULL | folder to output document in when printing engagement binder |
engagement_binder_protect_against_modification | bit (1) | NOT NULL | flag that indicates whether or not to protect against modification when printing engagement binder |
engagement_binder_output_to_pdf | bit (1) | NOT NULL | flag that indicates whether to output to pdf when printing engagement binder |
engagement_binder_open_after_export | bit (1) | NOT NULL | flag that indicates whether to open after export when printing engagement binder |
engagement_binder_output_to_file_cabinet | bit (1) | NOT NULL | flag that indicates whether to output to file cabinet when printing engagement binder |
engagement_binder_send_to_portal | bit (1) | NOT NULL | flag that indicates whether to send to portal when printing engagement binder |
engagement_binder_file_cabinet_data_path | nvarchar (512) | NOT NULL | path to file cabinet when printing engagement binder |
engagement_binder_output_to_file | bit (1) | NOT NULL | flag that indicates whether to output to file when printing engagement binder |
gfr__is_selected | bit (1) | NOT NULL | Represents if the we are printing a document to GoFileRoom |
gfr__file_extension | nvarchar (16) | NOT NULL | Selected file extension for GoFileRoom output. This only applies if gfr__is_selected is true. |
gfr__is_tax_form_filing_copy_selected | bit (1) | NOT NULL | True if the user wants to print the filing copy of the tax form to file (for GoFileRoom). |
gfr__is_tax_form_client_copy_selected | bit (1) | NOT NULL | True if the user wants to print the client copy of the tax form to file (for GoFileRoom). |
engagement_binder_output_to_gfr | bit (1) | NOT NULL | Flag that indicates whether to output to GoFileRoom when printing engagement binder. |
onvio_documents__is_selected | bit (1) | NOT NULL | Represents if we are printing a document to Onvio Documents |
onvio_documents__file_extension | nvarchar (8) | NOT NULL | Selected file extension for Onvio Documents output. This only applies if onvio_documents__is_selected is true. |
onvio_documents__is_tax_form_filing_copy_selected | bit (1) | NOT NULL | True if the user wants to print the filing copy of the tax form to file (for Onvio Documents). |
onvio_documents__is_tax_form_client_copy_selected | bit (1) | NOT NULL | True if the user wants to print the client copy of the tax form to file (for Onvio Documents). |
engagement_binder_output_to_onvio_documents | bit (1) | NOT NULL | Flag that indicates whether to output to Onvio Documents when printing engagement binder. |
for_complete_payroll_or_forms_output | bit (1) | NOT NULL | If true, then this record is for use during Complete Payroll Output (in Print Checks) or Complete Forms Output. |
Primary key | |||
Name | Columns | Description | |
PK_Print_Destination_User_Preference | print_destination_user_preference_KEY | ||
Unique constraints | |||
Name | Columns | Description | |
UK_Print_Destination_User_Preference$user_preference_KEY$print_job_type_KEY$for_complete_payroll_or_forms_output | user_preference_KEY, print_job_type_KEY, for_complete_payroll_or_forms_output |