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 TypeSQL DB LengthKeyable Length
1Wennsoft_Affiliate SearchWennsoft AffiliateSTR15_LBAUString1615
2Wennsoft_Region SearchWennsoft RegionSTR15_LBAUString1615
3Wennsoft_Branch SearchWennsoft BranchSTR15_LBAUString1615
4Record SearchRecordINTInteger20
5User_Define_1 SearchUser Define 1STR30String3230
6User_Define_2 SearchUser Define 2STR30String3230
7User_Define_3 SearchUser Define 3STR30String3230
8User_Define_4 SearchUser Define 4STR30String3230
9User_Define_5 SearchUser Define 5STR30String3230
10User_Define_6 SearchUser Define 6STR30String3230
11User_Define_7 SearchUser Define 7STR30String3230
12User_Define_8 SearchUser Define 8STR30String3230
13User_Define_9 SearchUser Define 9STR30String3230
14User_Define_10 SearchUser Define 10STR30String3230
15User_Define_11 SearchUser Define 11STR30String3230
16User_Define_12 SearchUser Define 12STR30String3230
17User_Define_13 SearchUser Define 13STR30String3230
18User_Define_14 SearchUser Define 14STR30String3230
19User_Define_15 SearchUser Define 15STR30String3230
20User_Define_16 SearchUser Define 16STR30String3230
21User_Define_17 SearchUser Define 17STR30String3230
22User_Define_18 SearchUser Define 18STR30String3230
23User_Define_19 SearchUser Define 19STR30String3230
24User_Define_20 SearchUser Define 20STR30String3230
25User_Define_21 SearchUser Define 21STR30String3230
26User_Define_22 SearchUser Define 22STR30String3230
27User_Define_23 SearchUser Define 23STR30String3230
28User_Define_24 SearchUser Define 24STR30String3230
29User_Define_25 SearchUser Define 25STR30String3230
30User_Define_26 SearchUser Define 26STR30String3230
31User_Define_27 SearchUser Define 27STR30String3230
32User_Define_28 SearchUser Define 28STR30String3230
33User_Define_29 SearchUser Define 29STR30String3230
34User_Define_30 SearchUser Define 30STR30String3230
35User_Define_31 SearchUser Define 31STR30String3230
36User_Define_32 SearchUser Define 32STR30String3230
37User_Define_33 SearchUser Define 33STR30String3230
38User_Define_34 SearchUser Define 34STR30String3230
39User_Define_35 SearchUser Define 35STR30String3230
40User_Define_36 SearchUser Define 36STR30String3230
41User_Define_37 SearchUser Define 37STR30String3230
42User_Define_38 SearchUser Define 38STR30String3230
43User_Define_39 SearchUser Define 39STR30String3230
44User_Define_40 SearchUser Define 40STR30String3230
45User_Define_41 SearchUser Define 41STR30String3230
46User_Define_42 SearchUser Define 42STR30String3230
47User_Define_43 SearchUser Define 43STR30String3230
48User_Define_44 SearchUser Define 44STR30String3230
49User_Define_45 SearchUser Define 45STR30String3230
50MODIFDT SearchModified DateDTDate48
51Modified_Time SearchModified TimeTM6Time46
52MDFUSRID SearchModified User IDSTR15String1615
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 ZoneSTR3String43
54SV_Language_ID SearchSV Language IDINT2Integer22
55WSReserved_CB1 SearchWSReserved CB1CBBoolean20
56WSReserved_CB2 SearchWSReserved CB2CBBoolean20
57WSReserved_CB3 SearchWSReserved CB3CBBoolean20
58WSReserved_CB4 SearchWSReserved CB4CBBoolean20
59WSReserved_CB5 SearchWSReserved CB5CBBoolean20
60WSReserved_STR1 SearchWSReserved STR1STR10String1210
61WSReserved_STR2 SearchWSReserved STR2STR10String1210

Leave a Reply

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