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

COMPANY..MisPunch 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
''

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_Schedule_DateReserve_ datetime
'1/1/1900'

TB_Log_Comm_Paid_Date datetime
'1/1/1900'

TB_Logbook_Print_on_Bill tinyint
0

TB_Invoice_Number char
''

INVCNMBR char
''

TB_Schedule_IDReserve_#1 char
''

TB_Logbook_Posted tinyint
0

TB_Logbook_Posted_to_PR tinyint
0

AA_Focus_Field char
''

TB_Hold tinyint
0

TB_Time_Card_# char
''

TB_Employee_Report_To 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