Module List > Module TM tables MfgTime
You are currently viewing the COMPANY database.
Change

COMPANY..MfgTime Table Definition

(COMPANY..)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
DCHDRNUM_I int
0

DCDTLNUM_I int
0

DATAENTRYTYPEADC_I smallint
0

MANUFACTUREORDER_I char
''

RTSEQNUM_I char
''

CB_I tinyint
0

NUMBERSCRAPPED_I numeric
0.00

ACTUALSTARTDATE_I datetime
'1/1/1900'

ACTUALSTARTTIME_I datetime
'1/1/1900'

ACTUALFINISHDATE_I datetime
'1/1/1900'

ACTUALFINISHTIME_I datetime
'1/1/1900'

SETUPCB_I tinyint
0

PIECES_I numeric
0.00

REJECTS_I numeric
0.00

WCID_I char
''

TMSHTDRTN_I char
''

JOBNUMBR char
''
Job Number...(more) Join Now SF010601.JOBNUMBR
LABORCODE_I char
''

PAYCODERATE1_I char
''

HOURS_I0 int
0

MINUTES smallint
0

EMPLOYID char
''
Employee I...(more) Join Now PA11801.EMPLOYID
join ... more text available
TB_Logbook_Commission_Ti numeric
0.00

TB_HoursInteger smallint
0

TB_MinutesInteger smallint
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