Module List > Module Manufacturing tables SF010502
You are currently viewing the COMPANY database.
Change

COMPANY..SF010502 Table Definition

(COMPANY..Automated Data Collection Matched Records)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
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
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3