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

COMPANY..LogRules Table Definition

(COMPANY..)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
LogRuleID char
''

TB_Logbook_Rule_Descript char
''

TB_PostedPayroll tinyint
0

TB_PostedProject tinyint
0

TB_Not_PostedPayroll tinyint
0

TB_Not_PostedProject tinyint
0

TB_Time_Changed_By char
''

TB_Time_Source_Code char
''

TB_Logbook_Form_Code char
''

TB_Logbook_Posted tinyint
0

TB_Logbook_Posted_to_PR tinyint
0

TB_Days_of_Week smallint
0

TB_Logbook_Date_Worked datetime
'1/1/1900'

TB_Log_Date datetime
'1/1/1900'

TB_Dates_to_Use smallint
0

TB_Log_Starting_Time datetime
'1/1/1900'

TB_Log_Starting_Time_Max datetime
'1/1/1900'

TB_Starting_Time_to_Use datetime
'1/1/1900'

TB_Log_Ending_Time datetime
'1/1/1900'

TB_Log_Ending_Time_Min datetime
'1/1/1900'

TB_Ending_Time_to_Use datetime
'1/1/1900'

TB_Log_Billable_Time numeric
0.00

TB_Logbook_Commission_Ti numeric
0.00

EMPLCLAS char
''

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

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

AA_Job_# char
''

AA_Job_#_to_Use char
''

AA_Job_Phase_ID char
''

AA_Job_Phase_ID_to_Use char
''

AA_Job_Step_ID char
''

AA_Job_Step_ID_to_Use char
''

LOCATNID char
''
Location I...(more) Join Now PA01101.LOCATNID
join ... more text available
TB_Location_ID_to_Use char
''

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

POSITIONCODE_I char
''

TB_Position_to_Use char
''

PAYCODE char
''

TB_Pay_Code_to_Use char
''

TB_Log_RuleReserve1ID char
''

TB_Log_RuleReserve2ID char
''

TB_Log_RuleReserve3ID char
''

TB_Log_RuleReserve1Date datetime
'1/1/1900'

TB_Log_RuleReserve2Date datetime
'1/1/1900'

TB_Log_RuleReserve3Date datetime
'1/1/1900'

TB_Log_RuleReserve1CB tinyint
0

TB_Log_RuleReserve2CB tinyint
0

TB_Log_RuleReserve3CB tinyint
0

TB_Log_RuleReserve1Time datetime
'1/1/1900'

TB_Log_RuleReserve2Time datetime
'1/1/1900'

TB_Log_RuleReserve3Time datetime
'1/1/1900'

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