Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SV00305
Product: WennSoft Products (131)
Series: 3rd Party
Display Name: SV_Tool_Unit_MSTR
Physical Name: SV00305
Technical Name: SV_Tool_Unit_MSTRSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 SV_Tool_ID 
SV_Tool_ID LI6_U Long Integer 0 2 Tool_Kit_Required Tool Kit Required STR15_LBAU String 15 3 Tool_Unit Tool_Unit STR15_LBAU String 15 4 Toolkit_Description Toolkit Description STR30 String 30 5 Tool_Serial_Number Tool_Serial_Number STR30_LBAU String 30 6 Tool_Manufacturer Tool_Manufacturer STR25_LBU String 25 7 Tool_Make Tool_Make STR15_LBAU String 15 8 Tool_Model Tool_Model STR15_LBAU String 15 9 Purchase_Date SV Purchase Date DT_6 Date 6 10 Purchase_Price WS Purchase Price DLR14_RBS0_STR$ Currency 14 11 COSTAMNT Cost Amount DLR19_RBSO_UTR$ Currency 19 12 Tool_Calibration_Date Tool_Calibration_Date DATE_L Date 0 13 Tool_Last_Service_Date Tool_Last_Service_Date DATE Date 6 14 Tool_Next_Service_Date Tool_Next_Service_Date DATE Date 6 15 Out_Of_Service Out Of Service CB_Out_of_service Boolean 0 16 In_Service_Date In_Service_Date DATE_L Date 0 17 Out_Of_Service_Date Out_Of_Service_Date DATE_L Date 0 18 Wennsoft_Affiliate Wennsoft Affiliate STR15_LBAU String 15 19 Wennsoft_Branch Wennsoft Branch STR15_LBAU String 15 20 Wennsoft_Region Wennsoft Region STR15_LBAU String 15 21 MODIFDT Modified Date DT Date 8 22 Modified_Time Modified Time TM6 Time 6 23 MDFUSRID Modified User ID STR15 String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['SV_Tool_Unit_MSTR'].MDFUSRID AS 'SV_Tool_Unit_MSTR-Modified User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
SV00305 AS ['SV_Tool_Unit_MSTR']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['SV_Tool_Unit_MSTR'].MDFUSRID = ['Users Master'].USERID24 USERDEF1 User Defined 1 STR20 String 20 25 USERDEF2 User Defined 2 STR20 String 20 26 WSReserved_CB1 WSReserved CB1 CB Boolean 0 27 WSReserved_CB2 WSReserved CB2 CB Boolean 0 28 WSReserved_STR1 WSReserved STR1 STR10 String 10 29 WSReserved_STR2 WSReserved STR2 STR10 String 10 30 Notes Notes TX32000 Text 32000