Table: dbo.Enter_Transaction_User_Preference
This table is used to hold options for the data entry of Enter Transaction.
Columns
Name | Type | Constraints | Description
enter_transaction_user_preference_KEY | int (4) | NOT NULL | Primary Key
user_preference_KEY | int (4) | NOT NULL | Foreign key to the User_Preference table that these preferences pertain to.
client_KEY | int (4) | NOT NULL | Foreign key to the client that these options pertain to.
enter_transaction_data_entry_mode_KEY | int (4) | NOT NULL | The data entry type for Enter Transaction
default__checkbook_KEY | int (4) |  | Foreign key to the checkbook that will be the default for Enter Transaction.
default__journal_KEY | int (4) | NOT NULL | Foreign key to the journal that will be the default for Enter Transaction.
default__gl_transaction_type_KEY | int (4) | NOT NULL | The default for the GL Transaction Type for Enter Transaction from the GL_Transactions_Type_View.
enter_transaction_default_distribution_description_type_KEY | int (4) |  | The type of description to default the distributions to in Enter Transactions.
include_inactive_employees | bit (1) | NOT NULL | Indicates that the user would like to include inactive employees in the employee list we provide during payroll check entry.
suppress_gl_account_verification | bit (1) | NOT NULL | True if we are suppressing the gl account verification message.
convert_hours_to_decimal | bit (1) | NOT NULL | True if we are converting hours entered to decimal.
suppress_benefit_accrual_verification | bit (1) | NOT NULL | True if we don't want to verify number of hours exceeding hours available.
display_taxes_with_zero_amounts | bit (1) | NOT NULL | Flag indicating that the display of zero amount taxes is desired in the enter transactions screen.
default_date_option_KEY | int (4) | NOT NULL | Foreign key to the default date option table
payroll_transaction__default_date_option_KEY | int (4) | NOT NULL | Foreign key to the default date option table specific to the payroll transactions that determines if a default date will be supplied to payroll transactions.
do_not_auto_fill_previous_value | bit (1) | NOT NULL | Boolean that tells us if the user wants to turn off the automatic defaulting of things like the reference, id/payee, and description fields.
increment_journal_entry_reference_number | bit (1) | NOT NULL | Indicates that the user wants to automatically increment the journal entry reference number.
increment_journal_entry_reference_by | nvarchar (18) | NOT NULL | The amount the user wants to increment the journal entry reference number by.
compute_hash_with_gl_account_segment_KEY | int (4) |  | Tells us what segment to total for the GL acount number hash. If null, then use the whole GL account number.
only_clear_hash_totals_when_application_is_closed | bit (1) | NOT NULL | Boolean that tells us if we're automatically clearing the hash totals when starting a new application session.
compute_hash_total_for_count | bit (1) | NOT NULL | Boolean that tells us if we're to include a record 'Count' in our hash totals.
compute_hash_total_for_reference | bit (1) | NOT NULL | Boolean that tells us if we're to include 'Reference' in our hash totals.
compute_hash_total_for_amount | bit (1) | NOT NULL | Boolean that tells us if we're to include 'Amount' in our hash totals.
compute_hash_total_for_debit_credit | bit (1) | NOT NULL | Boolean that tells us if we're to include 'Debit/Credit' in our hash totals.
compute_hash_total_for_gl_account | bit (1) | NOT NULL | Boolean that tells us if we're to include 'GL account' in our hash totals.
payroll_check_display_detail_field_is_visible | bit (1) | NOT NULL | if this is true then for payroll checks, the display field should be visible in Enter Transactions.
payroll_check_display_regular_hours_field_is_visible | bit (1) | NOT NULL | if this is true then for payroll checks, the regular hours field should be visible in Enter Transactions.
payroll_check_display_overtime_hours_field_is_visible | bit (1) | NOT NULL | if this is true then for payroll checks, the overtime hours field should be visible in Enter Transactions.
payroll_check_display_doubletime_hours_field_is_visible | bit (1) | NOT NULL | if this is true then for payroll checks, the doubletime hours field should be visible in Enter Transactions.
payroll_check_display_accruable_benefits_field_is_visible | bit (1) | NOT NULL | if this is true then for payroll checks, the accruable benefits field should be visible in Enter Transactions.
payroll_check_display_rate_field_is_visible | bit (1) | NOT NULL | if this is true then for payroll checks, the rate field should be visible in Enter Transactions.
payroll_check_display_amount_field_is_visible | bit (1) | NOT NULL | if this is true then for payroll checks, the amount field should be visible in Enter Transactions.
payroll_check_display_detail_field_is_tab_stop | bit (1) | NOT NULL | if this is true then for payroll checks, the display field should be a tab stop in Enter Transactions.
payroll_check_display_regular_hours_field_is_tab_stop | bit (1) | NOT NULL | if this is true then for payroll checks, the regular hours field should be a tab stop in Enter Transactions.
payroll_check_display_overtime_hours_field_is_tab_stop | bit (1) | NOT NULL | if this is true then for payroll checks, the overtime hours field should be a tab stop in Enter Transactions.
payroll_check_display_doubletime_hours_field_is_tab_stop | bit (1) | NOT NULL | if this is true then for payroll checks, the doubletime hours field should be a tab stop in Enter Transactions.
payroll_check_display_accruable_benefits_field_is_tab_stop | bit (1) | NOT NULL | if this is true then for payroll checks, the accruable benefits field should be a tab stop in Enter Transactions.
payroll_check_display_rate_field_is_tab_stop | bit (1) | NOT NULL | if this is true then for payroll checks, the rate field should be a tab stop in Enter Transactions.
payroll_check_display_amount_field_is_tab_stop | bit (1) | NOT NULL | if this is true then for payroll checks, the amount field should be a tab stop in Enter Transactions.
template_retrieval__check_template_usage_preference_setting_KEY | tinyint (1) | NOT NULL | stores the option chosen for payroll check template retrieval; FK to the Check_Template_Usage_Preference_Setting table. This option tells whether or not to use a template to populate an employee payroll check when an employee check is started in Enter Transactions. The options are Always, Never, and Prompt the user.
template_update__check_template_usage_preference_setting_KEY | tinyint (1) | NOT NULL | stores the option chosen for payroll check template updates; FK to the Check_Template_Usage_Preference_Setting table. This option tells whether or not to update a template after a payroll check has been updated. The options are Always, Never, and Prompt the user.
increment_deposit_reference_number | bit (1) | NOT NULL | True if the user has chosen to increment the deposit reference number.
increment_deposit_reference_by | nvarchar (18) | NOT NULL | The amount to increment the deposit reference number by. Represented as nvarchar to accomodate for string manipulation needed when incrementing reference numbers. An empty string will not increment the reference number.
increment_payment_reference_number | bit (1) | NOT NULL | True if the user has chosen to increment the payment reference number.
increment_payment_reference_by | nvarchar (18) | NOT NULL | The amount to increment the payment reference number by. Represented as nvarchar to accomodate for string manipulation needed when incrementing reference numbers. An empty string will not increment the reference number.

