SV_User_Defined2_MSTR (SV00905)

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

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

Display Name: SV_User_Defined2_MSTR
Physical Name: SV00905
Technical Name: SV_User_Defined2_MSTR

Group Display Name: SERVICE
Group Technical Name: SERVICE

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1Wennsoft_Affiliate SearchWennsoft AffiliateSTR15_LBAUString1615
2Wennsoft_Region SearchWennsoft RegionSTR15_LBAUString1615
3Wennsoft_Branch SearchWennsoft BranchSTR15_LBAUString1615
4Record SearchRecordINTInteger20
5DATE1 SearchDateDT6Date46
6WS_Time_1 SearchWS Time 1TM6Time46
7Timeup SearchTimeupINT3Integer23
8Postal_Group SearchPostal GroupGBInteger20
9Meter_Group SearchMeter GroupGBInteger20
10User_Define_1 SearchUser Define 1STR30String3230
11User_Define_2 SearchUser Define 2STR30String3230
12User_Define_3 SearchUser Define 3STR30String3230
13User_Define_4 SearchUser Define 4STR30String3230
14User_Define_5 SearchUser Define 5STR30String3230
15User_Define_6 SearchUser Define 6STR30String3230
16User_Define_7 SearchUser Define 7STR30String3230
17User_Define_8 SearchUser Define 8STR30String3230
18User_Define_9 SearchUser Define 9STR30String3230
19User_Define_10 SearchUser Define 10STR30String3230
20User_Define_11 SearchUser Define 11STR30String3230
21User_Define_12 SearchUser Define 12STR30String3230
22User_Define_13 SearchUser Define 13STR30String3230
23User_Define_14 SearchUser Define 14STR30String3230
24User_Define_15 SearchUser Define 15STR30String3230
25User_Define_16 SearchUser Define 16STR30String3230
26User_Define_17 SearchUser Define 17STR30String3230
27User_Define_18 SearchUser Define 18STR30String3230
28User_Define_19 SearchUser Define 19STR30String3230
29User_Define_20 SearchUser Define 20STR30String3230
30User_Define_21 SearchUser Define 21STR30String3230
31User_Define_22 SearchUser Define 22STR30String3230
32User_Define_23 SearchUser Define 23STR30String3230
33User_Define_24 SearchUser Define 24STR30String3230
34User_Define_25 SearchUser Define 25STR30String3230
35User_Define_26 SearchUser Define 26STR30String3230
36User_Define_27 SearchUser Define 27STR30String3230
37User_Define_28 SearchUser Define 28STR30String3230
38User_Define_29 SearchUser Define 29STR30String3230
39User_Define_30 SearchUser Define 30STR30String3230
40User_Define_31 SearchUser Define 31STR30String3230
41User_Define_32 SearchUser Define 32STR30String3230
42User_Define_33 SearchUser Define 33STR30String3230
43User_Define_34 SearchUser Define 34STR30String3230
44User_Define_35 SearchUser Define 35STR30String3230
45User_Define_36 SearchUser Define 36STR30String3230
46User_Define_37 SearchUser Define 37STR30String3230
47User_Define_38 SearchUser Define 38STR30String3230
48User_Define_39 SearchUser Define 39STR30String3230
49User_Define_40 SearchUser Define 40STR30String3230
50MODIFDT SearchModified DateDTDate48
51Modified_Time SearchModified TimeTM6Time46
52MDFUSRID SearchModified User IDSTR15String1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['SV_User_Defined2_MSTR'].MDFUSRID AS 'SV_User_Defined2_MSTR-Modified User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       SV00905 AS ['SV_User_Defined2_MSTR']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['SV_User_Defined2_MSTR'].MDFUSRID = ['Users Master'].USERID
53Time_Zone SearchTime ZoneSTR3String43

Leave a Reply

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