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

COMPANY..TimeClk2 Table Definition

(COMPANY..)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
EMPLOYID char
''
Employee I...(more) Join Now PA11801.EMPLOYID
join ... more text available
TB_DateClock_In datetime
'1/1/1900'

TB_DateClock_Out datetime
'1/1/1900'

TB_Location_IDClock_In char
''

TB_Location_IDClock_Out char
''

TB_Starting_TimeSchedule datetime
'1/1/1900'

TB_Starting_TimeActual datetime
'1/1/1900'

TB_Starting_TimeRounded datetime
'1/1/1900'

TB_Ending_TimeScheduled datetime
'1/1/1900'

TB_Ending_TimeActual datetime
'1/1/1900'

TB_Ending_TimeRounded datetime
'1/1/1900'

TB_CallerID_PhoneClockIn char
''

TB_CallerID_NameClockIn char
''

TB_CallerID_PhoneClockOu char
''

TB_Calle_ID_NameClockOut char
''

SEQNUMBR int
0
Sequence N...(more) Join Now HR2EMP02.SEQNUMBR
Routing_Step_ID char
''

Routing_Seq_Number 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