SV_User_Defined_MSTR (SV00900)

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

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

Display Name: SV_User_Defined_MSTR
Physical Name: SV00900
Technical Name: SV_User_Defined_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
5User_Define_1 SearchUser Define 1STR30String30
6User_Define_2 SearchUser Define 2STR30String30
7User_Define_3 SearchUser Define 3STR30String30
8User_Define_4 SearchUser Define 4STR30String30
9User_Define_5 SearchUser Define 5STR30String30
10User_Define_6 SearchUser Define 6STR30String30
11User_Define_7 SearchUser Define 7STR30String30
12User_Define_8 SearchUser Define 8STR30String30
13User_Define_9 SearchUser Define 9STR30String30
14User_Define_10 SearchUser Define 10STR30String30
15User_Define_11 SearchUser Define 11STR30String30
16User_Define_12 SearchUser Define 12STR30String30
17User_Define_13 SearchUser Define 13STR30String30
18User_Define_14 SearchUser Define 14STR30String30
19User_Define_15 SearchUser Define 15STR30String30
20User_Define_16 SearchUser Define 16STR30String30
21User_Define_17 SearchUser Define 17STR30String30
22User_Define_18 SearchUser Define 18STR30String30
23User_Define_19 SearchUser Define 19STR30String30
24User_Define_20 SearchUser Define 20STR30String30
25User_Define_21 SearchUser Define 21STR30String30
26User_Define_22 SearchUser Define 22STR30String30
27User_Define_23 SearchUser Define 23STR30String30
28User_Define_24 SearchUser Define 24STR30String30
29User_Define_25 SearchUser Define 25STR30String30
30User_Define_26 SearchUser Define 26STR30String30
31User_Define_27 SearchUser Define 27STR30String30
32User_Define_28 SearchUser Define 28STR30String30
33User_Define_29 SearchUser Define 29STR30String30
34User_Define_30 SearchUser Define 30STR30String30
35User_Define_31 SearchUser Define 31STR30String30
36User_Define_32 SearchUser Define 32STR30String30
37User_Define_33 SearchUser Define 33STR30String30
38User_Define_34 SearchUser Define 34STR30String30
39User_Define_35 SearchUser Define 35STR30String30
40User_Define_36 SearchUser Define 36STR30String30
41User_Define_37 SearchUser Define 37STR30String30
42User_Define_38 SearchUser Define 38STR30String30
43User_Define_39 SearchUser Define 39STR30String30
44User_Define_40 SearchUser Define 40STR30String30
45User_Define_41 SearchUser Define 41STR30String30
46User_Define_42 SearchUser Define 42STR30String30
47User_Define_43 SearchUser Define 43STR30String30
48User_Define_44 SearchUser Define 44STR30String30
49User_Define_45 SearchUser Define 45STR30String30
50MODIFDT SearchModified DateDTDate8
51Modified_Time SearchModified TimeTM6Time6
52MDFUSRID SearchModified User IDSTR15String15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['SV_User_Defined_MSTR'].MDFUSRID AS 'SV_User_Defined_MSTR-Modified User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       SV00900 AS ['SV_User_Defined_MSTR']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['SV_User_Defined_MSTR'].MDFUSRID = ['Users Master'].USERID
53Time_Zone SearchTime ZoneSTR3String3
54SV_Language_ID SearchSV Language IDINT2Integer2
55WSReserved_CB1 SearchWSReserved CB1CBBoolean0
56WSReserved_CB2 SearchWSReserved CB2CBBoolean0
57WSReserved_CB3 SearchWSReserved CB3CBBoolean0
58WSReserved_CB4 SearchWSReserved CB4CBBoolean0
59WSReserved_CB5 SearchWSReserved CB5CBBoolean0
60WSReserved_STR1 SearchWSReserved STR1STR10String10
61WSReserved_STR2 SearchWSReserved STR2STR10String10

Leave a Reply

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