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_MSTRSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 SV_Equipment_Test_Code 
SV Equipment Test Code STR30 String 30 2 CUSTNMBR Customer Number STR15_RM_Customer_Number String 15 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'].CUSTNMBR3 ADRSCODE Address Code STR15_Address_Code String 15 4 Contract_Number WS Contract Number STR10 String 10 5 Equipment_ID Equipment ID STR30 String 30 6 SV_Equipment_Test_Pass SV Equipment Test Pass GB Integer 0 7 Technician Technician STR10_LBAU String 10 8 SV_Test_Completion_Date SV Equipment Test Completion Date DT Date 8 9 SV_Test_Completion_Time SV Equipment Test Completion Time Time Time 0 10 SV_Test_NextSched_Date SV Equipment Test Next Schedule Date DT Date 8 11 SV_EqTest_CB_1 SV Equipment Test CB[1] CB Boolean 0 12 SV_EqTest_CB_2 SV Equipment Test CB[2] CB Boolean 0 13 SV_EqTest_CB_3 SV Equipment Test CB[3] CB Boolean 0 14 SV_EqTest_CB_4 SV Equipment Test CB[4] CB Boolean 0 15 SV_EqTest_CB_5 SV Equipment Test CB[5] CB Boolean 0 16 SV_EqTest_CB_6 SV Equipment Test CB[6] CB Boolean 0 17 SV_EqTest_CB_7 SV Equipment Test CB[7] CB Boolean 0 18 SV_EqTest_CB_8 SV Equipment Test CB[8] CB Boolean 0 19 SV_EqTest_CB_9 SV Equipment Test CB[9] CB Boolean 0 20 SV_EqTest_CB_10 SV Equipment Test CB[10] CB Boolean 0 21 SV_EqTest_CB_11 SV Equipment Test CB[11] CB Boolean 0 22 SV_EqTest_CB_12 SV Equipment Test CB[12] CB Boolean 0 23 SV_EqTest_CB_13 SV Equipment Test CB[13] CB Boolean 0 24 SV_EqTest_CB_14 SV Equipment Test CB[14] CB Boolean 0 25 SV_EqTest_CB_15 SV Equipment Test CB[15] CB Boolean 0 26 SV_EqTest_CB_16 SV Equipment Test CB[16] CB Boolean 0 27 SV_EqTest_CB_17 SV Equipment Test CB[17] CB Boolean 0 28 SV_EqTest_CB_18 SV Equipment Test CB[18] CB Boolean 0 29 SV_EqTest_CB_19 SV Equipment Test CB[19] CB Boolean 0 30 SV_EqTest_CB_20 SV Equipment Test CB[20] CB Boolean 0 31 SV_Equipment_Test_Result SV Equipment Test Results STR255 String 255 32 SV_EqTest_Date_1 SV Equipment Test Date[1] DT Date 8 33 SV_EqTest_Date_2 SV Equipment Test Date[2] DT Date 8 34 SV_EqTest_Date_3 SV Equipment Test Date[3] DT Date 8 35 SV_EqTest_Date_4 SV Equipment Test Date[4] DT Date 8 36 SV_EqTest_Date_5 SV Equipment Test Date[5] DT Date 8 37 SV_EqTest_Date_6 SV Equipment Test Date[6] DT Date 8 38 SV_EqTest_Date_7 SV Equipment Test Date[7] DT Date 8 39 SV_EqTest_Date_8 SV Equipment Test Date[8] DT Date 8 40 SV_EqTest_Date_9 SV Equipment Test Date[9] DT Date 8 41 SV_EqTest_Date_10 SV Equipment Test Date[10] DT Date 8 42 SV_EqTest_Date_11 SV Equipment Test Date[11] DT Date 8 43 SV_EqTest_Date_12 SV Equipment Test Date[12] DT Date 8 44 SV_EqTest_Date_13 SV Equipment Test Date[13] DT Date 8 45 SV_EqTest_Date_14 SV Equipment Test Date[14] DT Date 8 46 SV_EqTest_Date_15 SV Equipment Test Date[15] DT Date 8 47 SV_EqTest_Date_16 SV Equipment Test Date[16] DT Date 8 48 SV_EqTest_Date_17 SV Equipment Test Date[17] DT Date 8 49 SV_EqTest_Date_18 SV Equipment Test Date[18] DT Date 8 50 SV_EqTest_Date_19 SV Equipment Test Date[19] DT Date 8 51 SV_EqTest_Date_20 SV Equipment Test Date[20] DT Date 8 52 SV_EqTest_Number_1 SV Equipment Test Number[1] DLR14_U2 Currency 14 53 SV_EqTest_Number_2 SV Equipment Test Number[2] DLR14_U2 Currency 14 54 SV_EqTest_Number_3 SV Equipment Test Number[3] DLR14_U2 Currency 14 55 SV_EqTest_Number_4 SV Equipment Test Number[4] DLR14_U2 Currency 14 56 SV_EqTest_Number_5 SV Equipment Test Number[5] DLR14_U2 Currency 14 57 SV_EqTest_Number_6 SV Equipment Test Number[6] DLR14_U2 Currency 14 58 SV_EqTest_Number_7 SV Equipment Test Number[7] DLR14_U2 Currency 14 59 SV_EqTest_Number_8 SV Equipment Test Number[8] DLR14_U2 Currency 14 60 SV_EqTest_Number_9 SV Equipment Test Number[9] DLR14_U2 Currency 14 61 SV_EqTest_Number_10 SV Equipment Test Number[10] DLR14_U2 Currency 14 62 SV_EqTest_Number_11 SV Equipment Test Number[11] DLR14_U2 Currency 14 63 SV_EqTest_Number_12 SV Equipment Test Number[12] DLR14_U2 Currency 14 64 SV_EqTest_Number_13 SV Equipment Test Number[13] DLR14_U2 Currency 14 65 SV_EqTest_Number_14 SV Equipment Test Number[14] DLR14_U2 Currency 14 66 SV_EqTest_Number_15 SV Equipment Test Number[15] DLR14_U2 Currency 14 67 SV_EqTest_Number_16 SV Equipment Test Number[16] DLR14_U2 Currency 14 68 SV_EqTest_Number_17 SV Equipment Test Number[17] DLR14_U2 Currency 14 69 SV_EqTest_Number_18 SV Equipment Test Number[18] DLR14_U2 Currency 14 70 SV_EqTest_Number_19 SV Equipment Test Number[19] DLR14_U2 Currency 14 71 SV_EqTest_Number_20 SV Equipment Test Number[20] DLR14_U2 Currency 14 72 SV_EqTest_Long_1 SV Equipment Test Long[1] Long Int Long Integer 8 73 SV_EqTest_Long_2 SV Equipment Test Long[2] Long Int Long Integer 8 74 SV_EqTest_Long_3 SV Equipment Test Long[3] Long Int Long Integer 8 75 SV_EqTest_Long_4 SV Equipment Test Long[4] Long Int Long Integer 8 76 SV_EqTest_Long_5 SV Equipment Test Long[5] Long Int Long Integer 8 77 SV_EqTest_Long_6 SV Equipment Test Long[6] Long Int Long Integer 8 78 SV_EqTest_Long_7 SV Equipment Test Long[7] Long Int Long Integer 8 79 SV_EqTest_Long_8 SV Equipment Test Long[8] Long Int Long Integer 8 80 SV_EqTest_Long_9 SV Equipment Test Long[9] Long Int Long Integer 8 81 SV_EqTest_Long_10 SV Equipment Test Long[10] Long Int Long Integer 8 82 SV_EqTest_Long_11 SV Equipment Test Long[11] Long Int Long Integer 8 83 SV_EqTest_Long_12 SV Equipment Test Long[12] Long Int Long Integer 8 84 SV_EqTest_Long_13 SV Equipment Test Long[13] Long Int Long Integer 8 85 SV_EqTest_Long_14 SV Equipment Test Long[14] Long Int Long Integer 8 86 SV_EqTest_Long_15 SV Equipment Test Long[15] Long Int Long Integer 8 87 SV_EqTest_Long_16 SV Equipment Test Long[16] Long Int Long Integer 8 88 SV_EqTest_Long_17 SV Equipment Test Long[17] Long Int Long Integer 8 89 SV_EqTest_Long_18 SV Equipment Test Long[18] Long Int Long Integer 8 90 SV_EqTest_Long_19 SV Equipment Test Long[19] Long Int Long Integer 8 91 SV_EqTest_Long_20 SV Equipment Test Long[20] Long Int Long Integer 8 92 SV_EqTest_Str20_1 SV Equipment Test String20[1] STR20 String 20 93 SV_EqTest_Str20_2 SV Equipment Test String20[2] STR20 String 20 94 SV_EqTest_Str20_3 SV Equipment Test String20[3] STR20 String 20 95 SV_EqTest_Str20_4 SV Equipment Test String20[4] STR20 String 20 96 SV_EqTest_Str20_5 SV Equipment Test String20[5] STR20 String 20 97 SV_EqTest_Str50_1 SV Equipment Test String50[1] STR50 String 50 98 SV_EqTest_Str50_2 SV Equipment Test String50[2] STR50 String 50 99 SV_EqTest_Str50_3 SV Equipment Test String50[3] STR50 String 50 100 SV_EqTest_Str50_4 SV Equipment Test String50[4] STR50 String 50 101 SV_EqTest_Str50_5 SV Equipment Test String50[5] STR50 String 50 102 SV_EqTest_Str50_6 SV Equipment Test String50[6] STR50 String 50 103 SV_EqTest_Str50_7 SV Equipment Test String50[7] STR50 String 50 104 SV_EqTest_Str50_8 SV Equipment Test String50[8] STR50 String 50 105 SV_EqTest_Str50_9 SV Equipment Test String50[9] STR50 String 50 106 SV_EqTest_Str50_10 SV Equipment Test String50[10] STR50 String 50 107 SV_EqTest_Str50_11 SV Equipment Test String50[11] STR50 String 50 108 SV_EqTest_Str50_12 SV Equipment Test String50[12] STR50 String 50 109 SV_EqTest_Str50_13 SV Equipment Test String50[13] STR50 String 50 110 SV_EqTest_Str50_14 SV Equipment Test String50[14] STR50 String 50 111 SV_EqTest_Str50_15 SV Equipment Test String50[15] STR50 String 50 112 SV_EqTest_Str50_16 SV Equipment Test String50[16] STR50 String 50 113 SV_EqTest_Str50_17 SV Equipment Test String50[17] STR50 String 50 114 SV_EqTest_Str50_18 SV Equipment Test String50[18] STR50 String 50 115 SV_EqTest_Str50_19 SV Equipment Test String50[19] STR50 String 50 116 SV_EqTest_Str50_20 SV Equipment Test String50[20] STR50 String 50 117 SV_EqTest_Str100_1 SV Equipment Test String100[1] STR100 String 100 118 SV_EqTest_Str100_2 SV Equipment Test String100[2] STR100 String 100 119 SV_EqTest_Str100_3 SV Equipment Test String100[3] STR100 String 100 120 SV_EqTest_Str100_4 SV Equipment Test String100[4] STR100 String 100 121 SV_EqTest_Str100_5 SV Equipment Test String100[5] STR100 String 100 122 SV_EqTest_Str254_1 SV Equipment Test String254[1] STR255 String 255 123 SV_EqTest_Str254_2 SV Equipment Test String254[2] STR255 String 255 124 SV_EqTest_Str254_3 SV Equipment Test String254[3] STR255 String 255 125 SV_EqTest_Str254_4 SV Equipment Test String254[4] STR255 String 255 126 SV_EqTest_Str254_5 SV Equipment Test String254[5] STR255 String 255 127 SV_EqTest_Str254_6 SV Equipment Test String254[6] STR255 String 255 128 SV_EqTest_Str254_7 SV Equipment Test String254[7] STR255 String 255 129 SV_EqTest_Str254_8 SV Equipment Test String254[8] STR255 String 255 130 SV_EqTest_Str254_9 SV Equipment Test String254[9] STR255 String 255 131 SV_EqTest_Str254_10 SV Equipment Test String254[10] STR255 String 255 132 MODIFDT Modified Date DT Date 8 133 Modified_Time Modified Time TM6 Time 6 134 MDFUSRID Modified User ID STR15 String 15 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'].USERID135 SV_EqTest_Text SV Equipment Test Text TX32000 Text 32000