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

COMPANY..Detail Table Definition

(COMPANY..)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
AA_Job_# char
''

AA_Job_Phase_ID char
''

AA_Job_Step_ID char
''

AA_Job_Status smallint
0

CUSTNMBR char
''
Customer N...(more) Join Now PA01101.CUSTNMBR
join ... more text available
AA_Sch_Completion_Date datetime
'1/1/1900'

AA_Actual_Completion_Dat datetime
'1/1/1900'

AA_Estimated_Hours int
0

AA_Estimated_Hourly_Rate numeric
0.00

AA_Estimated_Labor_Dolla numeric
0.00

AA_Estimated_Material_Do numeric
0.00

AA_Actual_Hours int
0

AA_Actual_Labor_Dollars numeric
0.00

AA_Actual_Material_Dolla numeric
0.00

AA_Aprove tinyint
0

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