Module List >
Module Manufacturing tables
MP040901
You are currently viewing the COMPANY
database.
Change
|
COMPANY..MP040901 Table Definition
(COMPANY..MRP_Routing_Line)
Field Definitions:
What is the 'source' column?
| MANUFACTUREORDER_I |
char(31)
''
|
|
|
|
|
| RTSEQNUM_I |
char(11)
''
|
|
|
|
|
| DONECB_I |
tinyint
0
|
|
|
|
|
| RTSEQTYPE_I |
smallint
0
|
|
|
|
|
| CLOSEDBY_I |
char(31)
''
|
|
|
|
|
| DATECLOSED_I |
datetime
'1/1/1900'
|
|
|
|
|
| TIMECLOSED_I |
datetime
'1/1/1900'
|
|
|
|
|
| RTSEQDES_I |
char(101)
''
|
|
|
|
|
| ACTUALFINISHDATE_I |
datetime
'1/1/1900'
|
|
|
|
|
| ACTUALFINISHTIME_I |
datetime
'1/1/1900'
|
|
|
|
|
| ACTUALSTARTDATE_I |
datetime
'1/1/1900'
|
|
|
|
|
| ACTUALSTARTTIME_I |
datetime
'1/1/1900'
|
|
|
|
|
| SCHEDULEFINISHDATE_I |
datetime
'1/1/1900'
|
|
|
|
|
| SCHEDULEFINISHTIME_I |
datetime
'1/1/1900'
|
|
|
|
|
| SCHEDULESTARTDATE_I |
datetime
'1/1/1900'
|
|
|
|
|
| SCHEDULESTARTTIME_I |
datetime
'1/1/1900'
|
|
|
|
|
| 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
|
|
|
|
|
| MRPAMOUNT_I |
numeric(19,5)
0.00
|
|
|
|
|
| LABORCODE_I |
char(11)
''
|
|
|
|
|
| LABORCODE2_I |
char(11)
''
|
|
|
|
|
| RTNEXNUM_I |
char(11)
''
|
|
|
|
|
| RTPARNUM_I |
char(11)
''
|
|
|
|
|
| PERCENTCOMPLETE_I |
int
0
|
|
|
|
|
| QUANTITY_I |
numeric(19,5)
0.00
|
Quantity...(more) Join Now
|
|
|
|
| DWGNUM_I |
char(31)
''
|
|
|
|
|
| TOOLID_I |
char(15)
''
|
|
|
|
|
| WAITHOURS_I |
smallint
0
|
|
|
|
|
| MULTIPLEEMPLOYEEOP_I |
tinyint
0
|
|
|
|
|
| NUMOFEMP |
smallint
0
|
|
|
|
|
| NUMBEROFCREWS_I |
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
|
|
|
| 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'
|
|
|
|
|
| CRPALLOCATED_I |
tinyint
0
|
|
|
|
|
| NOTEINDX |
numeric(19,5)
0.00
|
Note Index...(more) Join Now
|
|
|
join ... more text available
|
| MFGNOTEINDEX_I |
numeric(19,5)
0.00
|
|
|
|
|
| PIECES_I |
numeric(19,5)
0.00
|
|
|
|
|
| REJECTS_I |
numeric(19,5)
0.00
|
|
|
|
|
| AUTOBACKFLUSHLABOR_I |
tinyint
0
|
|
|
|
|
| AUTOBACKMACHINE_I |
tinyint
0
|
|
|
|
|
| NUMBEROFMACHINES_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
|
|
|
|
|