SV_Equipment_Test_MSTR (SV00451)

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

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

Display Name: SV_Equipment_Test_MSTR
Physical Name: SV00451
Technical Name: SV_Equipment_Test_MSTR

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1SV_Equipment_Test_Code SearchSV Equipment Test CodeSTR30String3230
2CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString1615
Key to the RM Customer MSTR (RM00101).

Click to show/hide

SELECT
       ['SV_Equipment_Test_MSTR'].CUSTNMBR AS 'SV_Equipment_Test_MSTR-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       SV00451 AS ['SV_Equipment_Test_MSTR']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['SV_Equipment_Test_MSTR'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
3ADRSCODE SearchAddress CodeSTR15_Address_CodeString1615
4Contract_Number SearchWS Contract NumberSTR10String1210
5Equipment_ID SearchEquipment IDSTR30String3230
6SV_Equipment_Test_Pass SearchSV Equipment Test PassGBInteger20
7Technician SearchTechnicianSTR10_LBAUString1210
8SV_Test_Completion_Date SearchSV Equipment Test Completion DateDTDate48
9SV_Test_Completion_Time SearchSV Equipment Test Completion TimeTimeTime40
10SV_Test_NextSched_Date SearchSV Equipment Test Next Schedule DateDTDate48
11SV_EqTest_CB_1 SearchSV Equipment Test CB[1]CBBoolean20
12SV_EqTest_CB_2 SearchSV Equipment Test CB[2]CBBoolean20
13SV_EqTest_CB_3 SearchSV Equipment Test CB[3]CBBoolean20
14SV_EqTest_CB_4 SearchSV Equipment Test CB[4]CBBoolean20
15SV_EqTest_CB_5 SearchSV Equipment Test CB[5]CBBoolean20
16SV_EqTest_CB_6 SearchSV Equipment Test CB[6]CBBoolean20
17SV_EqTest_CB_7 SearchSV Equipment Test CB[7]CBBoolean20
18SV_EqTest_CB_8 SearchSV Equipment Test CB[8]CBBoolean20
19SV_EqTest_CB_9 SearchSV Equipment Test CB[9]CBBoolean20
20SV_EqTest_CB_10 SearchSV Equipment Test CB[10]CBBoolean20
21SV_EqTest_CB_11 SearchSV Equipment Test CB[11]CBBoolean20
22SV_EqTest_CB_12 SearchSV Equipment Test CB[12]CBBoolean20
23SV_EqTest_CB_13 SearchSV Equipment Test CB[13]CBBoolean20
24SV_EqTest_CB_14 SearchSV Equipment Test CB[14]CBBoolean20
25SV_EqTest_CB_15 SearchSV Equipment Test CB[15]CBBoolean20
26SV_EqTest_CB_16 SearchSV Equipment Test CB[16]CBBoolean20
27SV_EqTest_CB_17 SearchSV Equipment Test CB[17]CBBoolean20
28SV_EqTest_CB_18 SearchSV Equipment Test CB[18]CBBoolean20
29SV_EqTest_CB_19 SearchSV Equipment Test CB[19]CBBoolean20
30SV_EqTest_CB_20 SearchSV Equipment Test CB[20]CBBoolean20
31SV_Equipment_Test_Result SearchSV Equipment Test ResultsSTR255String256255
32SV_EqTest_Date_1 SearchSV Equipment Test Date[1]DTDate48
33SV_EqTest_Date_2 SearchSV Equipment Test Date[2]DTDate48
34SV_EqTest_Date_3 SearchSV Equipment Test Date[3]DTDate48
35SV_EqTest_Date_4 SearchSV Equipment Test Date[4]DTDate48
36SV_EqTest_Date_5 SearchSV Equipment Test Date[5]DTDate48
37SV_EqTest_Date_6 SearchSV Equipment Test Date[6]DTDate48
38SV_EqTest_Date_7 SearchSV Equipment Test Date[7]DTDate48
39SV_EqTest_Date_8 SearchSV Equipment Test Date[8]DTDate48
40SV_EqTest_Date_9 SearchSV Equipment Test Date[9]DTDate48
41SV_EqTest_Date_10 SearchSV Equipment Test Date[10]DTDate48
42SV_EqTest_Date_11 SearchSV Equipment Test Date[11]DTDate48
43SV_EqTest_Date_12 SearchSV Equipment Test Date[12]DTDate48
44SV_EqTest_Date_13 SearchSV Equipment Test Date[13]DTDate48
45SV_EqTest_Date_14 SearchSV Equipment Test Date[14]DTDate48
46SV_EqTest_Date_15 SearchSV Equipment Test Date[15]DTDate48
47SV_EqTest_Date_16 SearchSV Equipment Test Date[16]DTDate48
48SV_EqTest_Date_17 SearchSV Equipment Test Date[17]DTDate48
49SV_EqTest_Date_18 SearchSV Equipment Test Date[18]DTDate48
50SV_EqTest_Date_19 SearchSV Equipment Test Date[19]DTDate48
51SV_EqTest_Date_20 SearchSV Equipment Test Date[20]DTDate48
52SV_EqTest_Number_1 SearchSV Equipment Test Number[1]DLR14_U2Currency1014
53SV_EqTest_Number_2 SearchSV Equipment Test Number[2]DLR14_U2Currency1014
54SV_EqTest_Number_3 SearchSV Equipment Test Number[3]DLR14_U2Currency1014
55SV_EqTest_Number_4 SearchSV Equipment Test Number[4]DLR14_U2Currency1014
56SV_EqTest_Number_5 SearchSV Equipment Test Number[5]DLR14_U2Currency1014
57SV_EqTest_Number_6 SearchSV Equipment Test Number[6]DLR14_U2Currency1014
58SV_EqTest_Number_7 SearchSV Equipment Test Number[7]DLR14_U2Currency1014
59SV_EqTest_Number_8 SearchSV Equipment Test Number[8]DLR14_U2Currency1014
60SV_EqTest_Number_9 SearchSV Equipment Test Number[9]DLR14_U2Currency1014
61SV_EqTest_Number_10 SearchSV Equipment Test Number[10]DLR14_U2Currency1014
62SV_EqTest_Number_11 SearchSV Equipment Test Number[11]DLR14_U2Currency1014
63SV_EqTest_Number_12 SearchSV Equipment Test Number[12]DLR14_U2Currency1014
64SV_EqTest_Number_13 SearchSV Equipment Test Number[13]DLR14_U2Currency1014
65SV_EqTest_Number_14 SearchSV Equipment Test Number[14]DLR14_U2Currency1014
66SV_EqTest_Number_15 SearchSV Equipment Test Number[15]DLR14_U2Currency1014
67SV_EqTest_Number_16 SearchSV Equipment Test Number[16]DLR14_U2Currency1014
68SV_EqTest_Number_17 SearchSV Equipment Test Number[17]DLR14_U2Currency1014
69SV_EqTest_Number_18 SearchSV Equipment Test Number[18]DLR14_U2Currency1014
70SV_EqTest_Number_19 SearchSV Equipment Test Number[19]DLR14_U2Currency1014
71SV_EqTest_Number_20 SearchSV Equipment Test Number[20]DLR14_U2Currency1014
72SV_EqTest_Long_1 SearchSV Equipment Test Long[1]Long IntLong Integer48
73SV_EqTest_Long_2 SearchSV Equipment Test Long[2]Long IntLong Integer48
74SV_EqTest_Long_3 SearchSV Equipment Test Long[3]Long IntLong Integer48
75SV_EqTest_Long_4 SearchSV Equipment Test Long[4]Long IntLong Integer48
76SV_EqTest_Long_5 SearchSV Equipment Test Long[5]Long IntLong Integer48
77SV_EqTest_Long_6 SearchSV Equipment Test Long[6]Long IntLong Integer48
78SV_EqTest_Long_7 SearchSV Equipment Test Long[7]Long IntLong Integer48
79SV_EqTest_Long_8 SearchSV Equipment Test Long[8]Long IntLong Integer48
80SV_EqTest_Long_9 SearchSV Equipment Test Long[9]Long IntLong Integer48
81SV_EqTest_Long_10 SearchSV Equipment Test Long[10]Long IntLong Integer48
82SV_EqTest_Long_11 SearchSV Equipment Test Long[11]Long IntLong Integer48
83SV_EqTest_Long_12 SearchSV Equipment Test Long[12]Long IntLong Integer48
84SV_EqTest_Long_13 SearchSV Equipment Test Long[13]Long IntLong Integer48
85SV_EqTest_Long_14 SearchSV Equipment Test Long[14]Long IntLong Integer48
86SV_EqTest_Long_15 SearchSV Equipment Test Long[15]Long IntLong Integer48
87SV_EqTest_Long_16 SearchSV Equipment Test Long[16]Long IntLong Integer48
88SV_EqTest_Long_17 SearchSV Equipment Test Long[17]Long IntLong Integer48
89SV_EqTest_Long_18 SearchSV Equipment Test Long[18]Long IntLong Integer48
90SV_EqTest_Long_19 SearchSV Equipment Test Long[19]Long IntLong Integer48
91SV_EqTest_Long_20 SearchSV Equipment Test Long[20]Long IntLong Integer48
92SV_EqTest_Str20_1 SearchSV Equipment Test String20[1]STR20String2220
93SV_EqTest_Str20_2 SearchSV Equipment Test String20[2]STR20String2220
94SV_EqTest_Str20_3 SearchSV Equipment Test String20[3]STR20String2220
95SV_EqTest_Str20_4 SearchSV Equipment Test String20[4]STR20String2220
96SV_EqTest_Str20_5 SearchSV Equipment Test String20[5]STR20String2220
97SV_EqTest_Str50_1 SearchSV Equipment Test String50[1]STR50String5250
98SV_EqTest_Str50_2 SearchSV Equipment Test String50[2]STR50String5250
99SV_EqTest_Str50_3 SearchSV Equipment Test String50[3]STR50String5250
100SV_EqTest_Str50_4 SearchSV Equipment Test String50[4]STR50String5250
101SV_EqTest_Str50_5 SearchSV Equipment Test String50[5]STR50String5250
102SV_EqTest_Str50_6 SearchSV Equipment Test String50[6]STR50String5250
103SV_EqTest_Str50_7 SearchSV Equipment Test String50[7]STR50String5250
104SV_EqTest_Str50_8 SearchSV Equipment Test String50[8]STR50String5250
105SV_EqTest_Str50_9 SearchSV Equipment Test String50[9]STR50String5250
106SV_EqTest_Str50_10 SearchSV Equipment Test String50[10]STR50String5250
107SV_EqTest_Str50_11 SearchSV Equipment Test String50[11]STR50String5250
108SV_EqTest_Str50_12 SearchSV Equipment Test String50[12]STR50String5250
109SV_EqTest_Str50_13 SearchSV Equipment Test String50[13]STR50String5250
110SV_EqTest_Str50_14 SearchSV Equipment Test String50[14]STR50String5250
111SV_EqTest_Str50_15 SearchSV Equipment Test String50[15]STR50String5250
112SV_EqTest_Str50_16 SearchSV Equipment Test String50[16]STR50String5250
113SV_EqTest_Str50_17 SearchSV Equipment Test String50[17]STR50String5250
114SV_EqTest_Str50_18 SearchSV Equipment Test String50[18]STR50String5250
115SV_EqTest_Str50_19 SearchSV Equipment Test String50[19]STR50String5250
116SV_EqTest_Str50_20 SearchSV Equipment Test String50[20]STR50String5250
117SV_EqTest_Str100_1 SearchSV Equipment Test String100[1]STR100String102100
118SV_EqTest_Str100_2 SearchSV Equipment Test String100[2]STR100String102100
119SV_EqTest_Str100_3 SearchSV Equipment Test String100[3]STR100String102100
120SV_EqTest_Str100_4 SearchSV Equipment Test String100[4]STR100String102100
121SV_EqTest_Str100_5 SearchSV Equipment Test String100[5]STR100String102100
122SV_EqTest_Str254_1 SearchSV Equipment Test String254[1]STR255String256255
123SV_EqTest_Str254_2 SearchSV Equipment Test String254[2]STR255String256255
124SV_EqTest_Str254_3 SearchSV Equipment Test String254[3]STR255String256255
125SV_EqTest_Str254_4 SearchSV Equipment Test String254[4]STR255String256255
126SV_EqTest_Str254_5 SearchSV Equipment Test String254[5]STR255String256255
127SV_EqTest_Str254_6 SearchSV Equipment Test String254[6]STR255String256255
128SV_EqTest_Str254_7 SearchSV Equipment Test String254[7]STR255String256255
129SV_EqTest_Str254_8 SearchSV Equipment Test String254[8]STR255String256255
130SV_EqTest_Str254_9 SearchSV Equipment Test String254[9]STR255String256255
131SV_EqTest_Str254_10 SearchSV Equipment Test String254[10]STR255String256255
132MODIFDT SearchModified DateDTDate48
133Modified_Time SearchModified TimeTM6Time46
134MDFUSRID SearchModified User IDSTR15String1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['SV_Equipment_Test_MSTR'].MDFUSRID AS 'SV_Equipment_Test_MSTR-Modified User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       SV00451 AS ['SV_Equipment_Test_MSTR']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['SV_Equipment_Test_MSTR'].MDFUSRID = ['Users Master'].USERID
135SV_EqTest_Text SearchSV Equipment Test TextTX32000Text232000

Leave a Reply

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