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

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

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