GP Tables

JC30003 - JC_Job_MSTR_Summary_HIST

SQL Query Builder

106 Columns

Column Description Type Length
WS_Job_Number char(17)
PERIODID smallint
YEAR1 smallint
Project_Number char(17)
WS_Job_Name char(31)
Divisions char(15)
CUSTNMBR char(15)
JC_Contract_Number char(15)
Contract_Type smallint
WS_Billing_Type smallint
Contract_to_Date numeric(19,5)
Retention_Pct numeric(19,5)
Actual_Units_TTD numeric(19,5)
Act_Labor_Cost_TTD numeric(19,5)
Act_Materials_Cost_TTD numeric(19,5)
Act_Equipment_Cost_TTD numeric(19,5)
Act_Subs_Cost_TTD numeric(19,5)
Act_Misc_Other_Cost_TTD numeric(19,5)
Act_Cost_TTD_UserDef1 numeric(19,5)
Act_Cost_TTD_UserDef2 numeric(19,5)
Act_Cost_TTD_UserDef3 numeric(19,5)
Act_Cost_TTD_UserDef4 numeric(19,5)
Total_Actual_Cost numeric(19,5)
Orig_Contract_Amount numeric(19,5)
Contract_Earned numeric(19,5)
Contract_Earned_Curr_Mo numeric(19,5)
Billed_Labor_TTD_Mkup numeric(19,5)
Billed_Mat_Cst_TTD_Mkup numeric(19,5)
Billed_EquipTTD_Mkup numeric(19,5)
Billed_Subs_TTD_Mkup numeric(19,5)
Billed_Other_TTD_Mkup numeric(19,5)
Billed_UsrDef1_TTD_Mkup numeric(19,5)
Billed_UsrDef2_TTD_Mkup numeric(19,5)
Billed_UsrDef3_TTD_Mkup numeric(19,5)
Billed_UsrDef4_TTD_Mkup numeric(19,5)
Billed_Amount_TTD numeric(19,5)
Retention_Amount_TTD numeric(19,5)
Retention_Billed_TTD numeric(19,5)
Net_Billed_TTD numeric(19,5)
Cash_Received_TTD numeric(19,5)
MSCTXAMT numeric(19,5)
TAXAMNT numeric(19,5)
DISCAMNT numeric(19,5)
WROFAMNT numeric(19,5)
Last_Billing_Date datetime
Expected_Contract numeric(19,5)
Committed_Equipment_TTD numeric(19,5)
Committed_Materials_TTD numeric(19,5)
Committed_Labor_TTD numeric(19,5)
Committed_Subs_TTD numeric(19,5)
Committed_Other_TTD numeric(19,5)
Committed_TTD_UserDef1 numeric(19,5)
Committed_TTD_UserDef2 numeric(19,5)
Committed_TTD_UserDef3 numeric(19,5)
Committed_TTD_UserDef4 numeric(19,5)
Committed_Cost numeric(19,5)
Revsd_Equip_Forecasted numeric(19,5)
Revsd_Labor_Forecasted numeric(19,5)
Revsd_Materials_Forecst numeric(19,5)
Revsd_Subs_Forecast_Cst numeric(19,5)
Revsd_Other_Forecst_Cst numeric(19,5)
Revsd_Forecast_UserDef1 numeric(19,5)
Revsd_Forecast_UserDef2 numeric(19,5)
Revsd_Forecast_UserDef3 numeric(19,5)
Revsd_Forecast_UserDef4 numeric(19,5)
Tot_Revsd_Forecast_Cost numeric(19,5)
Confirmed_Chg_Order_Amt numeric(19,5)
In_Process_Chg_Ord_Amt numeric(19,5)
CO_Amount_UserDef1 numeric(19,5)
CO_Amount_UserDef2 numeric(19,5)
CO_Amount_UserDef3 numeric(19,5)
Est_Labor_Units_TTD numeric(19,5)
Act_Labor_Units_TTD numeric(19,5)
Total_Act_Plus_Markup numeric(19,5)
Revsd_Forecast_Lab_Units numeric(19,5)
User_Define_1 char(31)
User_Define_2 char(31)
USERDEF1 char(21)
USERDEF2 char(21)
User_Def_Integer_1 int
User_Def_Integer_2 int
User_Defined_Integer_3 int
User_Defined_Integer_4 int
User_Defined_Dollar_1 numeric(19,5)
User_Defined_Dollar_2 numeric(19,5)
User_Defined_Dollar_3 numeric(19,5)
User_Defined_Dollar_4 numeric(19,5)
USRDAT01 datetime
USRDAT02 datetime
User_Defined_Date_3 datetime
User_Defined_Date_4 datetime
User_Defined_CB_1 tinyint
User_Defined_CB_2 tinyint
User_Defined_CB_3 tinyint
User_Defined_CB_4 tinyint
Wennsoft_Affiliate char(15)
Wennsoft_Branch char(15)
Wennsoft_Region char(15)
MODIFDT datetime
Modified_Time datetime
MDFUSRID char(15)
SV_Language_ID smallint
Time_Zone char(3)
Technician_ID char(15)
Technician_Team char(15)
DEX_ROW_ID int auto number (1,1)

Related Tables

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

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

Time_Zone

CN00500 CN100100 JC00102 JC00103 JC00106 JC00201 JC00301 JC00401

SV_Language_ID

JC00102 JC00103 JC00106 JC00201 JC00301 JC00401 JC00501 JC00601

CUSTNMBR

ASIEXP02 ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP15 ASIEXP19 ASIEXP20 ASIEXP21