SV_Maintenance_Setup_MSTR (sv00511)

azurecurveProductsWennSoft Products (131)3rd PartySV_Maintenance_Setup_MSTR (sv00511)

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

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

Display Name: SV_Maintenance_Setup_MSTR
Physical Name: sv00511
Technical Name: SV_Maintenance_Setup_MSTR

Group Display Name: SERVICE
Group Technical Name: SERVICE

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1Divisions SearchDivisionsSTR15_LBAUString1615
2SOURCDOC SearchSource DocumentSTR10_Source_DocumentString1210
Key to the Source Document Master (SY00900).

Click to show/hide

SELECT
       ['SV_Maintenance_Setup_MSTR'].SOURCDOC AS 'SV_Maintenance_Setup_MSTR-Source Document'
       ,['Source Document Master'].SOURCDOC AS 'Source Document Master-Source Document'
FROM
       sv00511 AS ['SV_Maintenance_Setup_MSTR']
INNER JOIN
       SY00900 AS ['Source Document Master']
              ON
                     ['SV_Maintenance_Setup_MSTR'].SOURCDOC = ['Source Document Master'].SOURCDOC
3SDOCDSCR SearchSource Document DescriptionSTR30String3230
4Wennsoft_Account_Index_1 SearchWennsoft Account Index[1]LI_14Long Integer414
5Wennsoft_Account_Index_2 SearchWennsoft Account Index[2]LI_14Long Integer414
6Wennsoft_Account_Index_3 SearchWennsoft Account Index[3]LI_14Long Integer414
7Wennsoft_Account_Index_4 SearchWennsoft Account Index[4]LI_14Long Integer414
8Wennsoft_Account_Index_5 SearchWennsoft Account Index[5]LI_14Long Integer414
9Wennsoft_Account_Index_6 SearchWennsoft Account Index[6]LI_14Long Integer414
10Wennsoft_Account_Index_7 SearchWennsoft Account Index[7]LI_14Long Integer414
11Wennsoft_Account_Index_8 SearchWennsoft Account Index[8]LI_14Long Integer414
12Wennsoft_Account_Index_9 SearchWennsoft Account Index[9]LI_14Long Integer414
13Wennsoft_Account_Index_10 SearchWennsoft Account Index[10]LI_14Long Integer414
14Wennsoft_Account_Index_11 SearchWennsoft Account Index[11]LI_14Long Integer414
15Wennsoft_Account_Index_12 SearchWennsoft Account Index[12]LI_14Long Integer414
16Wennsoft_Account_Index_13 SearchWennsoft Account Index[13]LI_14Long Integer414
17Wennsoft_Account_Index_14 SearchWennsoft Account Index[14]LI_14Long Integer414
18Wennsoft_Account_Index_15 SearchWennsoft Account Index[15]LI_14Long Integer414
19Wennsoft_Account_Index_16 SearchWennsoft Account Index[16]LI_14Long Integer414
20Wennsoft_Account_Index_17 SearchWennsoft Account Index[17]LI_14Long Integer414
21Wennsoft_Account_Index_18 SearchWennsoft Account Index[18]LI_14Long Integer414
22Wennsoft_Account_Index_19 SearchWennsoft Account Index[19]LI_14Long Integer414
23Wennsoft_Account_Index_20 SearchWennsoft Account Index[20]LI_14Long Integer414
24Wennsoft_Account_Index_21 SearchWennsoft Account Index[21]LI_14Long Integer414
25Wennsoft_Account_Index_22 SearchWennsoft Account Index[22]LI_14Long Integer414
26Wennsoft_Account_Index_23 SearchWennsoft Account Index[23]LI_14Long Integer414
27Wennsoft_Account_Index_24 SearchWennsoft Account Index[24]LI_14Long Integer414
28Wennsoft_Account_Index_25 SearchWennsoft Account Index[25]LI_14Long Integer414
29Wennsoft_Account_Index_26 SearchWennsoft Account Index[26]LI_14Long Integer414
30Wennsoft_Account_Index_27 SearchWennsoft Account Index[27]LI_14Long Integer414
31Wennsoft_Account_Index_28 SearchWennsoft Account Index[28]LI_14Long Integer414
32Wennsoft_Account_Index_29 SearchWennsoft Account Index[29]LI_14Long Integer414
33Wennsoft_Account_Index_30 SearchWennsoft Account Index[30]LI_14Long Integer414
34Wennsoft_Account_Index_31 SearchWennsoft Account Index[31]LI_14Long Integer414
35Wennsoft_Account_Index_32 SearchWennsoft Account Index[32]LI_14Long Integer414
36Wennsoft_Account_Index_33 SearchWennsoft Account Index[33]LI_14Long Integer414
37Wennsoft_Account_Index_34 SearchWennsoft Account Index[34]LI_14Long Integer414
38Wennsoft_Account_Index_35 SearchWennsoft Account Index[35]LI_14Long Integer414
39Wennsoft_Account_Index_36 SearchWennsoft Account Index[36]LI_14Long Integer414
40Wennsoft_Account_Index_37 SearchWennsoft Account Index[37]LI_14Long Integer414
41Wennsoft_Account_Index_38 SearchWennsoft Account Index[38]LI_14Long Integer414
42Wennsoft_Account_Index_39 SearchWennsoft Account Index[39]LI_14Long Integer414
43Wennsoft_Account_Index_40 SearchWennsoft Account Index[40]LI_14Long Integer414
44Wennsoft_Account_Index_41 SearchWennsoft Account Index[41]LI_14Long Integer414
45Wennsoft_Account_Index_42 SearchWennsoft Account Index[42]LI_14Long Integer414
46Wennsoft_Account_Index_43 SearchWennsoft Account Index[43]LI_14Long Integer414
47Wennsoft_Account_Index_44 SearchWennsoft Account Index[44]LI_14Long Integer414
48Wennsoft_Account_Index_45 SearchWennsoft Account Index[45]LI_14Long Integer414
49Wennsoft_Account_Index_46 SearchWennsoft Account Index[46]LI_14Long Integer414
50Wennsoft_Account_Index_47 SearchWennsoft Account Index[47]LI_14Long Integer414
51Wennsoft_Account_Index_48 SearchWennsoft Account Index[48]LI_14Long Integer414
52Wennsoft_Account_Index_49 SearchWennsoft Account Index[49]LI_14Long Integer414
53Wennsoft_Account_Index_50 SearchWennsoft Account Index[50]LI_14Long Integer414
54Wennsoft_Account_Index_51 SearchWennsoft Account Index[51]LI_14Long Integer414
55Wennsoft_Account_Index_52 SearchWennsoft Account Index[52]LI_14Long Integer414
56Wennsoft_Affiliate SearchWennsoft AffiliateSTR15_LBAUString1615
57Wennsoft_Branch SearchWennsoft BranchSTR15_LBAUString1615
58Wennsoft_Region SearchWennsoft RegionSTR15_LBAUString1615
59MODIFDT SearchModified DateDTDate48
60Modified_Time SearchModified TimeTM6Time46
61MDFUSRID SearchModified User IDSTR15String1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['SV_Maintenance_Setup_MSTR'].MDFUSRID AS 'SV_Maintenance_Setup_MSTR-Modified User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       sv00511 AS ['SV_Maintenance_Setup_MSTR']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['SV_Maintenance_Setup_MSTR'].MDFUSRID = ['Users Master'].USERID
62SV_Language_ID SearchSV Language IDINT2Integer22
63Time_Zone SearchTime ZoneSTR3String43
64All_Converted SearchAll ConvertedCBBoolean20
65WS_Checkbox1 SearchWS Checkbox1CBBoolean20
66WS_Checkbox_2 SearchWS Checkbox 2CBBoolean20
67WS_Checkbox_3 SearchWS Checkbox 3CBBoolean20
68WS_Checkbox_4 SearchWS Checkbox 4CBBoolean20
69WS_Checkbox_5 SearchWS Checkbox 5CBBoolean20
70WS_Checkbox_6 SearchWS Checkbox 6CBBoolean20
71WS_Checkbox_7 SearchWS Checkbox 7CBBoolean20
72WS_Checkbox_8 SearchWS Checkbox 8CBBoolean20
73WS_Checkbox_9 SearchWS Checkbox 9CBBoolean20
74WS_Checkbox_10 SearchWS Checkbox 10CBBoolean20
75WS_Checkbox_11 SearchWS Checkbox 11CBBoolean20
76WS_Checkbox_12 SearchWS Checkbox 12CBBoolean20
77WS_Checkbox_13 SearchWS Checkbox 13CBBoolean20
78WS_Checkbox_14 SearchWS Checkbox 14CBBoolean20
79WS_Checkbox_15 SearchWS Checkbox 15CBBoolean20
80WS_Checkbox_16 SearchWS Checkbox 16CBBoolean20
81WS_Checkbox_17 SearchWS Checkbox 17CBBoolean20
82WS_Checkbox_18 SearchWS Checkbox 18CBBoolean20
83WS_Checkbox_19 SearchWS Checkbox 19CBBoolean20
84WS_Checkbox_20 SearchWS Checkbox 20CBBoolean20
azurecurveProductsWennSoft Products (131)3rd PartySV_Maintenance_Setup_MSTR (sv00511)

Leave a Reply

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