Table: dbo.Import_User_Preference
This table stores the import user preferences on a per staff member basis.
Columns
Name | Type | Constraints | Description
user_preference_KEY | int (4) | NOT NULL | Primary key and foreign key to the parent user preferences.
show_all_mapping_bank_account | bit (1) | NOT NULL | option 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_account | bit (1) | NOT NULL | option 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_employee | bit (1) | NOT NULL | option 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_tax | bit (1) | NOT NULL | option 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_vendor | bit (1) | NOT NULL | option 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_item | bit (1) | NOT NULL | option 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_screens | bit (1) | NOT NULL | When this is true, all optional data mapping screens are skipped on the import client data wizard when importing data.

Primary key
Name | Columns | Description
PK_Import_User_Preference$user_preference_KEY | user_preference_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Import_User_Preference__User_Preference__user_preference_KEY | user_preference_KEY | User_Preference (user_preference_KEY) |