SV_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 NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1Record SearchRecordINTInteger0
2DATE1 SearchDateDT6Date6
3WS_Time_1 SearchWS Time 1TM6Time6
4Timeup SearchTimeupINT3Integer3
5Postal_Group SearchPostal GroupGBInteger0
6Meter_Group SearchMeter GroupGBInteger0
7Meter_Checkbox SearchMeter CheckboxCBBoolean0
8Wennbox1 SearchWennbox1CBBoolean0
9Wennbox2 SearchWennbox2CBBoolean0
10Wenngroup1 SearchWenngroup1GBInteger0
11Wenngroup2 SearchWenngroup2GBInteger0
12Wennsoft_Affiliate SearchWennsoft AffiliateSTR15_LBAUString15
13Wennsoft_Branch SearchWennsoft BranchSTR15_LBAUString15
14Wennsoft_Region SearchWennsoft RegionSTR15_LBAUString15
15Service_Option_Box_1 SearchService Option Box 1CBBoolean0
16Service_Option_Box_10 SearchService Option Box 10CBBoolean0
17Service_Option_Box_11 SearchService Option Box 11CBBoolean0
18Service_Option_Box_12 SearchService Option Box 12CBBoolean0
19Service_Option_Box_13 SearchService Option Box 13CBBoolean0
20Service_Option_Box_14 SearchService Option Box 14CBBoolean0
21Service_Option_Box_15 SearchService Option Box 15CBBoolean0
22Service_Option_Box_16 SearchService Option Box 16CBBoolean0
23Service_Option_Box_17 SearchService Option Box 17CBBoolean0
24Service_Option_Box_18 SearchService Option Box 18CBBoolean0
25Service_Option_Box_19 SearchService Option Box 19CBBoolean0
26Service_Option_Box_2 SearchService Option Box 2CBBoolean0
27Service_Option_Box_20 SearchService Option Box 20CBBoolean0
28Service_Option_Box_21 SearchService Option Box 21CBBoolean0
29Service_Option_Box_22 SearchService Option Box 22CBBoolean0
30Service_Option_Box_23 SearchService Option Box 23CBBoolean0
31Service_Option_Box_24 SearchService Option Box 24CBBoolean0
32Service_Option_Box_25 SearchService Option Box 25CBBoolean0
33Service_Option_Box_26 SearchService Option Box 26CBBoolean0
34Service_Option_Box_27 SearchService Option Box 27CBBoolean0
35Service_Option_Box_28 SearchService Option Box 28CBBoolean0
36Service_Option_Box_29 SearchService Option Box 29CBBoolean0
37Service_Option_Box_3 SearchService Option Box 3CBBoolean0
38Service_Option_Box_30 SearchService Option Box 30CBBoolean0
39Service_Option_Box_31 SearchService Option Box 31CBBoolean0
40Service_Option_Box_32 SearchService Option Box 32CBBoolean0
41Service_Option_Box_33 SearchService Option Box 33CBBoolean0
42Service_Option_Box_34 SearchService Option Box 34CBBoolean0
43Service_Option_Box_35 SearchService Option Box 35CBBoolean0
44Service_Option_Box_36 SearchService Option Box 36CBBoolean0
45Service_Option_Box_37 SearchService Option Box 37CBBoolean0
46Service_Option_Box_38 SearchService Option Box 38CBBoolean0
47Service_Option_Box_39 SearchService Option Box 39CBBoolean0
48Service_Option_Box_4 SearchService Option Box 4CBBoolean0
49Service_Option_Box_40 SearchService Option Box 40CBBoolean0
50Service_Option_Box_41 SearchService Option Box 41CBBoolean0
51Service_Option_Box_42 SearchService Option Box 42CBBoolean0
52Service_Option_Box_43 SearchService Option Box 43CBBoolean0
53Service_Option_Box_44 SearchService Option Box 44CBBoolean0
54Service_Option_Box_45 SearchService Option Box 45CBBoolean0
55Service_Option_Box_46 SearchService Option Box 46CBBoolean0
56Service_Option_Box_47 SearchService Option Box 47CBBoolean0
57Service_Option_Box_48 SearchService Option Box 48CBBoolean0
58Service_Option_Box_49 SearchService Option Box 49CBBoolean0
59Service_Option_Box_5 SearchService Option Box 5CBBoolean0
60Service_Option_Box_50 SearchService Option Box 50CBBoolean0
61Service_Option_Box_6 SearchService Option Box 6CBBoolean0
62Service_Option_Box_7 SearchService Option Box 7CBBoolean0
63Service_Option_Box_8 SearchService Option Box 8CBBoolean0
64Service_Option_Box_9 SearchService Option Box 9CBBoolean0
65Service_Option_Group_51 SearchService Option Group 51GBInteger0
66Service_Option_Group_52 SearchService Option Group 52GBInteger0
67Service_Option_Group_53 SearchService Option Group 53GBInteger0
68Service_Option_Group_54 SearchService Option Group 54GBInteger0
69Service_Option_Group_55 SearchService Option Group 55GBInteger0
70Service_Option_Group_56 SearchService Option Group 56GBInteger0
71Service_Option_Group_57 SearchService Option Group 57GBInteger0
72Service_Option_Group_58 SearchService Option Group 58GBInteger0
73Service_Option_Group_59 SearchService Option Group 59GBInteger0
74Service_Option_Group_60 SearchService Option Group 60GBInteger0
75Service_Option_Group_61 SearchService Option Group 61GBInteger0
76Service_Option_Group_62 SearchService Option Group 62GBInteger0
77Service_Option_Group_63 SearchService Option Group 63GBInteger0
78Service_Option_Group_64 SearchService Option Group 64GBInteger0
79Service_Option_Group_65 SearchService Option Group 65GBInteger0
80Service_Option_Group_66 SearchService Option Group 66GBInteger0
81Service_Option_Group_67 SearchService Option Group 67GBInteger0
82Service_Option_Group_68 SearchService Option Group 68GBInteger0
83Service_Option_Group_69 SearchService Option Group 69GBInteger0
84Service_Option_Group_70 SearchService Option Group 70GBInteger0
85Service_User_Define_1 SearchService User Define 1STR20String20
86Service_User_Define_2 SearchService User Define 2STR20String20
87Service_User_Define_3 SearchService User Define 3STR30String30
88Service_User_Define_4 SearchService User Define 4STR30String30
89Service_User_Define_5 SearchService User Define 5LI6_S2Long Integer6
90Service_User_Define_6 SearchService User Define 6LI6_S2Long Integer6
91Service_User_Define_7 SearchService User Define 7LI6_S2Long Integer6
92Service_User_Define_8 SearchService User Define 8LI6_S2Long Integer6
93Service_User_Define_9 SearchService User Define 9DTDate8
94Service_User_Define_10 SearchService User Define 10DTDate8
95Service_User_Define_11 SearchService User Define 11DTDate8
96Service_User_Define_12 SearchService User Define 12DTDate8
97Service_User_Define_18 SearchService User Define 18CBBoolean0
98Service_User_Define_19 SearchService User Define 19CBBoolean0
99Service_User_Define_20 SearchService User Define 20CBBoolean0
100Service_User_Define_21 SearchService User Define 21CBBoolean0
101Service_User_Define_22 SearchService User Define 22DLR14_RBS0_STR$Currency14
102Service_User_Define_23 SearchService User Define 23DLR14_RBS0_STR$Currency14
103Service_User_Define_24 SearchService User Define 24DLR14_RBS0_STR$Currency14
104Service_User_Define_25 SearchService User Define 25DLR14_RBS0_STR$Currency14
105MODIFDT SearchModified DateDTDate8
106Modified_Time SearchModified TimeTM6Time6
107MDFUSRID SearchModified User IDSTR15String15
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
108Time_Zone SearchTime ZoneSTR3String3

Leave a Reply

Your email address will not be published. Required fields are marked *