Module List >
Module Manufacturing tables
WO010032
You are currently viewing the COMPANY
database.
Change
|
COMPANY..WO010032 Table Definition
(COMPANY..Manufacture Order Master)
Field Definitions:
What is the 'source' column?
| MANUFACTUREORDER_I |
char(31)
''
|
|
|
|
|
| DSCRIPTN |
char(31)
''
|
|
|
|
|
| MANUFACTUREORDERST_I |
smallint
0
|
div style=...(more) Join Now
|
|
|
|
| ITEMNMBR |
char(31)
''
|
Item Numbe...(more) Join Now
|
|
|
join ... more text available
|
| ARCHIVED_MO_I |
tinyint
0
|
|
|
|
|
| BOMCAT_I |
smallint
0
|
|
|
|
|
| BOMNAME_I |
char(15)
''
|
Bill of Ma...(more) Join Now
|
|
|
|
| ROUTINGNAME_I |
char(31)
''
|
|
|
|
|
| ENDQTY_I |
numeric(19,5)
0.00
|
|
|
|
|
| STARTQTY_I |
numeric(19,5)
0.00
|
|
|
|
|
| STRTDATE |
datetime
'1/1/1900'
|
Start Date...(more) Join Now
|
|
|
|
| STARTTIME_I |
datetime
'1/1/1900'
|
|
|
|
|
| ENDDATE |
datetime
'1/1/1900'
|
End Date ...(more) Join Now
|
|
|
|
| DRAWFROMSITE_I |
char(11)
''
|
|
|
|
|
| CHANGEDATE_I |
datetime
'1/1/1900'
|
*Change Da...(more) Join Now
|
HR2EMP02.CHANGEDATE_I
|
|
|
| USERID |
char(15)
''
|
The user t...(more) Join Now
|
|
|
join ... more text available
|
| SCHEDULEMETHOD_I |
smallint
0
|
|
|
|
|
| PROJEMPLOYEEHRSSUM_I |
numeric(19,5)
0.00
|
|
|
|
|
| PROJMACHINEHRSSUM_I |
numeric(19,5)
0.00
|
|
|
|
|
| MATPROJCOSTI_1 |
numeric(19,5)
0.00
|
|
|
|
|
| MATPROJCOSTI_2 |
numeric(19,5)
0.00
|
|
|
|
|
| MATFIXOHDPROJCOSTI_1 |
numeric(19,5)
0.00
|
|
|
|
|
| MATFIXOHDPROJCOSTI_2 |
numeric(19,5)
0.00
|
|
|
|
|
| MATVAROHDPROJCOST_1 |
numeric(19,5)
0.00
|
|
|
|
|
| MATVAROHDPROJCOST_2 |
numeric(19,5)
0.00
|
|
|
|
|
| LABPROJCOSTI_1 |
numeric(19,5)
0.00
|
|
|
|
|
| LABPROJCOSTI_2 |
numeric(19,5)
0.00
|
|
|
|
|
| LABFIXOHDPROJCOSTI_1 |
numeric(19,5)
0.00
|
|
|
|
|
| LABFIXOHDPROJCOSTI_2 |
numeric(19,5)
0.00
|
|
|
|
|
| LABVAROHDPROJCOSTI_1 |
numeric(19,5)
0.00
|
|
|
|
|
| LABVAROHDPROJCOSTI_2 |
numeric(19,5)
0.00
|
|
|
|
|
| MACHPROJCOSTI_1 |
numeric(19,5)
0.00
|
|
|
|
|
| MACHPROJCOSTI_2 |
numeric(19,5)
0.00
|
|
|
|
|
| MACHFIXOHDPROJCOSTI_1 |
numeric(19,5)
0.00
|
|
|
|
|
| MACHFIXOHDPROJCOSTI_2 |
numeric(19,5)
0.00
|
|
|
|
|
| MACHVAROHDPROJCOSTI_1 |
numeric(19,5)
0.00
|
|
|
|
|
| MACHVAROHDPROJCOSTI_2 |
numeric(19,5)
0.00
|
|
|
|
|
| POSTTOSITE_I |
char(11)
''
|
|
|
|
|
| LOTNUMBR |
char(21)
''
|
|
|
|
|
| SCHEDULINGPREFEREN_I |
char(21)
''
|
|
|
|
|
| PLANNAME_I |
char(15)
''
|
|
|
|
|
| ACTUALDEMAND_I |
numeric(19,5)
0.00
|
|
|
|
|
| MANUFACTUREORDPRI_I |
smallint
0
|
|
|
|
|
| Partial_Purge_Date |
datetime
'1/1/1900'
|
|
|
|
|
| NOTEINDX |
numeric(19,5)
0.00
|
Note Index...(more) Join Now
|
|
|
join ... more text available
|
| OUTSOURCED_I |
smallint
0
|
|
|
|
|
| COMPCALCOPTION |
smallint
0
|
|
|
|
|
| COMPLETECLOSEDATE |
datetime
'1/1/1900'
|
|
|
|
|
| PSTGDATE |
datetime
'1/1/1900'
|
|
|
|
|
| PLNNDSPPLID |
smallint
0
|
Planned Su...(more) Join Now
|
|
|
|
| PICKNUMBER |
char(17)
''
|
|
|
|
|
| QUICK_MO_I |
tinyint
0
|
|
|
|
|
| ROUTING_REVISION_LEVEL |
char(51)
''
|
|
|
|
|
| BOM_REVISION_LEVEL |
char(51)
''
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
|