Module List >
Module JC tables
JC00203
You are currently viewing the COMPANY
database.
Change
|
COMPANY..JC00203 Table Definition
(COMPANY..JC_Forecast_Total_MSTR)
Field Definitions:
What is the 'source' column?
| 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
|
|
|
|
|