GP Tables

SV00305 - SV_Tool_Unit_MSTR

SQL Query Builder

31 Columns

Column Description Type Length
SV_Tool_ID int
Tool_Kit_Required char(15)
Tool_Unit char(15)
Toolkit_Description char(31)
Tool_Serial_Number char(31)
Tool_Manufacturer char(25)
Tool_Make char(15)
Tool_Model char(15)
Purchase_Date datetime
Purchase_Price numeric(19,5)
COSTAMNT numeric(19,5)
Tool_Calibration_Date datetime
Tool_Last_Service_Date datetime
Tool_Next_Service_Date datetime
Out_Of_Service tinyint
In_Service_Date datetime
Out_Of_Service_Date datetime
Wennsoft_Affiliate char(15)
Wennsoft_Branch char(15)
Wennsoft_Region char(15)
MODIFDT datetime
Modified_Time datetime
MDFUSRID char(15)
USERDEF1 char(21)
USERDEF2 char(21)
WSReserved_CB1 tinyint
WSReserved_CB2 tinyint
WSReserved_STR1 char(11)
WSReserved_STR2 char(11)
DEX_ROW_ID int auto number (1,1)
Notes text

Related Tables

Tables that share columns with SV00305. Click "Join" to add to your query.

DEX_ROW_ID

AAG00200 AAG00201 AAG00202 AAG00300 AAG00301 AAG00302 ACColumn AF00100

MODIFDT

ASIEXP01 ASIEXP02 ASIEXP03 ASIEXP04 ASIEXP06 ASIEXP07 ASIEXP09 ASIEXP11

MDFUSRID

ASIEXP09 ASIEXP19 ASIEXP22 CM20200 CM20300 CT00002 CT00102 CT40401

Modified_Time

PDK10500 JC00102 JC00103 JC00104 JC00106 JC00107 JC00201 JC00301

WSReserved_CB1

JC00102 JC00103 JC00104 JC00106 JC00107 JC00201 JC00203 JC00301

WSReserved_CB2

JC00102 JC00103 JC00104 JC00106 JC00107 JC00201 JC00203 JC00301

Wennsoft_Affiliate

JC00102 JC00103 JC00106 JC00201 JC00401 JC00501 JC00601 JC00701

Wennsoft_Region

JC00102 JC00103 JC00106 JC00201 JC00401 JC00501 JC00601 JC00701

Wennsoft_Branch

JC00102 JC00103 JC00106 JC00201 JC00401 JC00501 JC00601 JC00701

WSReserved_STR1

JC00102 JC00103 JC00104 JC00106 JC00107 JC00201 JC00401 JC00600