SV_Invoice_Setup_MSTR (SV000787)

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

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

Display Name: SV_Invoice_Setup_MSTR
Physical Name: SV000787
Technical Name: SV_Invoice_Setup_MSTR

Group Display Name: SERVICE
Group Technical Name: SERVICE

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1Divisions SearchDivisionsSTR15_LBAUString15
2Wennsoft_Account_Index_1 SearchWennsoft Account Index[1]LI_14Long Integer14
3Wennsoft_Account_Index_2 SearchWennsoft Account Index[2]LI_14Long Integer14
4Wennsoft_Account_Index_3 SearchWennsoft Account Index[3]LI_14Long Integer14
5Wennsoft_Account_Index_4 SearchWennsoft Account Index[4]LI_14Long Integer14
6Wennsoft_Account_Index_5 SearchWennsoft Account Index[5]LI_14Long Integer14
7Wennsoft_Account_Index_6 SearchWennsoft Account Index[6]LI_14Long Integer14
8Wennsoft_Account_Index_7 SearchWennsoft Account Index[7]LI_14Long Integer14
9Wennsoft_Account_Index_8 SearchWennsoft Account Index[8]LI_14Long Integer14
10Wennsoft_Account_Index_9 SearchWennsoft Account Index[9]LI_14Long Integer14
11Wennsoft_Account_Index_10 SearchWennsoft Account Index[10]LI_14Long Integer14
12Wennsoft_Account_Index_11 SearchWennsoft Account Index[11]LI_14Long Integer14
13Wennsoft_Account_Index_12 SearchWennsoft Account Index[12]LI_14Long Integer14
14Wennsoft_Account_Index_13 SearchWennsoft Account Index[13]LI_14Long Integer14
15Wennsoft_Account_Index_14 SearchWennsoft Account Index[14]LI_14Long Integer14
16Wennsoft_Account_Index_15 SearchWennsoft Account Index[15]LI_14Long Integer14
17Wennsoft_Account_Index_16 SearchWennsoft Account Index[16]LI_14Long Integer14
18Wennsoft_Account_Index_17 SearchWennsoft Account Index[17]LI_14Long Integer14
19Wennsoft_Account_Index_18 SearchWennsoft Account Index[18]LI_14Long Integer14
20Wennsoft_Account_Index_19 SearchWennsoft Account Index[19]LI_14Long Integer14
21Wennsoft_Account_Index_20 SearchWennsoft Account Index[20]LI_14Long Integer14
22Wennsoft_Account_Index_21 SearchWennsoft Account Index[21]LI_14Long Integer14
23Wennsoft_Account_Index_22 SearchWennsoft Account Index[22]LI_14Long Integer14
24Wennsoft_Account_Index_23 SearchWennsoft Account Index[23]LI_14Long Integer14
25Wennsoft_Account_Index_24 SearchWennsoft Account Index[24]LI_14Long Integer14
26Wennsoft_Account_Index_25 SearchWennsoft Account Index[25]LI_14Long Integer14
27Wennsoft_Account_Index_26 SearchWennsoft Account Index[26]LI_14Long Integer14
28Wennsoft_Account_Index_27 SearchWennsoft Account Index[27]LI_14Long Integer14
29Wennsoft_Account_Index_28 SearchWennsoft Account Index[28]LI_14Long Integer14
30Wennsoft_Account_Index_29 SearchWennsoft Account Index[29]LI_14Long Integer14
31Wennsoft_Account_Index_30 SearchWennsoft Account Index[30]LI_14Long Integer14
32Wennsoft_Account_Index_31 SearchWennsoft Account Index[31]LI_14Long Integer14
33Wennsoft_Account_Index_32 SearchWennsoft Account Index[32]LI_14Long Integer14
34Wennsoft_Account_Index_33 SearchWennsoft Account Index[33]LI_14Long Integer14
35Wennsoft_Account_Index_34 SearchWennsoft Account Index[34]LI_14Long Integer14
36Wennsoft_Account_Index_35 SearchWennsoft Account Index[35]LI_14Long Integer14
37Wennsoft_Account_Index_36 SearchWennsoft Account Index[36]LI_14Long Integer14
38Wennsoft_Account_Index_37 SearchWennsoft Account Index[37]LI_14Long Integer14
39Wennsoft_Account_Index_38 SearchWennsoft Account Index[38]LI_14Long Integer14
40Wennsoft_Account_Index_39 SearchWennsoft Account Index[39]LI_14Long Integer14
41Wennsoft_Account_Index_40 SearchWennsoft Account Index[40]LI_14Long Integer14
42Wennsoft_Account_Index_41 SearchWennsoft Account Index[41]LI_14Long Integer14
43Wennsoft_Account_Index_42 SearchWennsoft Account Index[42]LI_14Long Integer14
44Wennsoft_Account_Index_43 SearchWennsoft Account Index[43]LI_14Long Integer14
45Wennsoft_Account_Index_44 SearchWennsoft Account Index[44]LI_14Long Integer14
46Wennsoft_Account_Index_45 SearchWennsoft Account Index[45]LI_14Long Integer14
47Wennsoft_Account_Index_46 SearchWennsoft Account Index[46]LI_14Long Integer14
48Wennsoft_Account_Index_47 SearchWennsoft Account Index[47]LI_14Long Integer14
49Wennsoft_Account_Index_48 SearchWennsoft Account Index[48]LI_14Long Integer14
50Wennsoft_Account_Index_49 SearchWennsoft Account Index[49]LI_14Long Integer14
51Wennsoft_Account_Index_50 SearchWennsoft Account Index[50]LI_14Long Integer14
52Wennsoft_Account_Index_51 SearchWennsoft Account Index[51]LI_14Long Integer14
53Wennsoft_Account_Index_52 SearchWennsoft Account Index[52]LI_14Long Integer14
54SOURCDOC SearchSource DocumentSTR10_Source_DocumentString10
Key to the Source Document Master (SY00900).

