Table: User_Preference
Columns
NameTypeConstraintsDescription
user_preference_KEYintNOT NULLAUTO-INCREMENT: Database assigned primary key for this table.
update__staff_KEYintNOT NULL
update_date_utcdatetimeNOT NULL
staff_KEYintKey of one of the Staff records
alternate_row_colorbitNOT NULLPresents all lists and grids with alternating row colors when true
enter_as_tabbitNOT NULLEnter key functions as Tab
startup_windownvarchar (100)NOT NULLScreen to open at startup
entry__user_preference_default_sheet_date_KEYintKey of one of the User Preference Default Sheet Date records
entry__client_KEYintKey of one of the Client records
entry_client_skipbitNOT NULLSkips the Client column
entry_client_hidebitNOT NULLHides the Client column
entry__engagement_template_KEYintKey of one of the Engagement Template records
entry_engagement_template_skipbitNOT NULLSkips the Engagement column
entry_engagement_template_hidebitNOT NULLHides the Engagement column
entry_time__activity_KEYintKey of one of the Activity records for time
entry_time_activity_skipbitNOT NULLSkips the Activity column for time
entry_time_activity_hidebitNOT NULLHides the Activity column for time
entry_expense__activity_KEYintKey of one of the Activity records for expenses
entry_expense_activity_skipbitNOT NULLSkips the Activity column for expenses
entry_expense_activity_hidebitNOT NULLHides the Activity column for expenses
entry__user_preference_default_entry_date_KEYintKey of one of the User Preference Default Entry Date records
entry_date_skipbitNOT NULLSkips the Date column
entry_date_hidebitNOT NULLHides the Date column
entry_time__billing_rate_type_KEYintDefault rate for time
entry_time_rate_skipbitNOT NULLSkips the Rate column for time
entry_time_rate_hidebitNOT NULLHides the Rate column for time
entry_expense__billing_rate_type_KEYintDefault rate for expense
entry_expense_rate_skipbitNOT NULLSkips the Rate column for time
entry_expense_rate_hidebitNOT NULLHides the Rate column for time
entry_timer_skipbitNOT NULLSkips the Timer column
entry_timer_hidebitNOT NULLHides the Timer Column
entry_commentnvarchar (-1)NOT NULLDefault comment for each entry
entry_comment_skipbitNOT NULLSkips the Comment column
entry_comment_hidebitNOT NULLHides the Comment column
entry_biller_notenvarchar (-1)NOT NULLDefault biller note for each entry
entry_biller_note_skipbitNOT NULLSkips the Biller Note column
entry_biller_note_hidebitNOT NULLHides the Biller Note column
entry__rounding_method_KEYintNOT NULLKey of one of the Rounding Method records
entry_rounding_incrementdecimal (4, 2)NOT NULLIncrement for rounding time from the timer in hours
entry__time_style_KEYintNOT NULLKey of one of the Time Style records
entry_implied_decimalbitNOT NULLAutomatically inserts decimal point at end of hours
entry_display_billedbitNOT NULLDisplays billed entries
entry_display_hash_totalsbitNOT NULLDisplays hash totals
entry_new_row_at_topbitNOT NULLShows the new row at the top when true, at the bottom when false.
entry_allow_simultaneous_timersbitNOT NULLAllow as many timers running at the same time as they want.
entry_startup_tabnvarchar (100)NOT NULLWhich tab to start on.
staff_dashboard_layoutnvarchar (-1)NOT NULLLayout of the Staff Dashboard stored as XML
client_dashboard_layoutnvarchar (-1)NOT NULLLayout of the Client Dashboard stored as XML
firm_dashboard_layoutnvarchar (-1)NOT NULLLayout of the Firm Dashboard stored as XML
billing__billing_method_KEYintNOT NULLBilling by Client or Engagement
billing_show_wip_during_selectionbitNOT NULLWIP column should show in the billing selection list and be populated with WIP balances.
billing_implied_decimalbitNOT NULLAutomatically inserts decimal point at end of amount
billing_startup_tabnvarchar (100)NOT NULLStartup tab of Detail Billing
billing__user_preference_default_invoice_date_KEYintDefault Invoice date for Detail Billing.
billing_standard__rounding_method_KEYintNOT NULLRounding method for Bill At Standard
billing_standard_rounding_incrementdecimal (4, 2)NOT NULLRounding increment for Bill At Standard
receipt_entry__user_preference_default_sheet_date_KEYintDefault Control Date.
receipt_entry_sheet_date_skipbitNOT NULLSkips Control Date.
receipt_entry__bank_account_KEYintDefault Bank.
receipt_entry_bank_skipbitNOT NULLSkips Bank.
receipt_entry_bank_hidebitNOT NULLHides Bank.
receipt_entry__user_preference_default_entry_date_KEYintDefault Date.
receipt_entry_entry_date_skipbitNOT NULLSkips Date.
receipt_entry_entry_date_hidebitNOT NULLHides Date.
receipt_entry__ledger_entry_type_KEYintDefault Type.
receipt_entry_ledger_entry_type_skipbitNOT NULLSkips Type.
receipt_entry_reference_skipbitNOT NULLSkips Reference.
receipt_entry_reference_hidebitNOT NULLHides Reference.
receipt_entry_commentnvarchar (-1)NOT NULLDefault Comment.
receipt_entry_comment_skipbitNOT NULLSkips Comment.
receipt_entry_comment_hidebitNOT NULLHides Comment.
receipt_entry_auto_apply_to_oldestbitNOT NULLAutomatically apply new receipts to the oldest outstanding items.
receipt_entry_display_applied_amounts_screenbitNOT NULLAutomatically display the Applied Amounts form after they enter an amount.
receipt_entry_implied_decimalbitNOT NULLAutomatically inserts decimal point at end of Amount.
receipt_entry_display_hash_totalsbitNOT NULLDisplays hash totals.
receipt_entry_startup_tabnvarchar (100)NOT NULLWhich tab to start on.
entry_sheet_date_skipbitNOT NULLSkips the SheetDate entry field on the entry screen.
statement_include_debitsbitNOT NULLIncludes clients with debits if they meet over_balance or over_age
statement_include_debits_over_balancedecimal (17, 2)NOT NULLIncludes a client if their balance is greater than this.
statement_include_debits_over_ageintNOT NULLIncludes a client if the client has a debit older than this many days.
statement_include_creditsbitNOT NULLIncludes clients that have a credit balance.
statement_include_zero_balance_with_current_activitybitNOT NULLIncludes clients that have a zero balance but had recent activity.
statement_exclude_current_invoice_activity_clientsbitNOT NULLExcludes clients that have recently been invoiced.
create_date_utcdatetimeNOT NULL
billing_auto_apply_open_creditsbitNOT NULLDetermines if we automatically apply any open credits when saving a detail billing decision.
billing_prompt_to_apply_open_creditsbitNOT NULLDetermines if we prompt to apply credits when saving in the Billing Details screen.
enable_desktop_alerts_for_notificationsbitNOT NULLEnables desktop alerts for notifications.
entry_display_task_selectionbitNOT NULLAutomatically displays the task selection screen after the project is selected
entry_start_project_timersbitNOT NULLSpecifies if timers are to be started when solutions are launched from Projects/Tasks
entry_project_template_skipbitNOT NULLSpecifies Project field is to be skipped on the Time and Expense Entry screen
entry_project_template_hidebitNOT NULLSpecifies Project field is to be hidden on the Time and Expense Entry screen
entry_start_phone_timersbitNOT NULLSpecifies if timers are to be started when solutions are launched from Phone Calls
entry_client_description_hidebitNOT NULL
entry_engagement_description_hidebitNOT NULL
entry_project_description_hidebitNOT NULL
entry_activity_description_hidebitNOT NULL
receipt_entry_client_description_hidebitNOT NULL
receipt_entry_bank_description_hidebitNOT NULL
receipt_entry_type_description_hidebitNOT NULL
home_dashboard_layoutnvarchar (-1)NOT NULLLayout of the Home Dashboard stored as XML
show_desktop_notifications_until_closedbitNOT NULL
billing_mark_zero_invoice_as_printedbitNOT NULL
billing_auto_select_child_clientsbitNOT NULL
entry_remote_time_entry_enabledbitNOT NULLEnables the ability to use the quick Remote Entry export feature
entry_remote_time_entry__filter_KEYintKEY of the filter used to narrow the clients being exported for Remote Entry
entry_accumulate_time_before_roundingbitNOT NULL
receipt_entry_adjustment__bank_account_KEYintDefault Bank for adjusting entries (CCR, NSF, DM, CM, WO).
receipt_entry_adjustment_bank_hidebitNOT NULLHides Bank for adjusting entries (CCR, NSF, DM, CM, WO).
receipt_entry_adjustment_bank_skipbitNOT NULLSkips Bank for adjusting entries (CCR, NSF, DM, CM, WO).
receipt_entry_adjustment_bank_description_hidebitNOT NULLHides Bank description for adjusting entries (CCR, NSF, DM, CM, WO).
entry_custom_fields_hidebitNOT NULL
entry_custom_fields_skipbitNOT NULL
entry_display_custom_fieldsbitNOT NULL
entry_auto_fill_from_lastbitNOT NULL
billing_client_description_hidebitNOT NULL
billing_engagement_description_hidebitNOT NULL
billing_project_description_hidebitNOT NULL
billing_activity_description_hidebitNOT NULL
billing_comment_hidebitNOT NULL
billing_biller_note_hidebitNOT NULL
entry_education_course_selection_hidebitNOT NULL
entry_education_course_selection_skipbitNOT NULL
entry_display_education_course_selectionbitNOT NULL
billing__user_preference_default_wip_date_KEYintNOT NULLKey of the User Preference Default Wip Date that this row is assigned.
billing__custom_wip_datesmalldatetimeThe billing default custom wip date.
urgent_high_priority_unassignedbitNOT NULLWhen true the urgent tab includes high priority schedule items with no schedule item assignments
urgent_high_priority_unscheduledbitNOT NULLWhen true the urgent tab includes high priority schedule items with no schedule entries
urgent_target_start_past_unassignedbitNOT NULLWhen true the urgent tab includes schedule items where the target start date has past and does not have any schedule item assignments
urgent_target_start_past_unscheduledbitNOT NULLWhen true the urgent tab includes schedule items where the target start date has past and does not have any schedule entries
urgent_past_duebitNOT NULLWhen true the urgent tab includes schedule items that are past due
urgent_due_within_unassignedbitNOT NULLWhen true the urgent tab includes schedule items where the target complete date is less than today plus urgent_due_within_unassigned_days and does not have any schedule item assignments
urgent_due_within_unscheduledbitNOT NULLWhen true the urgent tab includes schedule items where the target complete date is less than today plus urgent_due_within_unscheduled_days and does not have any schedule entries
urgent__filter_KEYintKEY of the filter used to narrow the schedule items to be displayed in the urgent tab
urgent_due_within_unassigned_daysintNOT NULLWhen urgent_target_start_past_unassigned is true, the urgent tab includes schedule items where the target complete date is less than today plus urgent_due_within_unassigned_days and does not have any schedule item assignments
urgent_due_within_unscheduled_daysintNOT NULLWhen urgent_target_start_past_unscheduled is true, the urgent tab includes schedule items where the target complete date is less than today plus urgent_due_within_unscheduled_days and does not have any schedule entries
urgent_overscheduledbitNOT NULLWhen true the urgent tab includes schedule items where the number of total scheduled hours for the item is greater than the remaining hours of work for the item
urgent_tab_enabledbitNOT NULLWhen true the urgent tab will be displayed in scheduling screens
receipt_entry_invoice_search_skipbitNOT NULLWhen true the invoice search column in receipt entry will be skipped
receipt_entry_invoice_search_hidebitNOT NULLWhen true the invoice search column in receipt entry will be hidden
entry_task_skipbitNOT NULLWhen true the task dropdown column in time entry will be skipped
entry_task_hidebitNOT NULLWhen true the task dropdown column in time entry will be hidden
entry_task_selection_button_skipbitNOT NULLWhen true the task selection button column in time entry will be skipped
entry_task_selection_button_hidebitNOT NULLWhen true the task selection button column in time entry will be hidden
entry_staff_description_hidebitNOT NULLWhen true the staff description column in time entry will be hidden
billing_staff_description_hidebitNOT NULLWhen true the staff description column in billing will be hidden
receipt_entry_custom_fields_hidebitNOT NULLWhen true the custom fields button column in receipt entry will be hidden
receipt_entry_custom_fields_skipbitNOT NULLWhen true the custom fields button column in receipt entry will be skipped
receipt_entry_display_custom_fieldsbitNOT NULLWhen true the custom fields button column in receipt entry will be auto-displayed
receipt_entry_links_hidebitNOT NULLWhen true the links button column in receipt entry will be hidden
receipt_entry_links_skipbitNOT NULLWhen true the links button column in receipt entry will be skipped
receipt_entry_display_linksbitNOT NULLWhen true the links button column in receipt entry will be auto-displayed
entry_project_solution_button_hidebitNOT NULLWhen true the project solution button column in time entry will be hidden
entry_project_solution_button_skipbitNOT NULLWhen true the project solution button column in time entry will be skipped
entry_task_solution_button_hidebitNOT NULLWhen true the task solution button column in receipt entry will be hidden
entry_task_solution_button_skipbitNOT NULLWhen true the task solution button column in time entry will be skipped
entry_auto_check_spellingbitNOT NULL
billing_auto_check_spellingbitNOT NULL
receipt_entry_auto_check_spellingbitNOT NULL
Primary key
NameColumnsDescription
PK_User_Preference$user_preference_KEYuser_preference_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_User_Preference$staff_KEYstaff_KEY
Indexes
NameColumnsDescription
IX_User_Preference$billing__billing_method_KEYbilling__billing_method_KEYIndex supports foreign key FK_User_Preference__Billing_Method__billing__billing_method_KEY
IX_User_Preference$billing__user_preference_default_invoice_date_KEYbilling__user_preference_default_invoice_date_KEYIndex supports foreign key FK_User_Preference__User_Preference_Default_Invoice_Date__billing__user_preference_default_invoice_date_KEY
IX_User_Preference$billing__user_preference_default_wip_date_KEYbilling__user_preference_default_wip_date_KEYIndex supports foreign key FK_User_Preference__User_Preference_Default_Wip_Date__billing__user_preference_default_wip_date_KEY
IX_User_Preference$billing_standard__rounding_method_KEYbilling_standard__rounding_method_KEYIndex supports foreign key FK_User_Preference__Rounding_Method__billing_standard__rounding_method_KEY
IX_User_Preference$entry__client_KEYentry__client_KEYIndex supports foreign key FK_User_Preference__Client__entry__client_KEY
IX_User_Preference$entry__engagement_template_KEYentry__engagement_template_KEYIndex supports foreign key FK_User_Preference__Engagement_Template__entry__engagement_template_KEY
IX_User_Preference$entry__rounding_method_KEYentry__rounding_method_KEYIndex supports foreign key FK_User_Preference__Rounding_Method__entry__rounding_method_KEY
IX_User_Preference$entry__time_style_KEYentry__time_style_KEYIndex supports foreign key FK_User_Preference__Time_Style__entry__time_style_KEY
IX_User_Preference$entry__user_preference_default_entry_date_KEYentry__user_preference_default_entry_date_KEYIndex supports foreign key FK_User_Preference__User_Preference_Default_Entry_Date__entry__user_preference_default_entry_date_KEY
IX_User_Preference$entry__user_preference_default_sheet_date_KEYentry__user_preference_default_sheet_date_KEYIndex supports foreign key FK_User_Preference__User_Preference_Default_Sheet_Date__entry__user_preference_default_sheet_date_KEY
IX_User_Preference$entry_expense__activity_KEYentry_expense__activity_KEYIndex supports foreign key FK_User_Preference__Activity__entry_expense__activity_KEY
IX_User_Preference$entry_expense__billing_rate_type_KEYentry_expense__billing_rate_type_KEYIndex supports foreign key FK_User_Preference__Billing_Rate_Type__entry_expense__billing_rate_type_KEY
IX_User_Preference$entry_remote_time_entry__filter_KEYentry_remote_time_entry__filter_KEYIndex supports foreign key FK_User_Preference__Filter__entry_remote_time_entry__filter_KEY
IX_User_Preference$entry_time__activity_KEYentry_time__activity_KEYIndex supports foreign key FK_User_Preference__Activity__entry_time__activity_KEY
IX_User_Preference$entry_time__billing_rate_type_KEYentry_time__billing_rate_type_KEYIndex supports foreign key FK_User_Preference__Billing_Rate_Type__entry_time__billing_rate_type_KEY
IX_User_Preference$receipt_entry__bank_account_KEYreceipt_entry__bank_account_KEYIndex supports foreign key FK_User_Preference__Bank_Account__receipt_entry__bank_account_KEY
IX_User_Preference$receipt_entry__ledger_entry_type_KEYreceipt_entry__ledger_entry_type_KEYIndex supports foreign key FK_User_Preference__Ledger_Entry_Type__receipt_entry__ledger_entry_type_KEY
IX_User_Preference$receipt_entry__user_preference_default_entry_date_KEYreceipt_entry__user_preference_default_entry_date_KEYIndex supports foreign key FK_User_Preference__User_Preference_Default_Entry_Date__receipt_entry__user_preference_default_entry_date_KEY
IX_User_Preference$receipt_entry__user_preference_default_sheet_date_KEYreceipt_entry__user_preference_default_sheet_date_KEYIndex supports foreign key FK_User_Preference__User_Preference_Default_Sheet_Date__receipt_entry__user_preference_default_sheet_date_KEY
IX_User_Preference$receipt_entry_adjustment__bank_account_KEYreceipt_entry_adjustment__bank_account_KEYIndex supports foreign key FK_User_Preference__Bank_Account__receipt_entry_adjustment__bank_account_KEY
IX_User_Preference$urgent__filter_KEYurgent__filter_KEYIndex supports foreign key FK_User_Preference__Filter__urgent__filter_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_User_Preference__Activity__entry_expense__activity_KEYentry_expense__activity_KEYActivity
FK_User_Preference__Activity__entry_time__activity_KEYentry_time__activity_KEYActivity
FK_User_Preference__Bank_Account__receipt_entry__bank_account_KEYreceipt_entry__bank_account_KEYBank_Account
FK_User_Preference__Bank_Account__receipt_entry_adjustment__bank_account_KEYreceipt_entry_adjustment__bank_account_KEYBank_Account
FK_User_Preference__Billing_Rate_Type__entry_expense__billing_rate_type_KEYentry_expense__billing_rate_type_KEYBilling_Rate_Type
FK_User_Preference__Billing_Rate_Type__entry_time__billing_rate_type_KEYentry_time__billing_rate_type_KEYBilling_Rate_Type
FK_User_Preference__Client__entry__client_KEYentry__client_KEYClient
FK_User_Preference__Engagement_Template__entry__engagement_template_KEYentry__engagement_template_KEYEngagement_Template
FK_User_Preference__Filter__entry_remote_time_entry__filter_KEYentry_remote_time_entry__filter_KEYFilter
FK_User_Preference__Filter__urgent__filter_KEYurgent__filter_KEYFilteron delete set null;
FK_User_Preference__Ledger_Entry_Type__receipt_entry__ledger_entry_type_KEYreceipt_entry__ledger_entry_type_KEYLedger_Entry_Type
FK_User_Preference__Staff__staff_KEYstaff_KEYStaffon delete cascade;
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_User_Preference_Custom_Field_Column__User_Preference__user_preference_KEYuser_preference_KEYUser_Preference_Custom_Field_Columnon delete cascade;

Schema diagram