Table: dbo.Export_User_Preference
This table stores export user preferences.
Columns
NameTypeConstraintsDescription
staff_KEYint (4)NOT NULLPrimary key and foreign key to the parent staff table.
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 rows 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 rows 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 rows 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 rows that require user attention.
skip_optional_data_mapping_screensbit (1)NOT NULLWhen 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_codebit (1)NOT NULLOption 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
NameColumnsDescription
PK_Export_User_Preference$staff_KEYstaff_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Export_User_Preference__Staff__staff_KEYstaff_KEYStaff (staff_KEY)

Schema diagram