SV00910 - SV_User_Preference_MSTR | GP Tables

Column	Type	Shared With
Wennsoft_Affiliate	char(15)	289 tables
Wennsoft_Region	char(15)	289 tables
Wennsoft_Branch	char(15)	288 tables
USERID	char(15)	338 tables
Technician_ID	char(15)	144 tables
Technician_Team	char(15)	146 tables
Technician	char(11)	33 tables
Service_Area	char(15)	13 tables
USERNAME	char(31)	10 tables
Network_User_Name	char(255)	-
Security_Level	char(15)	2 tables
WS_Preference_Affiliate	char(15)	-
WS_Preference_Region	char(15)	-
WS_Preference_Branch	char(15)	-
STRTDATE	datetime	23 tables
ENDDATE	datetime	16 tables
Type_Call_Short	char(3)	10 tables
Type_of_Call	char(15)	6 tables
Status_of_Call	char(11)	11 tables
Appointment_Status	char(11)	5 tables
Service_Call_Check_Box	tinyint	-
Closed_Call_Check_Box	tinyint	-
Completed_Call_Check_Box	tinyint	-
MC_Call_Check_Box	tinyint	-
MCC_Call_Check_Box	tinyint	-
Job_Check_Box	tinyint	-
Activity_Check_Box	tinyint	-
Quote_Check_Box	tinyint	-
Billable_Check_Box	tinyint	3 tables
Priority	smallint	3 tables
PriorityUpDown	smallint	1 tables
Meter_Checkbox	tinyint	3 tables
Wennbox1	tinyint	2 tables
Wennbox2	tinyint	2 tables
Wenngroup1	smallint	2 tables
Wenngroup2	smallint	2 tables
EMPLOYID	char(15)	63 tables
VENDORID	char(15)	107 tables
CUSTNMBR	char(15)	230 tables
User_Define_1a	char(31)	43 tables
User_Define_2a	char(31)	32 tables
MODIFDT	datetime	394 tables
Modified_Time	datetime	326 tables
MDFUSRID	char(15)	349 tables
Time_Zone	char(3)	273 tables
Time_Zone_Tag	char(5)	11 tables
SV_Language_ID	smallint	245 tables
WSReserved_CB1	tinyint	326 tables
WSReserved_CB2	tinyint	325 tables
WSReserved_CB3	tinyint	320 tables
WSReserved_CB4	tinyint	317 tables
WSReserved_CB5	tinyint	318 tables
WSReserved_STR1	char(11)	253 tables
WSReserved_STR2	char(11)	253 tables
Allow_Cust_Add	tinyint	-
Allow_Equipment_Add	tinyint	-
Allow_MC_Add	tinyint	-
Allow_Cust_Contract_Add	tinyint	-
Allow_Global_Cust_Add	tinyint	-
Edit_Globl_Rec_Id_Filtrs	tinyint	-
Allow_Cust_Location_Add	tinyint	-
Create_Calls_SV_Requests	tinyint	-
Service_Option_Box_1	tinyint	2 tables
Service_Option_Box_2	tinyint	2 tables
Service_Option_Box_3	tinyint	2 tables
Service_Option_Box_4	tinyint	2 tables
Service_Option_Box_5	tinyint	2 tables
Service_Option_Box_6	tinyint	2 tables
Service_Option_Box_7	tinyint	2 tables
Service_Option_Box_8	tinyint	2 tables
Service_Option_Box_9	tinyint	2 tables
Service_Option_Box_10	tinyint	2 tables
DEX_ROW_ID	int auto number (1,1)	608 tables