Table: dbo.Export_User_Preference
This table stores export user preferences.
Columns
Name | Type | Constraints | Description
staff_KEY | int (4) | NOT NULL | Primary key and foreign key to the parent staff table.
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 rows 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 rows 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 rows 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 rows 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 export client data wizard when exporting data. Optional screens are screens that do not require user attention during the export because choices made previously are still valid and there is nothing new requiring user attention.
show_all_mapping_segment_code | bit (1) | NOT NULL | Option to show all mappings on the gl account segment code mapping screen. True means show all mappings, False means only show the mappings rows that require user attention.

Primary key
Name | Columns | Description
PK_Export_User_Preference$staff_KEY | staff_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Export_User_Preference__Staff__staff_KEY | staff_KEY | Staff (staff_KEY) |