Module List >
Module Manufacturing tables
ICJC0001
You are currently viewing the COMPANY
database.
Change
|
COMPANY..ICJC0001 Table Definition
(COMPANY..Job Master File)
Field Definitions:
What is the 'source' column?
| JOBNUMBER_I |
char(31)
''
|
|
|
|
|
| JOBDESCRIPTION_I |
char(51)
''
|
|
|
|
|
| JOBSTATUS_I |
smallint
0
|
|
|
|
|
| JOBONHOLD_I |
tinyint
0
|
|
|
|
|
| JOBCANCELLED_I |
tinyint
0
|
|
|
|
|
| JOBCATEGORIES_I_1 |
smallint
0
|
|
|
|
|
| JOBCATEGORIES_I_2 |
smallint
0
|
|
|
|
|
| JOBCATEGORIES_I_3 |
smallint
0
|
|
|
|
|
| CUSTOMERID_I |
char(31)
''
|
|
|
|
|
| CHECKLISTI |
char(31)
''
|
|
|
|
|
| CUSTNAME |
char(65)
''
|
|
|
|
|
| ESTIMATEDSTARTDATE_I |
datetime
'1/1/1900'
|
|
|
|
|
| ESTIMATEDENDDATE_I |
datetime
'1/1/1900'
|
|
|
|
|
| ACTUALSTARTDATE_I |
datetime
'1/1/1900'
|
|
|
|
|
| ACTUALENDDATE_I |
datetime
'1/1/1900'
|
|
|
|
|
| CHECKBOXES_I_1 |
tinyint
0
|
|
|
|
|
| CHECKBOXES_I_2 |
tinyint
0
|
|
|
|
|
| CHECKBOXES_I_3 |
tinyint
0
|
|
|
|
|
| CHECKBOXES_I_4 |
tinyint
0
|
|
|
|
|
| CHECKBOXES_I_5 |
tinyint
0
|
|
|
|
|
| STRINGS_I_1 |
char(31)
''
|
|
|
|
|
| STRINGS_I_2 |
char(31)
''
|
|
|
|
|
| STRINGS_I_3 |
char(31)
''
|
|
|
|
|
| STRINGS_I_4 |
char(31)
''
|
|
|
|
|
| STRINGS_I_5 |
char(31)
''
|
|
|
|
|
| DATES_I_1 |
datetime
'1/1/1900'
|
|
|
|
|
| DATES_I_2 |
datetime
'1/1/1900'
|
|
|
|
|
| DATES_I_3 |
datetime
'1/1/1900'
|
|
|
|
|
| DATES_I_4 |
datetime
'1/1/1900'
|
|
|
|
|
| DATES_I_5 |
datetime
'1/1/1900'
|
|
|
|
|
| DOLLARS_I_1 |
numeric(19,5)
0.00
|
|
|
|
|
| DOLLARS_I_2 |
numeric(19,5)
0.00
|
|
|
|
|
| DOLLARS_I_3 |
numeric(19,5)
0.00
|
|
|
|
|
| DOLLARS_I_4 |
numeric(19,5)
0.00
|
|
|
|
|
| DOLLARS_I_5 |
numeric(19,5)
0.00
|
|
|
|
|
| LONGINTARRAY_1 |
int
0
|
|
|
|
|
| LONGINTARRAY_2 |
int
0
|
|
|
|
|
| LONGINTARRAY_3 |
int
0
|
|
|
|
|
| LONGINTARRAY_4 |
int
0
|
|
|
|
|
| LONGINTARRAY_5 |
int
0
|
|
|
|
|
| ESTIMATEDJOBREVENUE_I |
numeric(19,5)
0.00
|
|
|
|
|
| ESTIMATEDJOBEXPENSES_I |
numeric(19,5)
0.00
|
|
|
|
|
| ESTIMATEDJOBPROFIT_I |
numeric(19,5)
0.00
|
|
|
|
|
| ESTIMATEDJOBMARGIN_I |
numeric(19,5)
0.00
|
|
|
|
|
| PLANNEDJOBREVENUE_I |
numeric(19,5)
0.00
|
|
|
|
|
| PLANNEDJOBEXPENSES_I |
numeric(19,5)
0.00
|
|
|
|
|
| PLANNEDJOBPROFIT_I |
numeric(19,5)
0.00
|
|
|
|
|
| PLANNEDJOBMARGIN_I |
numeric(19,5)
0.00
|
|
|
|
|
| ACTUALJOBREVENUE_I |
numeric(19,5)
0.00
|
|
|
|
|
| ACTUALJOBEXPENSES_I |
numeric(19,5)
0.00
|
|
|
|
|
| ACTUALJOBPROFIT_I |
numeric(19,5)
0.00
|
|
|
|
|
| ACTUALJOBMARGIN_I |
numeric(19,5)
0.00
|
|
|
|
|
| CHANGEDATE_I |
datetime
'1/1/1900'
|
*Change Da...(more) Join Now
|
|
|
|
| USERID |
char(15)
''
|
The user t...(more) Join Now
|
|
|
join ... more text available
|
| MFGNOTEINDEX_I |
numeric(19,5)
0.00
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
|