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

COMPANY..TimeSub Table Definition

(COMPANY..)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
TB_Logbook_Index numeric
0.00

NOTEID char
''

CUSTNMBR char
''
Customer N...(more) Join Now PA01101.CUSTNMBR
join ... more text available
ADRSCODE char
''
Address Co...(more) Join Now PA01101.ADRSCODE
TB_LogType char
''

TB_Log_Date datetime
'1/1/1900'

EMPLOYID char
''
Employee I...(more) Join Now PA11801.EMPLOYID
join ... more text available
AA_Job_# char
''

AA_Job_Phase_ID char
''

AA_Job_Step_ID char
''

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

UPRTRXCD char
''

VNDRNMBR char
''

VCHRNMBR char
''
Voucher Nu...(more) Join Now PP100101.VCHRNMBR
Contact_Method_ID char
''

TB_Affiliate_Code char
''

TB_Log_Starting_Time datetime
'1/1/1900'

TB_Log_Ending_Time datetime
'1/1/1900'

TB_Log_Billable_Time numeric
0.00

TB_Log_Billing_Rate numeric
0.00

TB_Log_Extended_Billing numeric
0.00

TB_Logbook_Commission_Ti numeric
0.00

TB_Log_Commission_Rate numeric
0.00

TB_Log_Extend_Commission numeric
0.00

TB_Log_Commission_Paid char
''

TB_Log_Comm_Paid_Date datetime
'1/1/1900'

TB_Logbook_Print_on_Bill tinyint
0

TB_Invoice_ID char
''

TB_Invoice_Number char
''

INVCNMBR char
''

TB_Logbook_Posted tinyint
0

TB_Logbook_Posted_to_PR tinyint
0

AA_Focus_Field char
''

TB_Hold tinyint
0

TB_Agent char
''

TB_Contract_# char
''

TB_Time_Card_# char
''

TB_DateClock_In datetime
'1/1/1900'

TB_DateClock_Out datetime
'1/1/1900'

TB_DatePaid datetime
'1/1/1900'

TB_DateWorked 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
''

TB_Time_Approved tinyint
0

TB_Time_Approved_by char
''

TB_Percent smallint
0

HRLYPYRT numeric
0.00

TB_Piece_Pay_Code char
''

TB_Piece_Pay_Rate numeric
0.00

TB_Pieces_Completed int
0

TB_Pieces_Rejected int
0

TB_Pieces_Scrapped int
0

LABORTIME_I numeric
0.00

TB_Estimated_Time numeric
0.00

TB_Done tinyint
0

TB_Setup tinyint
0

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

Routing_Seq_Number smallint
0

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

Cost_Center_ID char
''

TRXSOURC char
''

DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now
TB_Logbook_Description_T 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