SV_Setup2_MSTR (sv00196)

azurecurve Products WennSoft Products (131)3rd PartySV_Setup2_MSTR (sv00196)

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

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

Display Name: SV_Setup2_MSTR
Physical Name: sv00196
Technical Name: SV_Setup2_MSTR

Group Display Name: SERVICE
Group Technical Name: SERVICE

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	Record	Record	INT	Integer	0
2	DATE1	Date	DT6	Date	6
3	WS_Time_1	WS Time 1	TM6	Time	6
4	Timeup	Timeup	INT3	Integer	3
5	Postal_Group	Postal Group	GB	Integer	0
6	Meter_Group	Meter Group	GB	Integer	0
7	Meter_Checkbox	Meter Checkbox	CB	Boolean	0
8	Wennbox1	Wennbox1	CB	Boolean	0
9	Wennbox2	Wennbox2	CB	Boolean	0
10	Wenngroup1	Wenngroup1	GB	Integer	0
11	Wenngroup2	Wenngroup2	GB	Integer	0
12	Wennsoft_Affiliate	Wennsoft Affiliate	STR15_LBAU	String	15
13	Wennsoft_Branch	Wennsoft Branch	STR15_LBAU	String	15
14	Wennsoft_Region	Wennsoft Region	STR15_LBAU	String	15
15	Service_Option_Box_1	Service Option Box 1	CB	Boolean	0
16	Service_Option_Box_10	Service Option Box 10	CB	Boolean	0
17	Service_Option_Box_11	Service Option Box 11	CB	Boolean	0
18	Service_Option_Box_12	Service Option Box 12	CB	Boolean	0
19	Service_Option_Box_13	Service Option Box 13	CB	Boolean	0
20	Service_Option_Box_14	Service Option Box 14	CB	Boolean	0
21	Service_Option_Box_15	Service Option Box 15	CB	Boolean	0
22	Service_Option_Box_16	Service Option Box 16	CB	Boolean	0
23	Service_Option_Box_17	Service Option Box 17	CB	Boolean	0
24	Service_Option_Box_18	Service Option Box 18	CB	Boolean	0
25	Service_Option_Box_19	Service Option Box 19	CB	Boolean	0
26	Service_Option_Box_2	Service Option Box 2	CB	Boolean	0
27	Service_Option_Box_20	Service Option Box 20	CB	Boolean	0
28	Service_Option_Box_21	Service Option Box 21	CB	Boolean	0
29	Service_Option_Box_22	Service Option Box 22	CB	Boolean	0
30	Service_Option_Box_23	Service Option Box 23	CB	Boolean	0
31	Service_Option_Box_24	Service Option Box 24	CB	Boolean	0
32	Service_Option_Box_25	Service Option Box 25	CB	Boolean	0
33	Service_Option_Box_26	Service Option Box 26	CB	Boolean	0
34	Service_Option_Box_27	Service Option Box 27	CB	Boolean	0
35	Service_Option_Box_28	Service Option Box 28	CB	Boolean	0
36	Service_Option_Box_29	Service Option Box 29	CB	Boolean	0
37	Service_Option_Box_3	Service Option Box 3	CB	Boolean	0
38	Service_Option_Box_30	Service Option Box 30	CB	Boolean	0
39	Service_Option_Box_31	Service Option Box 31	CB	Boolean	0
40	Service_Option_Box_32	Service Option Box 32	CB	Boolean	0
41	Service_Option_Box_33	Service Option Box 33	CB	Boolean	0
42	Service_Option_Box_34	Service Option Box 34	CB	Boolean	0
43	Service_Option_Box_35	Service Option Box 35	CB	Boolean	0
44	Service_Option_Box_36	Service Option Box 36	CB	Boolean	0
45	Service_Option_Box_37	Service Option Box 37	CB	Boolean	0
46	Service_Option_Box_38	Service Option Box 38	CB	Boolean	0
47	Service_Option_Box_39	Service Option Box 39	CB	Boolean	0
48	Service_Option_Box_4	Service Option Box 4	CB	Boolean	0
49	Service_Option_Box_40	Service Option Box 40	CB	Boolean	0
50	Service_Option_Box_41	Service Option Box 41	CB	Boolean	0
51	Service_Option_Box_42	Service Option Box 42	CB	Boolean	0
52	Service_Option_Box_43	Service Option Box 43	CB	Boolean	0
53	Service_Option_Box_44	Service Option Box 44	CB	Boolean	0
54	Service_Option_Box_45	Service Option Box 45	CB	Boolean	0
55	Service_Option_Box_46	Service Option Box 46	CB	Boolean	0
56	Service_Option_Box_47	Service Option Box 47	CB	Boolean	0
57	Service_Option_Box_48	Service Option Box 48	CB	Boolean	0
58	Service_Option_Box_49	Service Option Box 49	CB	Boolean	0
59	Service_Option_Box_5	Service Option Box 5	CB	Boolean	0
60	Service_Option_Box_50	Service Option Box 50	CB	Boolean	0
61	Service_Option_Box_6	Service Option Box 6	CB	Boolean	0
62	Service_Option_Box_7	Service Option Box 7	CB	Boolean	0
63	Service_Option_Box_8	Service Option Box 8	CB	Boolean	0
64	Service_Option_Box_9	Service Option Box 9	CB	Boolean	0
65	Service_Option_Group_51	Service Option Group 51	GB	Integer	0
66	Service_Option_Group_52	Service Option Group 52	GB	Integer	0
67	Service_Option_Group_53	Service Option Group 53	GB	Integer	0
68	Service_Option_Group_54	Service Option Group 54	GB	Integer	0
69	Service_Option_Group_55	Service Option Group 55	GB	Integer	0
70	Service_Option_Group_56	Service Option Group 56	GB	Integer	0
71	Service_Option_Group_57	Service Option Group 57	GB	Integer	0
72	Service_Option_Group_58	Service Option Group 58	GB	Integer	0
73	Service_Option_Group_59	Service Option Group 59	GB	Integer	0
74	Service_Option_Group_60	Service Option Group 60	GB	Integer	0
75	Service_Option_Group_61	Service Option Group 61	GB	Integer	0
76	Service_Option_Group_62	Service Option Group 62	GB	Integer	0
77	Service_Option_Group_63	Service Option Group 63	GB	Integer	0
78	Service_Option_Group_64	Service Option Group 64	GB	Integer	0
79	Service_Option_Group_65	Service Option Group 65	GB	Integer	0
80	Service_Option_Group_66	Service Option Group 66	GB	Integer	0
81	Service_Option_Group_67	Service Option Group 67	GB	Integer	0
82	Service_Option_Group_68	Service Option Group 68	GB	Integer	0
83	Service_Option_Group_69	Service Option Group 69	GB	Integer	0
84	Service_Option_Group_70	Service Option Group 70	GB	Integer	0
85	Service_User_Define_1	Service User Define 1	STR20	String	20
86	Service_User_Define_2	Service User Define 2	STR20	String	20
87	Service_User_Define_3	Service User Define 3	STR30	String	30
88	Service_User_Define_4	Service User Define 4	STR30	String	30
89	Service_User_Define_5	Service User Define 5	LI6_S2	Long Integer	6
90	Service_User_Define_6	Service User Define 6	LI6_S2	Long Integer	6
91	Service_User_Define_7	Service User Define 7	LI6_S2	Long Integer	6
92	Service_User_Define_8	Service User Define 8	LI6_S2	Long Integer	6
93	Service_User_Define_9	Service User Define 9	DT	Date	8
94	Service_User_Define_10	Service User Define 10	DT	Date	8
95	Service_User_Define_11	Service User Define 11	DT	Date	8
96	Service_User_Define_12	Service User Define 12	DT	Date	8
97	Service_User_Define_18	Service User Define 18	CB	Boolean	0
98	Service_User_Define_19	Service User Define 19	CB	Boolean	0
99	Service_User_Define_20	Service User Define 20	CB	Boolean	0
100	Service_User_Define_21	Service User Define 21	CB	Boolean	0
101	Service_User_Define_22	Service User Define 22	DLR14_RBS0_STR$	Currency	14
102	Service_User_Define_23	Service User Define 23	DLR14_RBS0_STR$	Currency	14
103	Service_User_Define_24	Service User Define 24	DLR14_RBS0_STR$	Currency	14
104	Service_User_Define_25	Service User Define 25	DLR14_RBS0_STR$	Currency	14
105	MODIFDT	Modified Date	DT	Date	8
106	Modified_Time	Modified Time	TM6	Time	6
107	MDFUSRID	Modified User ID	STR15	String	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['SV_Setup2_MSTR'].MDFUSRID AS 'SV_Setup2_MSTR-Modified User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM sv00196 AS ['SV_Setup2_MSTR'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['SV_Setup2_MSTR'].MDFUSRID = ['Users Master'].USERID
108	Time_Zone	Time Zone	STR3	String	3

azurecurve Products WennSoft Products (131)3rd PartySV_Setup2_MSTR (sv00196)

Click to show/hide

Leave a Reply Cancel reply