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

COMPANY..TCR55 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
FRSTNAME char
''

LASTNAME char
''
Last Name:...(more) Join Now WC010300.LASTNAME
TB_Time_Clock_ID char
''

PASSWORD char
''

TB_Clock_Status smallint
0

TB_Clocked_In tinyint
0

TB_Clocked_Out tinyint
0

TB_Log_Date datetime
'1/1/1900'

TB_Time_Clocked_Out_Date datetime
'1/1/1900'

TB_Log_Ending_Time datetime
'1/1/1900'

TB_Log_Billable_Time numeric
0.00

TB_Log_Commission_Rate numeric
0.00

TB_Log_Extend_Commission numeric
0.00

TB_Log_Starting_Time datetime
'1/1/1900'

JOBTITLE char
''

UPRTRXCD char
''

DSCRIPTN char
''

DEPRTMNT char
''
Department...(more) Join Now WC010931.DEPRTMNT
join ... more text available
TB_Log_Billing_Rate numeric
0.00

CUSTNMBR char
''
Customer N...(more) Join Now PA01101.CUSTNMBR
join ... more text available
Customer_Name_55 char
''

AA_Job_# char
''

AA_JobEst_Name char
''

AA_Job_Phase_ID char
''

TB_Job_1st_Level_Descrip char
''

AA_Job_Step_ID char
''

TB_Job_2nd_Level_Descrip char
''

TB_Schedule_Start_Date datetime
'1/1/1900'

TB_Schedule_Start_Time datetime
'1/1/1900'

TB_Schedule_End_Date datetime
'1/1/1900'

TB_Schedule_End_Time datetime
'1/1/1900'

TB_Time_Clock_Enable_Log tinyint
0

TB_Time_Clock_Enable_Sch tinyint
0

TB_Time_Clock_Enable_Cal tinyint
0

TB_Time_Clock_Enable_Pri tinyint
0

TB_Time_Clock_Enable_Pa tinyint
0

TB_Time_Clock_Enable_Pay tinyint
0

TB_Time_Clock_CB_Res1 tinyint
0

TB_Time_Clock_CB_Res2 tinyint
0

TB_Time_Clock_CB_Res3 tinyint
0

TB_Time_Clock_CB_Res4 tinyint
0

TB_Time_Clock_CB_Res5 tinyint
0

TB_Time_Clock_CB_Res6 tinyint
0

TB_Time_Clock_CB_Res7 tinyint
0

TB_Time_Clock_CB_Res8 tinyint
0

TB_Time_Clock_CB_Res9 tinyint
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