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 TypeLength
1Wennsoft_Affiliate SearchWennsoft AffiliateSTR15_LBAUString15
2Wennsoft_Region SearchWennsoft RegionSTR15_LBAUString15
3Wennsoft_Branch SearchWennsoft BranchSTR15_LBAUString15
4Record SearchRecordINTInteger0
5DATE1 SearchDateDT6Date6
6WS_Time_1 SearchWS Time 1TM6Time6
7Timeup SearchTimeupINT3Integer3
8Postal_Group SearchPostal GroupGBInteger0
9Meter_Group SearchMeter GroupGBInteger0
10User_Define_1 SearchUser Define 1STR30String30
11User_Define_2 SearchUser Define 2STR30String30
12User_Define_3 SearchUser Define 3STR30String30
13User_Define_4 SearchUser Define 4STR30String30
14User_Define_5 SearchUser Define 5STR30String30
15User_Define_6 SearchUser Define 6STR30String30
16User_Define_7 SearchUser Define 7STR30String30
17User_Define_8 SearchUser Define 8STR30String30
18User_Define_9 SearchUser Define 9STR30String30
19User_Define_10 SearchUser Define 10STR30String30
20User_Define_11 SearchUser Define 11STR30String30
21User_Define_12 SearchUser Define 12STR30String30
22User_Define_13 SearchUser Define 13STR30String30
23User_Define_14 SearchUser Define 14STR30String30
24User_Define_15 SearchUser Define 15STR30String30
25User_Define_16 SearchUser Define 16STR30String30
26User_Define_17 SearchUser Define 17STR30String30
27User_Define_18 SearchUser Define 18STR30String30
28User_Define_19 SearchUser Define 19STR30String30
29User_Define_20 SearchUser Define 20STR30String30
30User_Define_21 SearchUser Define 21STR30String30
31User_Define_22 SearchUser Define 22STR30String30
32User_Define_23 SearchUser Define 23STR30String30
33User_Define_24 SearchUser Define 24STR30String30
34User_Define_25 SearchUser Define 25STR30String30
35User_Define_26 SearchUser Define 26STR30String30
36User_Define_27 SearchUser Define 27STR30String30
37User_Define_28 SearchUser Define 28STR30String30
38User_Define_29 SearchUser Define 29STR30String30
39User_Define_30 SearchUser Define 30STR30String30
40User_Define_31 SearchUser Define 31STR30String30
41User_Define_32 SearchUser Define 32STR30String30
42User_Define_33 SearchUser Define 33STR30String30
43User_Define_34 SearchUser Define 34STR30String30
44User_Define_35 SearchUser Define 35STR30String30
45User_Define_36 SearchUser Define 36STR30String30
46User_Define_37 SearchUser Define 37STR30String30
47User_Define_38 SearchUser Define 38STR30String30
48User_Define_39 SearchUser Define 39STR30String30
49User_Define_40 SearchUser Define 40STR30String30
50MODIFDT SearchModified DateDTDate8
51Modified_Time SearchModified TimeTM6Time6
52MDFUSRID SearchModified User IDSTR15String15
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 ZoneSTR3String3

Leave a Reply

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