Module List > Module JC tables JC00203
You are currently viewing the COMPANY database.
Change

COMPANY..JC00203 Table Definition

(COMPANY..JC_Forecast_Total_MSTR)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
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)
Unique ide...(more) Join Now
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3