Table: Print_Option | |||
Columns | |||
Name | Type | Constraints | Description |
print_option_KEY | int | NOT NULL | AUTO-INCREMENT: Database assigned primary key for this table |
update__staff_KEY | int | NOT NULL | |
update_date_utc | datetime | NOT NULL | |
staff_KEY | int | NOT NULL | The staff these print option are for. |
output_to_printer | bit | NOT NULL | Output reports to printer. |
output_to_fcs | bit | NOT NULL | Output reports to FileCabinet Solution. |
output_to_file | bit | NOT NULL | Output reports to file. |
output_to_email | bit | NOT NULL | Output reports to email. |
printer_name | nvarchar (260) | NOT NULL | Printer name to print to. |
number_of_copies | int | NOT NULL | Number of copies to print. |
collate_copies | bit | NOT NULL | Collate copies. |
fcs_data_location | nvarchar (260) | NOT NULL | FileCabinet Solution data location to output to. |
fcs_firm_data | bit | NOT NULL | Send to firm drawer. |
fcs__staff_KEY | int | The staff whose drawer reports will be output to. | |
fcs__client_KEY | int | The client whose drawer reports will be output to. | |
file_output_type | int | NOT NULL | The type of file format to output reports to. |
file_destination | nvarchar (260) | NOT NULL | The path to output reports to. |
email_output_type | int | NOT NULL | The type of file format to email reports in. |
email_recipients | nvarchar (-1) | NOT NULL | The email recipients. |
create_date_utc | datetime | NOT NULL | |
output_labels_to_printer | bit | NOT NULL | Output labels to printer. |
label_printer_name | nvarchar (260) | NOT NULL | Printer name to print labels to. |
label__report_definition_KEY | int | The label format to use when printing labels. | |
output_to_gofileroom | bit | NOT NULL | Determines if output will be sent to GoFileRoom |
gofileroom_output_type | int | NOT NULL | The type of file format to export to GoFileRoom. |
output_letters_to_printer | bit | NOT NULL | Output letters to printer. |
letter__report_definition_KEY | int | The letter format to use when printing letters. | |
output_to_online_bill_pay | bit | NOT NULL | Output reports to Online Bill Pay. |
email_save_drafts | bit | NOT NULL | Save e-mails to Drafts folder (do not send). |
fcs_file_by_type | int | NOT NULL | How to file a report (e.g., by the firm's current-year-end date). |
fcs_create_link | bit | NOT NULL | |
gofileroom_create_link | bit | NOT NULL | |
file_create_link | bit | NOT NULL | |
output_to_onvio_documents | bit | NOT NULL | Determines if output will be sent to Onvio Documents. |
onvio_documents_output_type | int | NOT NULL | The type of file format to export to Onvio Documents. |
onvio_documents_create_link | bit | NOT NULL | |
onvio_documents_firm_data | bit | NOT NULL | Send to firm documents. |
onvio_documents__client_KEY | int | The client whose folder reports will be output to. | |
onvio_documents_file_by_type | int | NOT NULL | How to file a report (e.g., by the firm's current-year-end date). |
Primary key | |||
Name | Columns | Description | |
PK_Print_Option$print_option_KEY | print_option_KEY | CLUSTERED | |
Unique constraints | |||
Name | Columns | Description | |
UK_Print_Option$staff_KEY | staff_KEY | ||
Indexes | |||
Name | Columns | Description | |
IX_Print_Option$fcs__client_KEY | fcs__client_KEY | Index supports foreign key FK_Print_Option__Client__fcs__client_KEY | |
IX_Print_Option$fcs__staff_KEY | fcs__staff_KEY | Index supports foreign key FK_Print_Option__Staff__fcs__staff_KEY | |
IX_Print_Option$label__report_definition_KEY | label__report_definition_KEY | Index supports foreign key FK_Print_Option__Report_Definition__label__report_definition_KEY | |
IX_Print_Option$letter__report_definition_KEY | letter__report_definition_KEY | Index supports foreign key FK_Print_Option__Report_Definition__letter__report_definition_KEY | |
IX_Print_Option$onvio_documents__client_KEY | onvio_documents__client_KEY | Index supports foreign key FK_Print_Option__Client__onvio_documents__client_KEY |