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

COMPANY..TimeCard Table Definition

(COMPANY..)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
TB_Time_Card_# char
''

TB_TC_Wk_Beg_Date datetime
'1/1/1900'

TB_Contract_# char
''

CUSTNMBR char
''
Customer N...(more) Join Now PA01101.CUSTNMBR
join ... more text available
EMPLOYID char
''
Employee I...(more) Join Now PA11801.EMPLOYID
join ... more text available
Emp_ID_Approval_1 char
''

Emp_ID_Approval_2 char
''

DEPRTMNT char
''
Department...(more) Join Now WC010931.DEPRTMNT
join ... more text available
JOBTITLE char
''

TB_Cont_Reg_Bill numeric
0.00

TB_Cont_Reg_Time char
''

TB_Cont_Reg_Rate numeric
0.00

TB_TC_Reg_Mon_Hrs numeric
0.00

TB_TC_Reg_Tue_Hrs numeric
0.00

TB_TC_Reg_Wed_Hrs numeric
0.00

TB_TC_Reg_Thu_Hrs numeric
0.00

TB_TC_Reg_Fri_Hrs numeric
0.00

TB_TC_Reg_Sat_Hrs numeric
0.00

TB_TC_Reg_Sun_Hrs numeric
0.00

TB_TC_Reg_Hrs numeric
0.00

TB_TC_Reg_Bill_Hrs numeric
0.00

TB_Cont_OT_Daily tinyint
0

TB_Cont_OT_Bill numeric
0.00

TB_Cont_OT_Pay_Code char
''

TB_Cont_OT_Pay_Rate numeric
0.00

TB_TC_OT_Daily_Mon numeric
0.00

TB_TC_OT_Daily_Tues numeric
0.00

TB_TC_OT_Daily_Wed numeric
0.00

TB_TC_OT_Daily_Thur numeric
0.00

TB_TC_OT_Daily_Fri numeric
0.00

TB_TC_OT_Daily_Sat numeric
0.00

TB_TC_OT_Daily_Sun numeric
0.00

TB_TC_OT_Daily_Hrs numeric
0.00

TB_TC_OT_Daily_Bill numeric
0.00

TB_Cont_OT_Wk_Paid tinyint
0

TB_Cont_OT_Wkly_Act numeric
0.00

TB_Cont_OT_Wk_Bill numeric
0.00

TB_Cont_OT_Wk_Code char
''

TB_Cont_OT_Wk_Rate numeric
0.00

TB_TC_OT_Wk_Hrs numeric
0.00

TB_TC_OT_Wk_Bill_Hr numeric
0.00

TB_Cont_Other_Paid tinyint
0

TB_Cont_Other_Act numeric
0.00

TB_Cont_Other_Bill numeric
0.00

TB_Cont_Other_Code char
''

TB_Cont_Other_Rate numeric
0.00

TB_TC_Other_Hrs numeric
0.00

TB_TC_Other_Bill numeric
0.00

TB_TC_Hrs numeric
0.00

TB_TC_Bill_Hrs numeric
0.00

TB_TC_Desc_Mon char
''

TB_TC_Desc_Tues char
''

TB_TC_Desc_Wed char
''

TB_TC_Desc_Thur char
''

TB_TC_Desc_Fri char
''

TB_TC_Desc_Sat char
''

TB_TC_Desc_Sun char
''

TB_TC_Posted tinyint
0

TB_TC_Mon_Start_1 datetime
'1/1/1900'

TB_TC_Mon_Start_2 datetime
'1/1/1900'

TB_TC_Mon_Start_3 datetime
'1/1/1900'

TB_TC_Mon_End_1 datetime
'1/1/1900'

TB_TC_Mon_End_2 datetime
'1/1/1900'

TB_TC_Mon_End_3 datetime
'1/1/1900'

TB_TC_Tue_Start_1 datetime
'1/1/1900'

TB_TC_Tue_Start_2 datetime
'1/1/1900'

TB_TC_Tue_Start_3 datetime
'1/1/1900'

TB_TC_Tue_End_1 datetime
'1/1/1900'

TB_TC_Tue_End_2 datetime
'1/1/1900'

TB_TC_Tue_End_3 datetime
'1/1/1900'

TB_TC_Wed_Start_1 datetime
'1/1/1900'

TB_TC_Wed_Start_2 datetime
'1/1/1900'

TB_TC_Wed_Start_3 datetime
'1/1/1900'

TB_TC_Wed_End_1 datetime
'1/1/1900'

TB_TC_Wed_End_2 datetime
'1/1/1900'

TB_TC_Wed_End_3 datetime
'1/1/1900'

TB_TC_Thu_Start_1 datetime
'1/1/1900'

TB_TC_Thu_Start_2 datetime
'1/1/1900'

TB_TC_Thu_Start_3 datetime
'1/1/1900'

TB_TC_Thu_End_1 datetime
'1/1/1900'

TB_TC_Thu_End_2 datetime
'1/1/1900'

TB_TC_Thu_End_3 datetime
'1/1/1900'

TB_TC_Fri_Start_1 datetime
'1/1/1900'

TB_TC_Fri_Start_2 datetime
'1/1/1900'

TB_TC_Fri_Start_3 datetime
'1/1/1900'

TB_TC_Fri_End_1 datetime
'1/1/1900'

TB_TC_Fri_End_2 datetime
'1/1/1900'

TB_TC_Fri_End_3 datetime
'1/1/1900'

TB_TC_Sat_Start_1 datetime
'1/1/1900'

TB_TC_Sat_Start_2 datetime
'1/1/1900'

TB_TC_Sat_Start_3 datetime
'1/1/1900'

TB_TC_Sat_End_1 datetime
'1/1/1900'

TB_TC_Sat_End_2 datetime
'1/1/1900'

