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
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/hideSELECT
['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 |