Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SV99302
Product: WennSoft Products (131)
Series: 3rd Party
Display Name: SV_Service_Tasks_Equipment_MSTR_View
Physical Name: SV99302
Technical Name: SV_Service_Tasks_Equipment_MSTR_ViewSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 CUSTNMBR 
Customer Number STR15_RM_Customer_Number String 15 Key to the RM Customer MSTR (RM00101).
Click to show/hide
SELECT
['SV_Service_Tasks_Equipment_MSTR_View'].CUSTNMBR AS 'SV_Service_Tasks_Equipment_MSTR_View-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
SV99302 AS ['SV_Service_Tasks_Equipment_MSTR_View']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['SV_Service_Tasks_Equipment_MSTR_View'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR2 ADRSCODE Address Code STR15_Address_Code String 15 3 Service_Call_ID Service Call ID STR17_LBAU String 17 4 Equipment_ID Equipment ID STR30 String 30 5 Wennsoft_Master_Equip_ID Wennsoft Master Equipment ID STR30 String 30 6 CMPTFLAG Component Flag CB_Component_Item Boolean 0 7 Task_Line_Number Task Line Number LI_Sequence_Number Long Integer 10 8 Task_Code Task Code STR10 String 10 9 Sub_Task_Line_Number Sub Task Line Number LI_Sequence_Number Long Integer 10 10 Sub_Task_Code Sub Task Code STR10 String 10 11 Task_List_ID Task List ID STR10_LBAU String 10 12 Task_Description Task Description STR60 String 60 13 Task_Description_Long Task Description Long STR255 String 255 14 Skill_Level Skill Level STR15_LBAU String 15 15 Location_Equipment Location Equipment STR50_LBU String 50 16 Completion_Date SV Completion Date DT Date 8 17 Resolution_Code Resolution Code STR10 String 10 18 Trouble_Code Trouble Code STR10 String 10 19 Task_Status Task Status STR10_LBAU String 10 20 System WS System STR15_LBAU String 15 21 Major WS Major STR15_LBAU String 15 22 Sub_1 Sub 1 STR15_LBAU String 15 23 Sub_2 Sub 2 STR15_LBAU String 15 24 Sub_3 Sub 3 STR15_LBAU String 15 25 Sub_4 Sub 4 STR15_LBAU String 15 26 Estimate_Total_Cost Estimate Total Cost DLR14_RBS0_STR$ Currency 14 27 Estimate_Hours Estimate Hours LI6_S2 Long Integer 6 28 Estimate_Labor Estimate Labor DLR14_RBS0_STR$ Currency 14 29 Estimate_Equipment Estimate Equipment DLR14_RBS0_STR$ Currency 14 30 Estimate_Material Estimate Material DLR14_RBS0_STR$ Currency 14 31 Estimate_Subs Estimate Subs DLR14_RBS0_STR$ Currency 14 32 Estimate_Other Estimate Other DLR14_RBS0_STR$ Currency 14 33 Estimate_Labor_1 Estimate Labor 1 DLR14_RBS0_STR$ Currency 14 34 Estimate_Labor_1_Hours Estimate Labor 1 Hours LI6_S2 Long Integer 6 35 Estimate_Labor_2 Estimate Labor 2 DLR14_RBS0_STR$ Currency 14 36 Estimate_Labor_2_Hours Estimate Labor 2 Hours LI6_S2 Long Integer 6 37 Estimate_Labor_3 Estimate Labor 3 DLR14_RBS0_STR$ Currency 14 38 Estimate_Labor_3_Hours Estimate Labor 3 Hours LI6_S2 Long Integer 6 39 Estimate_Labor_4 Estimate Labor 4 DLR14_RBS0_STR$ Currency 14 40 Estimate_Labor_4_Hours Estimate Labor 4 Hours LI6_S2 Long Integer 6 41 Estimate_Labor_5 Estimate Labor 5 DLR14_RBS0_STR$ Currency 14 42 Estimate_Labor_5_Hours Estimate Labor 5 Hours LI6_S2 Long Integer 6 43 Billable_Equipment Billable Equipment DLR14_RBS0_STR$ Currency 14 44 Billable_Material Billable Material DLR14_RBS0_STR$ Currency 14 45 Billable_Subs Billable Subs DLR14_RBS0_STR$ Currency 14 46 Billable_Other Billable Other DLR14_RBS0_STR$ Currency 14 47 Billable_Labor_1 Billable Labor 1 DLR14_RBS0_STR$ Currency 14 48 Billable_Labor_2 Billable Labor 2 DLR14_RBS0_STR$ Currency 14 49 Billable_Labor_3 Billable Labor 3 DLR14_RBS0_STR$ Currency 14 50 Billable_Labor_4 Billable Labor 4 DLR14_RBS0_STR$ Currency 14 51 Billable_Labor_5 Billable Labor 5 DLR14_RBS0_STR$ Currency 14 52 Material_Kit_Required Material Kit Required STR30_Item_Number String 30 53 Material_Kit_Quantity Material Kit Quantity LI_7 Long Integer 7 54 Tool_Kit_Required Tool Kit Required STR15_LBAU String 15 55 SV_Actual_Time SV Actual Time LI6_S2 Long Integer 6 56 Coverage_Code Coverage Code INT5_U0 Integer 5 57 ITEMTYPE Item Type DDL_Item_Type Integer 0 58 Equipment_Type Equipment Type STR30 String 30 59 Wennsoft_Affiliate Wennsoft Affiliate STR15_LBAU String 15 60 Wennsoft_Region Wennsoft Region STR15_LBAU String 15 61 Wennsoft_Branch Wennsoft Branch STR15_LBAU String 15 62 CREATDDT Created Date DT Date 8 63 CRUSRID Created User ID STR15_User_ID String 15 64 MODIFDT Modified Date DT Date 8 65 Modified_Time Modified Time TM6 Time 6 66 MDFUSRID Modified User ID STR15 String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['SV_Service_Tasks_Equipment_MSTR_View'].MDFUSRID AS 'SV_Service_Tasks_Equipment_MSTR_View-Modified User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
SV99302 AS ['SV_Service_Tasks_Equipment_MSTR_View']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['SV_Service_Tasks_Equipment_MSTR_View'].MDFUSRID = ['Users Master'].USERID67 Time_Zone Time Zone STR3 String 3 68 Task_User_Define1 Task User Define1 STR20 String 20 69 Task_User_Define2 Task User Define2 STR20 String 20 70 Task_User_Define3 Task User Define3 STR30 String 30 71 Task_User_Define4 Task User Define4 STR30 String 30 72 Task_User_Define5 Task User Define5 LI6_S2 Long Integer 6 73 Task_User_Define6 Task User Define6 LI6_S2 Long Integer 6 74 Task_User_Define7 Task User Define7 LI6_S2 Long Integer 6 75 Task_User_Define8 Task User Define8 LI6_S2 Long Integer 6 76 Task_User_Define9 Task User Define9 DT Date 8 77 Task_User_Define10 Task User Define10 DT Date 8 78 Task_User_Define11 Task User Define11 DT Date 8 79 Task_User_Define12 Task User Define12 DT Date 8 80 Task_User_Define13 Task User Define13 DLR14_RBS0_STR$ Currency 14 81 Task_User_Define14 Task User Define14 DLR14_RBS0_STR$ Currency 14 82 Task_User_Define15 Task User Define15 DLR14_RBS0_STR$ Currency 14 83 Task_User_Define16 Task User Define16 DLR14_RBS0_STR$ Currency 14 84 Task_User_Define17 Task User Define17 DLR14_RBS0_STR$ Currency 14 85 Task_User_Define18 Task User Define18 CB Boolean 0 86 Task_User_Define19 Task User Define19 CB Boolean 0 87 Task_User_Define20 Task User Define20 CB Boolean 0 88 Task_User_Define21 Task User Define21 CB Boolean 0 89 Run_Units Run Units DLR14_RBS0_STR$ Currency 14 90 Current_Run_Units Current Run Units DLR14_RBS0_STR$ Currency 14 91 Last_Run_Units Last Run Units DLR14_RBS0_STR$ Currency 14 92 User_Define_1a User Define 1a STR30 String 30 93 Task_Comment_1 Task Comment 1 STR120 String 120 94 Task_Comment_2 Task Comment 2 STR120 String 120 95 Task_Comment_3 Task Comment 3 STR120 String 120 96 WSReserved_STR1 WSReserved STR1 STR10 String 10