GP Tables

JC00203 - JC_Forecast_Total_MSTR

SQL Query Builder

17 Columns

Column Description Type Length
WS_Job_Number char(17)
Project_Number char(17)
Forecasted_Labor_TTD numeric(19,5)
Forecast_Materials_TTD numeric(19,5)
Forecast_Equipment_TTD numeric(19,5)
Forecasted_Subs_TTD numeric(19,5)
Forecast_Misc_Other_TTD numeric(19,5)
Forecast_UserDef1 numeric(19,5)
Forecast_UserDef2 numeric(19,5)
Forecast_UserDef3 numeric(19,5)
Forecast_UserDef4 numeric(19,5)
WSReserved_CB1 tinyint
WSReserved_CB2 tinyint
WSReserved_CB3 tinyint
WSReserved_CB4 tinyint
WSReserved_CB5 tinyint
DEX_ROW_ID int auto number (1,1)

Related Tables

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

DEX_ROW_ID

AAG00200 AAG00201 AAG00202 AAG00300 AAG00301 AAG00302 ACColumn AF00100

WSReserved_CB1

JC00102 JC00103 JC00104 JC00106 JC00107 JC00201 JC00301 JC00401

WSReserved_CB2

JC00102 JC00103 JC00104 JC00106 JC00107 JC00201 JC00301 JC00401

WSReserved_CB3

JC00102 JC00103 JC00104 JC00106 JC00107 JC00201 JC00301 JC00401

WSReserved_CB5

JC00102 JC00103 JC00104 JC00106 JC00107 JC00201 JC00301 JC00401

WSReserved_CB4

JC00102 JC00103 JC00104 JC00106 JC00107 JC00201 JC00301 JC00401

Forecasted_Labor_TTD

Forecast_Materials_TTD