GP Tables

SV00515 - SV_Maint_Contract_Type_MSTR

SQL Query Builder

38 Columns

Column Description Type Length
Contract_Internal_Name char(15)
Contract_Description char(31)
Wennsoft_Affiliate char(15)
Wennsoft_Region char(15)
Wennsoft_Branch char(15)
USERID char(15)
Technician_ID char(15)
Technician_Team char(15)
Labor_Pct_Contract_Amt numeric(19,5)
Stand_Lbr_Cost_Per_Hr numeric(19,5)
Labor_Adjust_For_T_and_E numeric(19,5)
ATS_Percent_Labor numeric(19,5)
Labor_1_Percent_of_Labor numeric(19,5)
Labor_2_Percent_of_Labor numeric(19,5)
Labor_3_Percent_of_Labor numeric(19,5)
Labor_4_Percent_of_Labor numeric(19,5)
Labor_5_Percent_of_Labor numeric(19,5)
Pct_of_Contract_Equip numeric(19,5)
ATS_Percent_Equip numeric(19,5)
Pct_of_Contract_Material numeric(19,5)
ATS_Percent_Material numeric(19,5)
Percent_of_Contract_Subs numeric(19,5)
ATS_Percent_Subs numeric(19,5)
Pct_of_Contract_Other numeric(19,5)
ATS_Percent_Other numeric(19,5)
MODIFDT datetime
Modified_Time datetime
MDFUSRID char(15)
Time_Zone char(3)
WSReserved_CB1 tinyint
WSReserved_CB2 tinyint
WSReserved_CB3 tinyint
WSReserved_CB4 tinyint
WSReserved_CB5 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 SV00515. 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

USERID

AAG50001 AAG60001 AAG70001 ACTIVITY AHPSLH01 APR_APR30000 APR_APR30300 ASIEXP100

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

WSReserved_CB3

JC00102 JC00103 JC00104 JC00106 JC00107 JC00201 JC00203 JC00301

WSReserved_CB5

JC00102 JC00103 JC00104 JC00106 JC00107 JC00201 JC00203 JC00301

WSReserved_CB4

JC00102 JC00103 JC00104 JC00106 JC00107 JC00201 JC00203 JC00301