Module List >
Module Manufacturing tables
RT010130
You are currently viewing the COMPANY
database.
Change
|
COMPANY..RT010130 Table Definition
(COMPANY..routing_line)
Field Definitions:
What is the 'source' column?
| ROUTINGNAME_I |
char(31)
''
|
|
|
|
|
| RTSEQNUM_I |
char(11)
''
|
|
|
|
|
| ITEMNMBR |
char(31)
''
|
Item Numbe...(more) Join Now
|
IV10201.ITEMNMBR
|
|
join ... more text available
|
| RTSEQTYPE_I |
smallint
0
|
|
|
|
|
| RTSEQDES_I |
char(101)
''
|
|
|
|
|
| WCID_I |
char(11)
''
|
|
|
|
|
| OPCODE_I |
char(7)
''
|
|
|
|
|
| RTGWCID_I |
char(13)
''
|
|
|
|
|
| RTMCID_I |
char(13)
''
|
|
|
|
|
| MACHINEID_I |
char(11)
''
|
|
|
|
|
| SETUPTIME_I |
numeric(19,5)
0.00
|
|
|
|
|
| MACHINETIME_I |
numeric(19,5)
0.00
|
|
|
|
|
| RUNTIME_I |
numeric(19,5)
0.00
|
|
|
|
|
| LABORTIME_I |
numeric(19,5)
0.00
|
|
|
|
|
| QUEUETIME_I |
numeric(19,5)
0.00
|
|
|
|
|
| CYCLETIME_I |
numeric(19,5)
0.00
|
|
|
|
|
| MOVETIME_I |
numeric(19,5)
0.00
|
|
|
|
|
| PERCENTCOMPLETE_I |
int
0
|
|
|
|
|
| QUANTITY_I |
numeric(19,5)
0.00
|
Quantity...(more) Join Now
|
|
|
|
| LABORCODE_I |
char(11)
''
|
|
|
|
|
| LABORCODE2_I |
char(11)
''
|
|
|
|
|
| RTPARNUM_I |
char(11)
''
|
|
|
|
|
| RTNEXNUM_I |
char(11)
''
|
|
|
|
|
| DWGNUM_I |
char(31)
''
|
|
|
|
|
| TOOLID_I |
char(15)
''
|
|
|
|
|
| WAITHOURS_I |
smallint
0
|
|
|
|
|
| MULTIPLEEMPLOYEEOP_I |
tinyint
0
|
|
|
|
|
| NUMOFEMP |
smallint
0
|
|
|
|
|
| LASTSEQUENCETODAY_I |
tinyint
0
|
|
|
|
|
| TAPENUMBER_I |
char(15)
''
|
|
|
|
|
| USERDEF1 |
char(21)
''
|
UserDefine...(more) Join Now
|
PM00200.USERDEF1
|
|
|
| USERDEF2 |
char(21)
''
|
UserDefine...(more) Join Now
|
PM00200.USERDEF2
|
|
|
| NOTEINDX |
numeric(19,5)
0.00
|
Note Index...(more) Join Now
|
|
|
join ... more text available
|
| MFGNOTEINDEX_I |
numeric(19,5)
0.00
|
|
|
|
|
| USERID |
char(15)
''
|
The user t...(more) Join Now
|
|
|
join ... more text available
|
| CREATDDT |
datetime
'1/1/1900'
|
Created Da...(more) Join Now
|
POP10100.CREATDDT
|
|
|
| CREATETIME_I |
datetime
'1/1/1900'
|
|
|
|
|
| CHANGEDATE_I |
datetime
'1/1/1900'
|
*Change Da...(more) Join Now
|
HR2EMP02.CHANGEDATE_I
|
|
|
| CHANGETIME_I |
datetime
'1/1/1900'
|
|
|
|
|
| AUTOBACKFLUSHLABOR_I |
tinyint
0
|
|
|
|
|
| AUTOBACKMACHINE_I |
tinyint
0
|
|
|
|
|
| NUMBEROFMACHINES_I |
smallint
0
|
|
|
|
|
| NUMBEROFCREWS_I |
smallint
0
|
|
|
|
|
| QAQCNEEDED_I |
tinyint
0
|
|
|
|
|
| POOFFSETDAYS |
smallint
0
|
|
|
|
|
| WIPOPPERMOSTARTQTY |
smallint
0
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
|