Module List >
Module Manufacturing tables
SF010502
You are currently viewing the COMPANY
database.
Change
|
COMPANY..SF010502 Table Definition
(COMPANY..Automated Data Collection Matched Records)
Field Definitions:
What is the 'source' column?
| EMPLOYID |
char(15)
''
|
Employee I...(more) Join Now
|
UPR00100.EMPLOYID
|
|
join ... more text available
|
| DATAENTRYTYPEADC_I |
smallint
0
|
|
|
|
|
| MANUFACTUREORDER_I |
char(31)
''
|
|
|
|
|
| ITEMNMBR |
char(31)
''
|
Item Numbe...(more) Join Now
|
IV10201.ITEMNMBR
|
|
join ... more text available
|
| ROUTINGNAME_I |
char(31)
''
|
|
|
|
|
| RTSEQNUM_I |
char(11)
''
|
|
|
|
|
| DONECB_I |
tinyint
0
|
|
|
|
|
| LABORCODE_I |
char(11)
''
|
|
|
|
|
| ACTUALSTARTDATE_I |
datetime
'1/1/1900'
|
|
|
|
|
| ACTUALSTARTTIME_I |
datetime
'1/1/1900'
|
|
|
|
|
| ACTUALFINISHDATE_I |
datetime
'1/1/1900'
|
|
|
|
|
| ACTUALFINISHTIME_I |
datetime
'1/1/1900'
|
|
|
|
|
| IDDSCRPT |
char(31)
''
|
|
|
|
|
| LABCODEDESC_I |
char(31)
''
|
|
|
|
|
| LABCODEPAYCODESEL_I |
smallint
0
|
|
|
|
|
| ELAPSEDTIME_I |
numeric(19,5)
0.00
|
|
|
|
|
| NUMBERSCRAPPED_I |
numeric(19,5)
0.00
|
|
|
|
|
| PIECES_I |
numeric(19,5)
0.00
|
|
|
|
|
| REJECTS_I |
numeric(19,5)
0.00
|
|
|
|
|
| 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
|
| SEQUENCECOST_I |
numeric(19,5)
0.00
|
|
|
|
|
| SETUPCB_I |
tinyint
0
|
|
|
|
|
| CB_I |
tinyint
0
|
|
|
|
|
| POSTABLE_I |
tinyint
0
|
|
|
|
|
| PAYRCORD |
char(7)
''
|
Pay Record...(more) Join Now
|
UPR40600.PAYRCORD
|
|
|
| PAYTYPE |
smallint
0
|
Pay Type: ...(more) Join Now
|
|
|
|
| PAYUNITRATE_I |
numeric(19,5)
0.00
|
|
|
|
|
| PIECECOST_I |
numeric(19,5)
0.00
|
|
|
|
|
| OPERATINGCOST_I |
numeric(19,5)
0.00
|
|
|
|
|
| FIXOVERMARK_I |
numeric(19,5)
0.00
|
|
|
|
|
| HOURPIECE1_I |
smallint
0
|
|
|
|
|
| VAROVERHDMARK_I |
numeric(19,5)
0.00
|
|
|
|
|
| HOURPIECE2_I |
smallint
0
|
|
|
|
|
| DATACOLLECTERR_I |
binary(4)
0
|
|
|
|
|
| BACHNUMB |
char(15)
''
|
Batch Numb...(more) Join Now
|
|
|
join ... more text available
|
| COMPTRNM |
int
0
|
|
|
|
|
| MFGNOTEINDEX_I |
numeric(19,5)
0.00
|
|
|
|
|
| Fixed_Overhead_Amount |
numeric(19,5)
0.00
|
|
|
|
|
| Variable_Overhead_Amount |
numeric(19,5)
0.00
|
|
|
|
|
| Acct_Array_1 |
int
0
|
|
|
|
|
| Acct_Array_2 |
int
0
|
|
|
|
|
| Acct_Array_3 |
int
0
|
|
|
|
|
| Acct_Array_4 |
int
0
|
|
|
|
|
| Acct_Array_5 |
int
0
|
|
|
|
|
| Acct_Array_6 |
int
0
|
|
|
|
|
| Cost_Array_1 |
numeric(19,5)
0.00
|
|
|
|
|
| Cost_Array_2 |
numeric(19,5)
0.00
|
|
|
|
|
| Cost_Array_3 |
numeric(19,5)
0.00
|
|
|
|
|
| Cost_Array_4 |
numeric(19,5)
0.00
|
|
|
|
|
| Cost_Array_5 |
numeric(19,5)
0.00
|
|
|
|
|
| Cost_Array_6 |
numeric(19,5)
0.00
|
|
|
|
|
| Job_Number |
char(31)
''
|
|
|
|
|
| SEQ_I |
int
0
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
|