SV_Tool_Unit_MSTR (SV00305)

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_MSTR

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1SV_Tool_ID SearchSV_Tool_IDLI6_ULong Integer40
2Tool_Kit_Required SearchTool Kit RequiredSTR15_LBAUString1615
3Tool_Unit SearchTool_UnitSTR15_LBAUString1615
4Toolkit_Description SearchToolkit DescriptionSTR30String3230
5Tool_Serial_Number SearchTool_Serial_NumberSTR30_LBAUString3230
6Tool_Manufacturer SearchTool_ManufacturerSTR25_LBUString2625
7Tool_Make SearchTool_MakeSTR15_LBAUString1615
8Tool_Model SearchTool_ModelSTR15_LBAUString1615
9Purchase_Date SearchSV Purchase DateDT_6Date46
10Purchase_Price SearchWS Purchase PriceDLR14_RBS0_STR$Currency1014
11COSTAMNT SearchCost AmountDLR19_RBSO_UTR$Currency1019
12Tool_Calibration_Date SearchTool_Calibration_DateDATE_LDate40
13Tool_Last_Service_Date SearchTool_Last_Service_DateDATEDate46
14Tool_Next_Service_Date SearchTool_Next_Service_DateDATEDate46
15Out_Of_Service SearchOut Of ServiceCB_Out_of_serviceBoolean20
16In_Service_Date SearchIn_Service_DateDATE_LDate40
17Out_Of_Service_Date SearchOut_Of_Service_DateDATE_LDate40
18Wennsoft_Affiliate SearchWennsoft AffiliateSTR15_LBAUString1615
19Wennsoft_Branch SearchWennsoft BranchSTR15_LBAUString1615
20Wennsoft_Region SearchWennsoft RegionSTR15_LBAUString1615
21MODIFDT SearchModified DateDTDate48
22Modified_Time SearchModified TimeTM6Time46
23MDFUSRID SearchModified User IDSTR15String1615
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'].USERID
24USERDEF1 SearchUser Defined 1STR20String2220
25USERDEF2 SearchUser Defined 2STR20String2220
26WSReserved_CB1 SearchWSReserved CB1CBBoolean20
27WSReserved_CB2 SearchWSReserved CB2CBBoolean20
28WSReserved_STR1 SearchWSReserved STR1STR10String1210
29WSReserved_STR2 SearchWSReserved STR2STR10String1210
30Notes SearchNotesTX32000Text232000

Leave a Reply

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