Table: Print_Option
Columns
NameTypeConstraintsDescription
print_option_KEYintNOT NULLAUTO-INCREMENT: Database assigned primary key for this table
update__staff_KEYintNOT NULL
update_date_utcdatetimeNOT NULL
staff_KEYintNOT NULLThe staff these print option are for.
output_to_printerbitNOT NULLOutput reports to printer.
output_to_fcsbitNOT NULLOutput reports to FileCabinet Solution.
output_to_filebitNOT NULLOutput reports to file.
output_to_emailbitNOT NULLOutput reports to email.
printer_namenvarchar (260)NOT NULLPrinter name to print to.
number_of_copiesintNOT NULLNumber of copies to print.
collate_copiesbitNOT NULLCollate copies.
fcs_data_locationnvarchar (260)NOT NULLFileCabinet Solution data location to output to.
fcs_firm_databitNOT NULLSend to firm drawer.
fcs__staff_KEYintThe staff whose drawer reports will be output to.
fcs__client_KEYintThe client whose drawer reports will be output to.
file_output_typeintNOT NULLThe type of file format to output reports to.
file_destinationnvarchar (260)NOT NULLThe path to output reports to.
email_output_typeintNOT NULLThe type of file format to email reports in.
email_recipientsnvarchar (-1)NOT NULLThe email recipients.
create_date_utcdatetimeNOT NULL
output_labels_to_printerbitNOT NULLOutput labels to printer.
label_printer_namenvarchar (260)NOT NULLPrinter name to print labels to.
label__report_definition_KEYintThe label format to use when printing labels.
output_to_gofileroombitNOT NULLDetermines if output will be sent to GoFileRoom
gofileroom_output_typeintNOT NULLThe type of file format to export to GoFileRoom.
output_letters_to_printerbitNOT NULLOutput letters to printer.
letter__report_definition_KEYintThe letter format to use when printing letters.
output_to_online_bill_paybitNOT NULLOutput reports to Online Bill Pay.
email_save_draftsbitNOT NULLSave e-mails to Drafts folder (do not send).
fcs_file_by_typeintNOT NULLHow to file a report (e.g., by the firm's current-year-end date).
fcs_create_linkbitNOT NULL
gofileroom_create_linkbitNOT NULL
file_create_linkbitNOT NULL
output_to_onvio_documentsbitNOT NULLDetermines if output will be sent to Onvio Documents.
onvio_documents_output_typeintNOT NULLThe type of file format to export to Onvio Documents.
onvio_documents_create_linkbitNOT NULL
onvio_documents_firm_databitNOT NULLSend to firm documents.
onvio_documents__client_KEYintThe client whose folder reports will be output to.
onvio_documents_file_by_typeintNOT NULLHow to file a report (e.g., by the firm's current-year-end date).
Primary key
NameColumnsDescription
PK_Print_Option$print_option_KEYprint_option_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Print_Option$staff_KEYstaff_KEY
Indexes
NameColumnsDescription
IX_Print_Option$fcs__client_KEYfcs__client_KEYIndex supports foreign key FK_Print_Option__Client__fcs__client_KEY
IX_Print_Option$fcs__staff_KEYfcs__staff_KEYIndex supports foreign key FK_Print_Option__Staff__fcs__staff_KEY
IX_Print_Option$label__report_definition_KEYlabel__report_definition_KEYIndex supports foreign key FK_Print_Option__Report_Definition__label__report_definition_KEY
IX_Print_Option$letter__report_definition_KEYletter__report_definition_KEYIndex supports foreign key FK_Print_Option__Report_Definition__letter__report_definition_KEY
IX_Print_Option$onvio_documents__client_KEYonvio_documents__client_KEYIndex supports foreign key FK_Print_Option__Client__onvio_documents__client_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Print_Option__Client__fcs__client_KEYfcs__client_KEYClienton delete set null;
FK_Print_Option__Client__onvio_documents__client_KEYonvio_documents__client_KEYClient
FK_Print_Option__Report_Definition__label__report_definition_KEYlabel__report_definition_KEYReport_Definition
FK_Print_Option__Report_Definition__letter__report_definition_KEYletter__report_definition_KEYReport_Definition
FK_Print_Option__Staff__fcs__staff_KEYfcs__staff_KEYStaff
FK_Print_Option__Staff__staff_KEYstaff_KEYStaffon delete cascade;

Schema diagram