Table: dbo.Onvio_Documents_Display_Dialog
This table pairs a Document_Management_System_Print_Category (as defined by the DMS_Print_Category table) to a boolean value["BR"] for displaying a dialog when printing that category and to a boolean value["BR"] for including document date year property on parent level folder when printing that category. Not changing the historical name of table, just added the required column.
Columns
NameTypeConstraintsDescription
document_management_system_print_category_KEYint (4)NOT NULLThe DMS Print Category that values of always_display_dialog will be paired to.
always_display_dialogbit (1)NOT NULLA boolean value denoting whether or not to always display the Onvio Mapping Dialog.
include_yearbit (1)NOT NULLA boolean value denoting whether or not to include document date year property on parent level folder from the Onvio Mapping Dialog. 1 means include the year; 0 means do not include.
Primary key
NameColumnsDescription
PK_Onvio_Documents_Display_Dialog$document_management_system_print_category_KEYdocument_management_system_print_category_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Onvio_Documents_Display_Dialog__Document_Management_System_Print_Category__document_management_system_print_category_KEYdocument_management_system_print_category_KEYDocument_Management_System_Print_Category (document_management_system_print_category_KEY)

Schema diagram