Table: dbo.Import_User_Preference
This table stores the import user preferences on a per staff member basis.
Columns
NameTypeConstraintsDescription
user_preference_KEYint (4)NOT NULLPrimary key and foreign key to the parent user preferences.
show_all_mapping_bank_accountbit (1)NOT NULLoption to show all mappings on the bank account mapping screen. True means show all mappings. False means show only the mappings that require user attention.
show_all_mapping_chart_of_accountbit (1)NOT NULLoption to show all mappings on the chart of account mapping screen. True means show all mappings, False means only show the mappings that require user attention.
show_all_mapping_employeebit (1)NOT NULLoption to show all mappings on the employees mapping screen. True means show all mappings, False means only show the mappings that require user attention.
show_all_mapping_taxbit (1)NOT NULLoption to show all mappings on the tax mapping screen. True means show all mappings, False means only show the mappings that require user attention.
show_all_mapping_vendorbit (1)NOT NULLoption to show all mappings on the vendor mapping screen. True means show all mappings, False means only show the mappings that require user attention.
show_all_mapping_payroll_itembit (1)NOT NULLoption to show all mappings on the payroll item mapping screen. True means show all mappings, False means only show the mappings that require user attention.
skip_optional_data_mapping_screensbit (1)NOT NULLWhen this is true, all optional data mapping screens are skipped on the import client data wizard when importing data.
Primary key
NameColumnsDescription
PK_Import_User_Preference$user_preference_KEYuser_preference_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Import_User_Preference__User_Preference__user_preference_KEYuser_preference_KEYUser_Preference (user_preference_KEY)

Schema diagram