Primary key
Name | Columns | Description
PK_Enter_Transaction_User_Preference | enter_transaction_user_preference_KEY |
Unique constraints
Name | Columns | Description
UK_Enter_Transaction_User_Preference$user_preference_KEY$client_KEY | user_preference_KEY, client_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Enter_Transaction_User_Preference$template_retrieval__check_template_usage_preference_setting_KEY | template_retrieval__check_template_usage_preference_setting_KEY | Check_Template_Usage_Preference_Setting (check_template_usage_preference_setting_KEY) |
FK_Enter_Transaction_User_Preference$template_update__check_template_usage_preference_setting_KEY | template_update__check_template_usage_preference_setting_KEY | Check_Template_Usage_Preference_Setting (check_template_usage_preference_setting_KEY) |
FK_Enter_Transaction_User_Preference__Checkbook__default__checkbook_KEY | default__checkbook_KEY | Checkbook (checkbook_KEY) |
FK_Enter_Transaction_User_Preference__Client__client_KEY | client_KEY | Client (client_KEY) |
FK_Enter_Transaction_User_Preference__Default_Date_Option__default_date_option_KEY | default_date_option_KEY | Default_Date_Option (default_date_option_KEY) |
FK_Enter_Transaction_User_Preference__Default_Date_Option__payroll_transaction__default_date_option_KEY | payroll_transaction__default_date_option_KEY | Default_Date_Option (default_date_option_KEY) |
FK_Enter_Transaction_User_Preference__Enter_Transaction_Data_Entry_Mode__enter_transaction_data_entry_mode_KEY | enter_transaction_data_entry_mode_KEY | Enter_Transaction_Data_Entry_Mode (enter_transaction_data_entry_mode_KEY) |
FK_Enter_Transaction_User_Preference__Enter_Transaction_Default_Distribution_Description_Type__enter_transaction_default_distrib | enter_transaction_default_distribution_description_type_KEY | Enter_Transaction_Default_Distribution_Description_Type (enter_transaction_default_distribution_description_type_KEY) |
FK_Enter_Transaction_User_Preference__GL_Account_Segment__compute_hash_with_gl_account_segment_KEY | compute_hash_with_gl_account_segment_KEY | GL_Account_Segment (gl_account_segment_KEY) |
FK_Enter_Transaction_User_Preference__Journal__default__journal_KEY | default__journal_KEY | Journal (journal_KEY) |
FK_Enter_Transaction_User_Preference__User_Preference__user_preference_KEY | user_preference_KEY | User_Preference (user_preference_KEY) |