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

COMPANY..GLActTim Table Definition

(COMPANY..)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
EMPLOYID char
''
Employee I...(more) Join Now PA11801.EMPLOYID
join ... more text available
CUSTNMBR char
''
Customer N...(more) Join Now PA01101.CUSTNMBR
join ... more text available
Contact_Method_ID char
''

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

AA_Job_Phase_ID char
''

AA_Job_Step_ID char
''

TB_Revenue_Account_Index int
0

TB_Revenue_Account_1 char
''

TB_Revenue_Account_2 char
''

TB_Revenue_Account_3 char
''

TB_Revenue_Account_4 char
''

TB_Revenue_Account_5 char
''

TB_Revenue_Account_6 char
''

TB_Revenue_Account_7 char
''

TB_Revenue_Account_8 char
''

TB_Revenue_Account_9 char
''

TB_Revenue_Account_10 char
''

TB_Expense_Account_Index int
0

TB_Expense_Account_1 char
''

TB_Expense_Account_2 char
''

TB_Expense_Account_3 char
''

TB_Expense_Account_4 char
''

TB_Expense_Account_5 char
''

TB_Expense_Account_6 char
''

TB_Expense_Account_7 char
''

TB_Expense_Account_8 char
''

TB_Expense_Account_9 char
''

TB_Expense_Account_10 char
''

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