TB_TC_Sat_End_3 datetime
'1/1/1900'

TB_TC_Sun_Start_1 datetime
'1/1/1900'

TB_TC_Sun_Start_2 datetime
'1/1/1900'

TB_TC_Sun_Start_3 datetime
'1/1/1900'

TB_TC_Sun_End_1 datetime
'1/1/1900'

TB_TC_Sun_End_2 datetime
'1/1/1900'

TB_TC_Sun_End_3 datetime
'1/1/1900'

TB_TC_Detail_Logbk tinyint
0

AA_Focus_Field char
''

MDFUSRID char
''
User that ...(more) Join Now
join ... more text available
AA_Modify_Date datetime
'1/1/1900'

AA_Modify_Time datetime
'1/1/1900'

TB_TC_Hol_Hrs numeric
0.00

TB_TC_Hol_Fri_Hrs numeric
0.00

TB_TC_Hol_Mon_Hrs numeric
0.00

TB_TC_Hol_Sat_Hrs numeric
0.00

TB_TC_Hol_Sun_Hrs numeric
0.00

TB_TC_Hol_Thu_Hrs numeric
0.00

TB_TC_Hol_Tue_Hrs numeric
0.00

TB_TC_Hol_Wed_Hrs numeric
0.00

TB_TC_Sick_Hrs numeric
0.00

TB_TC_Sick_Fri_Hrs numeric
0.00

TB_TC_Sick_Mon_Hrs numeric
0.00

TB_TC_Sick_Sat_Hrs numeric
0.00

TB_TC_Sick_Sun_Hrs numeric
0.00

TB_TC_Sick_Thu_Hrs numeric
0.00

TB_TC_Sick_Tue_Hrs numeric
0.00

TB_TC_Sick_Wed_Hrs numeric
0.00

TB_TC_Vac_Hrs numeric
0.00

TB_TC_Vac_Fri_Hrs numeric
0.00

TB_TC_Vac_Mon_Hrs numeric
0.00

TB_TC_Vac_Sat_Hrs numeric
0.00

TB_TC_Vac_Sun_Hrs numeric
0.00

TB_TC_Vac_Thu_Hrs numeric
0.00

TB_TC_Vac_Tue_Hrs numeric
0.00

TB_TC_Vac_Wed_Hrs numeric
0.00

TB_Other1_Mon numeric
0.00

TB_Other1_Tues numeric
0.00

TB_Other1_Wed numeric
0.00

TB_Other1_Thur numeric
0.00

TB_Other1_Fri numeric
0.00

TB_Other1_Sat numeric
0.00

TB_Other1_Sun numeric
0.00

TB_Other1_Hrs numeric
0.00

TB_Other2_Mon numeric
0.00

TB_Other2_Tues numeric
0.00

TB_Other2_Wed numeric
0.00

TB_Other2_Thurs numeric
0.00

TB_Other2_Fri numeric
0.00

TB_Other2_Sat numeric
0.00

TB_Other2_Sun numeric
0.00

TB_Other2_Hrs numeric
0.00

TB_Other3_Mon numeric
0.00

TB_Other3_Tues numeric
0.00

TB_Other3_Wed numeric
0.00

TB_Other3_Thurs numeric
0.00

TB_Other3_Fri numeric
0.00

TB_Other3_Sat numeric
0.00

TB_Other3_Sun numeric
0.00

TB_Other3_Hrs numeric
0.00

TB_Other4_Mon numeric
0.00

TB_Other4_Tues numeric
0.00

TB_Other4_Wed numeric
0.00

TB_Other4_Thurs numeric
0.00

TB_Other4_Fri numeric
0.00

TB_Other4_Sat numeric
0.00

TB_Other4_Sun numeric
0.00

TB_Other4_Hrs numeric
0.00

TB_Other5_Mon numeric
0.00

TB_Other5_Tues numeric
0.00

TB_Other5_Wed numeric
0.00

TB_Other5_Thurs numeric
0.00

TB_Other5_Fri numeric
0.00

TB_Other5_Sat numeric
0.00

TB_Other5_Sun numeric
0.00

TB_Other5_Hrs numeric
0.00

TB_Other6_Mon numeric
0.00

TB_Other6_Tues numeric
0.00

TB_Other6_Wed numeric
0.00

TB_Other6_Thur numeric
0.00

TB_Other6_Fri numeric
0.00

TB_Other6_Sat numeric
0.00

TB_Other6_Sun numeric
0.00

TB_Other6_Hrs numeric
0.00

TB_Time_Card_Reg_Des char
''

TB_Time_Card_Sick_Des char
''

TB_Time_Card_Vac_Des char
''

TB_Time_Card_Holiday_Des char
''

TB_Time_Card_OT_Des char
''

TB_Time_Card_Oth1_Des char
''

TB_Time_Card_Oth2_Des char
''

TB_Time_Card_Oth3_Des char
''

TB_Time_Card_Oth4_Des char
''

TB_Time_Card_Oth5_Des char
''

TB_Time_Card_Oth6_Des char
''

TB_Pay_Code_Holiday char
''

TB_Pay_Code_Regular char
''

TB_Pay_Code_Sick char
''

TB_Pay_Code_Vacation char
''

TB_Pay_Code_Over_Time char
''

TB_Pay_Code_Other_1 char
''

TB_Pay_Code_Other_2 char
''

TB_Pay_Code_Other_3 char
''

TB_Pay_Code_Other_4 char
''

TB_Pay_Code_Other_5 char
''

TB_Pay_Code_Other_6 char
''

TB_TC_Sub_1_CB tinyint
0

TB_TC_App_1_CB tinyint
0

TB_TC_Sub_2_CB tinyint
0

TB_TC_App_2_CB 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