Table: dbo.Enter_Transaction_User_Preference
This table is used to hold options for the data entry of Enter Transaction.
Columns
NameTypeConstraintsDescription
enter_transaction_user_preference_KEYint (4)NOT NULLPrimary Key
user_preference_KEYint (4)NOT NULLForeign key to the User_Preference table that these preferences pertain to.
client_KEYint (4)NOT NULLForeign key to the client that these options pertain to.
enter_transaction_data_entry_mode_KEYint (4)NOT NULLThe data entry type for Enter Transaction
default__checkbook_KEYint (4)Foreign key to the checkbook that will be the default for Enter Transaction.
default__journal_KEYint (4)NOT NULLForeign key to the journal that will be the default for Enter Transaction.
default__gl_transaction_type_KEYint (4)NOT NULLThe default for the GL Transaction Type for Enter Transaction from the GL_Transactions_Type_View.
enter_transaction_default_distribution_description_type_KEYint (4)The type of description to default the distributions to in Enter Transactions.
include_inactive_employeesbit (1)NOT NULLIndicates that the user would like to include inactive employees in the employee list we provide during payroll check entry.
suppress_gl_account_verificationbit (1)NOT NULLTrue if we are suppressing the gl account verification message.
convert_hours_to_decimalbit (1)NOT NULLTrue if we are converting hours entered to decimal.
suppress_benefit_accrual_verificationbit (1)NOT NULLTrue if we don't want to verify number of hours exceeding hours available.
display_taxes_with_zero_amountsbit (1)NOT NULLFlag indicating that the display of zero amount taxes is desired in the enter transactions screen.
default_date_option_KEYint (4)NOT NULLForeign key to the default date option table
payroll_transaction__default_date_option_KEYint (4)NOT NULLForeign 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_valuebit (1)NOT NULLBoolean 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_numberbit (1)NOT NULLIndicates that the user wants to automatically increment the journal entry reference number.
increment_journal_entry_reference_bynvarchar (18)NOT NULLThe amount the user wants to increment the journal entry reference number by.
compute_hash_with_gl_account_segment_KEYint (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_closedbit (1)NOT NULLBoolean that tells us if we're automatically clearing the hash totals when starting a new application session.
compute_hash_total_for_countbit (1)NOT NULLBoolean that tells us if we're to include a record 'Count' in our hash totals.
compute_hash_total_for_referencebit (1)NOT NULLBoolean that tells us if we're to include 'Reference' in our hash totals.
compute_hash_total_for_amountbit (1)NOT NULLBoolean that tells us if we're to include 'Amount' in our hash totals.
compute_hash_total_for_debit_creditbit (1)NOT NULLBoolean that tells us if we're to include 'Debit/Credit' in our hash totals.
compute_hash_total_for_gl_accountbit (1)NOT NULLBoolean that tells us if we're to include 'GL account' in our hash totals.
payroll_check_display_detail_field_is_visiblebit (1)NOT NULLif this is true then for payroll checks, the display field should be visible in Enter Transactions.
payroll_check_display_regular_hours_field_is_visiblebit (1)NOT NULLif this is true then for payroll checks, the regular hours field should be visible in Enter Transactions.
payroll_check_display_overtime_hours_field_is_visiblebit (1)NOT NULLif this is true then for payroll checks, the overtime hours field should be visible in Enter Transactions.
payroll_check_display_doubletime_hours_field_is_visiblebit (1)NOT NULLif this is true then for payroll checks, the doubletime hours field should be visible in Enter Transactions.
payroll_check_display_accruable_benefits_field_is_visiblebit (1)NOT NULLif this is true then for payroll checks, the accruable benefits field should be visible in Enter Transactions.
payroll_check_display_rate_field_is_visiblebit (1)NOT NULLif this is true then for payroll checks, the rate field should be visible in Enter Transactions.
payroll_check_display_amount_field_is_visiblebit (1)NOT NULLif this is true then for payroll checks, the amount field should be visible in Enter Transactions.
payroll_check_display_detail_field_is_tab_stopbit (1)NOT NULLif 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_stopbit (1)NOT NULLif 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_stopbit (1)NOT NULLif 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_stopbit (1)NOT NULLif 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_stopbit (1)NOT NULLif 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_stopbit (1)NOT NULLif 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_stopbit (1)NOT NULLif 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_KEYtinyint (1)NOT NULLstores 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_KEYtinyint (1)NOT NULLstores 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_numberbit (1)NOT NULLTrue if the user has chosen to increment the deposit reference number.
increment_deposit_reference_bynvarchar (18)NOT NULLThe 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_numberbit (1)NOT NULLTrue if the user has chosen to increment the payment reference number.
increment_payment_reference_bynvarchar (18)NOT NULLThe 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
NameColumnsDescription
PK_Enter_Transaction_User_Preferenceenter_transaction_user_preference_KEY
Unique constraints
NameColumnsDescription
UK_Enter_Transaction_User_Preference$user_preference_KEY$client_KEYuser_preference_KEY, client_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Enter_Transaction_User_Preference$template_retrieval__check_template_usage_preference_setting_KEYtemplate_retrieval__check_template_usage_preference_setting_KEYCheck_Template_Usage_Preference_Setting (check_template_usage_preference_setting_KEY)
FK_Enter_Transaction_User_Preference$template_update__check_template_usage_preference_setting_KEYtemplate_update__check_template_usage_preference_setting_KEYCheck_Template_Usage_Preference_Setting (check_template_usage_preference_setting_KEY)
FK_Enter_Transaction_User_Preference__Checkbook__default__checkbook_KEYdefault__checkbook_KEYCheckbook (checkbook_KEY)
FK_Enter_Transaction_User_Preference__Client__client_KEYclient_KEYClient (client_KEY)
FK_Enter_Transaction_User_Preference__Default_Date_Option__default_date_option_KEYdefault_date_option_KEYDefault_Date_Option (default_date_option_KEY)
FK_Enter_Transaction_User_Preference__Default_Date_Option__payroll_transaction__default_date_option_KEYpayroll_transaction__default_date_option_KEYDefault_Date_Option (default_date_option_KEY)
FK_Enter_Transaction_User_Preference__Enter_Transaction_Data_Entry_Mode__enter_transaction_data_entry_mode_KEYenter_transaction_data_entry_mode_KEYEnter_Transaction_Data_Entry_Mode (enter_transaction_data_entry_mode_KEY)
FK_Enter_Transaction_User_Preference__Enter_Transaction_Default_Distribution_Description_Type__enter_transaction_default_distribenter_transaction_default_distribution_description_type_KEYEnter_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_KEYcompute_hash_with_gl_account_segment_KEYGL_Account_Segment (gl_account_segment_KEY)
FK_Enter_Transaction_User_Preference__Journal__default__journal_KEYdefault__journal_KEYJournal (journal_KEY)
FK_Enter_Transaction_User_Preference__User_Preference__user_preference_KEYuser_preference_KEYUser_Preference (user_preference_KEY)

Schema diagram