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

COMPANY..SF010200 Table Definition

(COMPANY..Data Collection Transaction Log)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
DATAENTRYTYPE_I smallint
0

EMPLOYID char(15)
''
Employee I...(more) Join Now UPR00100.EMPLOYID
join ... more text available
LABORCODE_I char(11)
''

MANUFACTUREORDER_I char(31)
''

RTSEQNUM_I char(11)
''

ACTUALSTARTDATE_I datetime
'1/1/1900'

ACTUALSTARTTIME_I datetime
'1/1/1900'

DATE1 datetime
'1/1/1900'

TIME1 datetime
'1/1/1900'
Time Time...(more) Join Now POP10100.TIME1
ACTUALFINISHDATE_I datetime
'1/1/1900'

ACTUALFINISHTIME_I datetime
'1/1/1900'

ELAPSEDTIME_I numeric(19,5)
0.00

ITEMNMBR char(31)
''
Item Numbe...(more) Join Now IV10201.ITEMNMBR
join ... more text available
PIECES_I numeric(19,5)
0.00

REJECTS_I numeric(19,5)
0.00

PAYRCORD char(7)
''
Pay Record...(more) Join Now UPR40600.PAYRCORD
LABCODEPAYCODESEL_I smallint
0

COMPTRNM int
0

UPRBCHOR smallint
0

BACHNUMB char(15)
''
Batch Numb...(more) Join Now
join ... more text available
SUCPAYROLLTRX_I tinyint
0

TRANSACTIONRESULT_I smallint
0

DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now
COMMENTS1000_I text


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