SV_User_Preference_MSTR (SV00910)

azurecurve Products WennSoft Products (131)3rd PartySV_User_Preference_MSTR (SV00910)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SV00910

Product: WennSoft Products (131)
Series: 3rd Party

Display Name: SV_User_Preference_MSTR
Physical Name: SV00910
Technical Name: SV_User_Preference_MSTR

Group Display Name: SERVICE
Group Technical Name: SERVICE

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	Wennsoft_Affiliate	Wennsoft Affiliate	STR15_LBAU	String	15
2	Wennsoft_Region	Wennsoft Region	STR15_LBAU	String	15
3	Wennsoft_Branch	Wennsoft Branch	STR15_LBAU	String	15
4	USERID	User ID	STR15_User_ID	String	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['SV_User_Preference_MSTR'].USERID AS 'SV_User_Preference_MSTR-User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM SV00910 AS ['SV_User_Preference_MSTR'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['SV_User_Preference_MSTR'].USERID = ['Users Master'].USERID
5	Technician_ID	Technician ID	STR15_Employee_ID	String	15
6	Technician_Team	Technician Team	STR15_LBAU	String	15
7	Technician	Technician	STR10_LBAU	String	10
8	Service_Area	Service Area	STR15_LBAU	String	15
9	USERNAME	User Name	STR30	String	30
10	Network_User_Name	Network User Name	STR255	String	255
11	Security_Level	Security Level	STR15_LBAU	String	15
12	WS_Preference_Affiliate	WS Preference Affiliate	STR15_LBAU	String	15
13	WS_Preference_Region	WS Preference Region	STR15_LBAU	String	15
14	WS_Preference_Branch	WS Preference Branch	STR15_LBAU	String	15
15	STRTDATE	Start Date	DT	Date	8
16	ENDDATE	End Date	DT	Date	8
17	Type_Call_Short	Type Call Short	STR3_LBAU	String	3
18	Type_of_Call	Type of Call	STR15	String	15
19	Status_of_Call	Status of Call	STR10_LBAU	String	10
20	Appointment_Status	Appointment Status	STR10_LBAU	String	10
21	Service_Call_Check_Box	Service Call Check Box	CB_Service_Call	Boolean	0
22	Closed_Call_Check_Box	Closed Call Check Box	CB_Closed_Call	Boolean	0
23	Completed_Call_Check_Box	Completed Call Check Box	CB_Completed_Call	Boolean	0
24	MC_Call_Check_Box	MC Call Check Box	CB_MC_Calls	Boolean	0
25	MCC_Call_Check_Box	MCC Call Check Box	CB_MCC_Call	Boolean	0
26	Job_Check_Box	Job Check Box	CB_Job	Boolean	0
27	Activity_Check_Box	Activity Check Box	CB_Activity	Boolean	0
28	Quote_Check_Box	Quote Check Box	Quote_CB	Boolean	0
29	Billable_Check_Box	Billable Check Box	CB_Billable	Boolean	0
30	Priority	Priority	INT5	Integer	4
31	PriorityUpDown	PriorityUpDown	INT5	Integer	4
32	Meter_Checkbox	Meter Checkbox	CB	Boolean	0
33	Wennbox1	Wennbox1	CB	Boolean	0
34	Wennbox2	Wennbox2	CB	Boolean	0
35	Wenngroup1	Wenngroup1	GB	Integer	0
36	Wenngroup2	Wenngroup2	GB	Integer	0
37	EMPLOYID	Employee ID	STR15_Employee_ID	String	15
38	VENDORID	Vendor ID	STR_15_Vendor_ID	String	15
	Key to the PM Vendor Master File (PM00200). Click to show/hide SELECT ['SV_User_Preference_MSTR'].VENDORID AS 'SV_User_Preference_MSTR-Vendor ID' ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID' FROM SV00910 AS ['SV_User_Preference_MSTR'] INNER JOIN PM00200 AS ['PM Vendor Master File'] ON ['SV_User_Preference_MSTR'].VENDORID = ['PM Vendor Master File'].VENDORID
39	CUSTNMBR	Customer Number	STR15_RM_Customer_Number	String	15
	Key to the RM Customer MSTR (RM00101). Click to show/hide SELECT ['SV_User_Preference_MSTR'].CUSTNMBR AS 'SV_User_Preference_MSTR-Customer Number' ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number' FROM SV00910 AS ['SV_User_Preference_MSTR'] INNER JOIN RM00101 AS ['RM Customer MSTR'] ON ['SV_User_Preference_MSTR'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
40	User_Define_1a	User Define 1a	STR30	String	30
41	User_Define_2a	User Define 2a	STR30	String	30
42	MODIFDT	Modified Date	DT	Date	8
43	Modified_Time	Modified Time	TM6	Time	6
44	MDFUSRID	Modified User ID	STR15	String	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['SV_User_Preference_MSTR'].MDFUSRID AS 'SV_User_Preference_MSTR-Modified User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM SV00910 AS ['SV_User_Preference_MSTR'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['SV_User_Preference_MSTR'].MDFUSRID = ['Users Master'].USERID
45	Time_Zone	Time Zone	STR3	String	3
46	Time_Zone_Tag	Time Zone Tag	STR4	String	4
47	SV_Language_ID	SV Language ID	INT2	Integer	2
48	WSReserved_CB1	WSReserved CB1	CB	Boolean	0
49	WSReserved_CB2	WSReserved CB2	CB	Boolean	0
50	WSReserved_CB3	WSReserved CB3	CB	Boolean	0
51	WSReserved_CB4	WSReserved CB4	CB	Boolean	0
52	WSReserved_CB5	WSReserved CB5	CB	Boolean	0
53	WSReserved_STR1	WSReserved STR1	STR10	String	10
54	WSReserved_STR2	WSReserved STR2	STR10	String	10
55	Allow_Cust_Add	Allow Cust Add	CB	Boolean	0
56	Allow_Equipment_Add	Allow Equipment Add	CB	Boolean	0
57	Allow_MC_Add	Allow MC Add	CB	Boolean	0
58	Allow_Cust_Contract_Add	Allow Cust Contract Add	CB	Boolean	0
59	Allow_Global_Cust_Add	Allow Global Cust Add	CB	Boolean	0
60	Edit_Globl_Rec_Id_Filtrs	Edit Global Record Identification Filters	CB	Boolean	0
61	Allow_Cust_Location_Add	Allow Customer Location Add	CB	Boolean	0
62	Create_Calls_SV_Requests	SV_Create_Calls_Service_Requests	CB	Boolean	0
63	Service_Option_Box_1	Service Option Box 1	CB	Boolean	0
64	Service_Option_Box_2	Service Option Box 2	CB	Boolean	0
65	Service_Option_Box_3	Service Option Box 3	CB	Boolean	0
66	Service_Option_Box_4	Service Option Box 4	CB	Boolean	0
67	Service_Option_Box_5	Service Option Box 5	CB	Boolean	0
68	Service_Option_Box_6	Service Option Box 6	CB	Boolean	0
69	Service_Option_Box_7	Service Option Box 7	CB	Boolean	0
70	Service_Option_Box_8	Service Option Box 8	CB	Boolean	0
71	Service_Option_Box_9	Service Option Box 9	CB	Boolean	0
72	Service_Option_Box_10	Service Option Box 10	CB	Boolean	0

azurecurve Products WennSoft Products (131)3rd PartySV_User_Preference_MSTR (SV00910)

Click to show/hide

Click to show/hide

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply