GP Tables

SV00534 - SV_Maint_Escalation_HIST

SQL Query Builder

72 Columns

Column Description Type Length
CUSTNMBR char(15)
ADRSCODE char(15)
Contract_Number char(11)
WSCONTSQ int
Contract_Amount numeric(19,5)
Escalation_Date datetime
Escalation_Year smallint
Escalation_Month smallint
Wennsoft_Affiliate char(15)
Wennsoft_Region char(15)
Wennsoft_Branch char(15)
New_Contract_Price numeric(19,5)
Next_Escalation_Date datetime
Escal_Notify_Days smallint
Escalation_Calc_Date datetime
Escalation_Calculated_By char(15)
Escalation_Approved tinyint
SLPRSNID char(15)
APPRVLDT datetime
Escalation_Idx_ID_Equip char(3)
Escal_Idx_ID_Material char(3)
Escalation_Idx_ID_Labor char(3)
Escalation_Index_ID_Subs char(3)
Escalation_Idx_ID_Other char(3)
Proposed_Billing_Equip numeric(19,5)
Prop_Billing_Material numeric(19,5)
Proposed_Billing_Labor numeric(19,5)
Proposed_Billing_Subs numeric(19,5)
Proposed_Billing_Other numeric(19,5)
Accepted_Billing_Equip numeric(19,5)
Accepted_Billing_Materl numeric(19,5)
Accepted_Billing_Labor numeric(19,5)
Accepted_Billing_Subs numeric(19,5)
Accepted_Billing_Other numeric(19,5)
Proposed_Estimate_Equip numeric(19,5)
Proposed_Est_Material numeric(19,5)
Proposed_Estimate_Labor numeric(19,5)
Proposed_Estimate_Subs numeric(19,5)
Proposed_Estimate_Other numeric(19,5)
Proposed_Estimate_Hours int
Accepted_Estimate_Equip numeric(19,5)
Accepted_Est_Material numeric(19,5)
Accepted_Estimate_Labor numeric(19,5)
Accepted_Estimate_Subs numeric(19,5)
Accepted_Estimate_Other numeric(19,5)
Accepted_Estimate_Hours int
Actual_Equipment numeric(19,5)
Actual_Material numeric(19,5)
Actual_Labor numeric(19,5)
Actual_Subs numeric(19,5)
Actual_Other numeric(19,5)
Actual_Hours int
Estimate_Equipment numeric(19,5)
Estimate_Material numeric(19,5)
Estimate_Labor numeric(19,5)
Estimate_Subs numeric(19,5)
Estimate_Other numeric(19,5)
Estimate_Hours int
POSTED tinyint
POSTEDDT datetime
SV_Language_ID smallint
MODIFDT datetime
Modified_Time datetime
MDFUSRID char(15)
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)

Related Tables

Tables that share columns with SV00534. 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

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

Wennsoft_Affiliate

JC00102 JC00103 JC00106 JC00201 JC00401 JC00501 JC00601 JC00701