Click to show/hide

SELECT
       ['SV_Invoice_Setup_MSTR'].SOURCDOC AS 'SV_Invoice_Setup_MSTR-Source Document'
       ,['Source Document Master'].SOURCDOC AS 'Source Document Master-Source Document'
FROM
       SV000787 AS ['SV_Invoice_Setup_MSTR']
INNER JOIN
       SY00900 AS ['Source Document Master']
              ON
                     ['SV_Invoice_Setup_MSTR'].SOURCDOC = ['Source Document Master'].SOURCDOC
55SDOCDSCR SearchSource Document DescriptionSTR30String30
56All_Converted SearchAll ConvertedCBBoolean0
57Wennsoft_Affiliate SearchWennsoft AffiliateSTR15_LBAUString15
58Wennsoft_Region SearchWennsoft RegionSTR15_LBAUString15
59Wennsoft_Branch SearchWennsoft BranchSTR15_LBAUString15
60MODIFDT SearchModified DateDTDate8
61Modified_Time SearchModified TimeTM6Time6
62MDFUSRID SearchModified User IDSTR15String15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['SV_Invoice_Setup_MSTR'].MDFUSRID AS 'SV_Invoice_Setup_MSTR-Modified User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       SV000787 AS ['SV_Invoice_Setup_MSTR']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['SV_Invoice_Setup_MSTR'].MDFUSRID = ['Users Master'].USERID
63SV_Language_ID SearchSV Language IDINT2Integer2
64Time_Zone SearchTime ZoneSTR3String3
65WS_Checkbox1 SearchWS Checkbox1CBBoolean0
66WS_Checkbox_2 SearchWS Checkbox 2CBBoolean0
67WS_Checkbox_3 SearchWS Checkbox 3CBBoolean0
68WS_Checkbox_4 SearchWS Checkbox 4CBBoolean0
69WS_Checkbox_5 SearchWS Checkbox 5CBBoolean0
70WS_Checkbox_6 SearchWS Checkbox 6CBBoolean0
71WS_Checkbox_7 SearchWS Checkbox 7CBBoolean0
72WS_Checkbox_8 SearchWS Checkbox 8CBBoolean0
73WS_Checkbox_9 SearchWS Checkbox 9CBBoolean0
74WS_Checkbox_10 SearchWS Checkbox 10CBBoolean0
75WS_Checkbox_11 SearchWS Checkbox 11CBBoolean0
76WS_Checkbox_12 SearchWS Checkbox 12CBBoolean0
77WS_Checkbox_13 SearchWS Checkbox 13CBBoolean0
78WS_Checkbox_14 SearchWS Checkbox 14CBBoolean0
79WS_Checkbox_15 SearchWS Checkbox 15CBBoolean0
80WS_Checkbox_16 SearchWS Checkbox 16CBBoolean0
81WS_Checkbox_17 SearchWS Checkbox 17CBBoolean0
82WS_Checkbox_18 SearchWS Checkbox 18CBBoolean0
83WS_Checkbox_19 SearchWS Checkbox 19CBBoolean0
84WS_Checkbox_20 SearchWS Checkbox 20CBBoolean0

Leave a Reply

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